實(shí)現(xiàn)用戶登錄與注冊(cè)

1、數(shù)據(jù)庫(kù)create database student;use student;create table user(id int primary key auto_increment,user varchar(50) not null,pwd varchar(50) not null,name varchar(50) not null,sex varchar(50) not null,age int(50) not null);index.jsp base href= 歡迎來(lái)到學(xué)生管理系統(tǒng) !- 用戶登錄 用戶名： 密碼： 用戶注冊(cè)  addUser.jsp base href= 用戶

2、注冊(cè) !- 用戶注冊(cè) 用戶名： 密碼： 重輸密碼： 姓名： 性別： 男 女 年齡： Dao.javapackage dao;import getConnection.GetConnection;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import com.mysql.jdbc.ResultSet;import bean.User;public class Dao private Connection conn;private PreparedStateme

3、nt pstat;String sql=;/* * 用戶登錄*/public boolean logoin(User user) throws SQLException conn = GetConnection.getConnection(); boolean i = false; sql = select * from user where user=? and pwd=?; pstat = conn.prepareStatement(sql); pstat.setString(1, user.getUser(); pstat.setString(2, user.getPwd(); Resu

4、ltSet rs1 = (ResultSet) pstat.executeQuery(); if (rs1.next() i = true; rs1.close(); pstat.close(); else i = false ; rs1.close(); pstat.close(); conn.close(); return i;/* 用戶注冊(cè)*/public void addUser(User user) conn = GetConnection.getConnection(); sql = insert into user values(?,?,?,?,?); try pstat = c

5、onn.prepareStatement(sql); pstat.setString(1,user.getUser(); pstat.setString(2,user.getPwd(); pstat.setString(3,user.getName(); pstat.setString(4,user.getSex(); pstat.setInt(5,user.getAge(); pstat.executeUpdate(); pstat.close(); conn.close(); catch(SQLException e) e.printStackTrace(); User.javapacka

6、ge bean;public class User private String user;private String pwd;private String name;private String sex;private int age;public String getUser() return user;public void setUser(String user) this.user = user;public String getPwd() return pwd;public void setPwd(String pwd) this.pwd = pwd;public String

7、getName() return name;public void setName(String name) = name;public String getSex() return sex;public void setSex(String sex) this.sex = sex;public int getAge() return age;public void setAge(int age) this.age = age;GetConnection.javapackage getConnection;import java.sql.Connection;import

8、java.sql.DriverManager;import java.sql.SQLException;/* * 用JDBC的方法獲得數(shù)據(jù)庫(kù)的連接*/public class GetConnection /通過(guò)靜態(tài)方法注冊(cè)驅(qū)動(dòng)，獲得連接public static Connection getConnection() String driver = com.mysql.jdbc.Driver; String url = jdbc:mysql:/localhost/student; Connection con = null; try Class.forName(driver); try con

9、= DriverManager.getConnection(url,root,); catch (SQLException e) e.printStackTrace(); catch (ClassNotFoundException e) e.printStackTrace(); System.out.println(已獲得數(shù)據(jù)庫(kù)的連接); return con;/*public static void main(String args) getConnection();*/addUserServlet.javapackage servlet;import java.io.IOException

10、;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import dao.Dao;import bean.User;public class addUserServlet extends HttpServlet /* Destruction of the servlet. */public void destroy

11、() super.destroy(); / Just puts destroy string in log / Put your code herepublic void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException response.setContentType(text/html);doPost(request,response);public void doPost(HttpServletRequest request, HttpSe

12、rvletResponse response) throws ServletException, IOException response.setContentType(text/html); response.setCharacterEncoding(utf-8); String user1 = request.getParameter(user); String pwd = request.getParameter(pwd); String name = new String(request.getParameter(name).getBytes(ISO8859_1),utf-8); St

13、ring sex = new String(request.getParameter(sex).getBytes(ISO8859_1),utf-8); String age1 = request.getParameter(age); User user = new User(); user.setUser(user1); user.setPwd(pwd); user.setName(name); user.setSex(sex); int age; if(age1!=null) age = Integer.parseInt(age1); user.setAge(age); Dao dao =

14、new Dao(); dao.addUser(user);/* request.setAttribute(info,new String(添加成功！恭喜！ + ); request.setAttribute(id, new String(a); request.setAttribute(denglu,new String(登陸);*/ request.getRequestDispatcher(info.jsp).forward(request,response);public void init() throws ServletException / Put your code herelog

15、inServlet.javapackage servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import bean.User;imp

16、ort dao.Dao;public class loginServlet extends HttpServlet public void destroy() super.destroy(); / Just puts destroy string in log / Put your code herepublic void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(utf-8)

17、; response.setContentType(text/html); PrintWriter out = response.getWriter(); String name = new String (request.getParameter(user).getBytes(ISO8859_1), GBK); String pwd = new String (request.getParameter(pwd).getBytes(ISO8859_1),UTF-8); User user = new User(); user.setUser(name); user.setPwd(pwd); Dao dao = new Dao(); boolean isLogin; try isLogin = dao.logoin(user); if(isLogin) response.sendRedirect(My