第七周作业

主页面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  </head>
  
  <body>
    <form name="form1" method="post" action="kj.jsp" >
		<table>
		<tr>	
			<td>编号：</td>
				<td> <input type="text" name="sid" id="userName"  ></td>
			</tr>
			<tr>	
				<td>用户名：</td>
				<td> <input type="text" name="uname" id="userName"  ></td>
			</tr>
	        <tr>	
		 		<td>输入登录密码：</td>
				<td><input type="password" name="upwd" id="pwd"></td>
			</tr>
			
			<tr>	
				<td colspan="2"><input type="submit" value="登录">   <input type="submit" value="注册"></td>
			</tr>
		</table>
	</form>
  </body>
</html>

　　跳转页面

<%@page import="com.ss.dao.stuDao"%>
<%@page import="com.ss.bean.stu"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
	stu s = new stu();
	int id = Integer.parseInt(request.getParameter("sid"));
	s.setSid(id);
	String uname = request.getParameter("uname");
	s.setUname(uname);
	String upwd = request.getParameter("upwd");
	s.setUpwd(upwd);
	
   stuDao sd=new stuDao();
	if(sd.addstu(s)>0){
		//跳转注册成功页面 
	}else{
		//错误页面 
	}
%>
<%    
    if(uname.equals("zs")&&upwd.equals("123")){
    //跳转成功登录页面
    request.getRequestDispatcher("ok.jsp").forward(request, response);
    session.setAttribute("uname",uname);
    }
    else{
    //错误页面
    request.getRequestDispatcher("index.jsp").forward(request, response);
    }
%>

　　登陆成功

<%@ page language="java" import="java.util.*" contentType="text/html;charset=utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  </head>
  <body>
   成功登录！<br>
  </body>
</html>

　　stu

package com.ss.bean;

public class stu {
	private int sid;
	private String uname;
	private String upwd;
	//访问器
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUpwd() {
		return upwd;
	}
	public void setUpwd(String upwd) {
		this.upwd = upwd;
	}
	//构造器
	public stu(int sid, String uname, String upwd) {
		super();
		this.sid = sid;
		this.uname = uname;
		this.upwd = upwd;
	}
	public stu() {
		super();
	}	
}

　　stuDao

package com.ss.dao;

import java.sql.DriverManager;
import java.sql.PreparedStatement;

import com.ss.bean.stu;
import com.sun.corba.se.pept.transport.Connection;

public class stuDao {
	public int addstu(stu s){
		int i=0;
		
		try {
			//加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			//建立连接
			Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "root");			
			
			String sql="insert into stu values(?,?,?)";			
			
			PreparedStatement ps=((java.sql.Connection) con).prepareStatement(sql);
			ps.setInt(1, s.getSid());
			ps.setString(2, s.getUname());
			ps.setString(3, s.getUpwd());
			i=ps.executeUpdate();
			
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return i;
	}
	public int selectUser(stu u){
        int n=0;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=utf8", "root", "root");    
            String sql="select uname,upwd from stu where uname=?and upwd=?";    
            PreparedStatement ps=((java.sql.Connection) con).prepareStatement(sql);
            ps.setInt(1,u.getSid());
            ps.setString(2, u.getUname());
            ps.setString(3, u.getUpwd());
            n=ps.executeUpdate();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
        return n;
	}
}

　　

posted @ 2021-04-18 16:18  Yik-  阅读(31)  评论(0)    收藏  举报