这是结构图
jdbc连接数据库 package jdbc; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import com.mysql.jdbc.Connection; public class jdbc { public static Connection getConnection() throws SQLException, ClassNotFoundException { Class.forName(“com.mysql.jdbc.Driver”); String url=”jdbc:mysql://localhost:3306/test”; String username=”root”; String password=”123456″; Connection con=(Connection) DriverManager.getConnection(url,username,password); return con; } }
user存储用户 package user; public class user { private String Name; private String Password; public String getName() { return Name; } public void setName(String name) { Name = name; } public String getPassword() { return Password; } public void setPassword(String password) { Password = password; } }
userdao是登录注册的操作 package userdao; import java.sql.ResultSet; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; import jdbc.jdbc; import user.user; public class userdao{ public boolean select(user u) throws ClassNotFoundException, SQLException{ int x=0; jdbc j=new jdbc(); Connection con=j.getConnection(); Statement stmt=(Statement) con.createStatement(); String sql=”select Name,Password from t1″; ResultSet rs=stmt.executeQuery(sql); while(rs.next()){ System.out.println(u.getName()+rs.getString(1)); if(u.getName().equals(rs.getString(1))){ System.out.println(“能比较用户名了”); if(u.getPassword().equals(rs.getString(2))){ System.out.println(“匹配成功了”); x=1; break; } } } if(x==1) return true; else return false; } public boolean insert(user u) throws ClassNotFoundException, SQLException { // TODO Auto-generated method stub jdbc j=new jdbc(); Connection con=j.getConnection(); Statement stmt=(Statement) con.createStatement(); System.out.println(“得到连接”); String sql=”insert into t1 values(‘”+u.getName()+”‘,'”+u.getPassword()+”‘)”; int s=stmt.executeUpdate(sql); if(s>0) return true; return false; } }
RegistServlet 是注册功能的servlet import java.io.IOException; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import user.user; import userdao.userdao; /** * Servlet implementation class RegistServlet */ public class RegistServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String username=request.getParameter(“name”); String password=request.getParameter(“password”); user u=new user(); u.setName(username); u.setPassword(password); userdao us=new userdao(); boolean t = false; try { t=us.insert(u); } catch (ClassNotFoundException | SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(t==true){ response.sendRedirect(“/Servlet2/form.html”); }else{ response.sendRedirect(“/Servlet2/regist.html”); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
LoginServlet是登录功能的servlet import java.io.IOException; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import user.user; import userdao.userdao; /** * Servlet implementation class LoginServlet */ public class LoginServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { user u=new user(); String username=request.getParameter(“username”); String password=request.getParameter(“password”); u.setName(username); u.setPassword(password); userdao us=new userdao(); boolean x=false; try { x=us.select(u); } catch (ClassNotFoundException | SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(x==true){ response.sendRedirect(“/Servlet2/welcome.html”); }else{ response.sendRedirect(“/Servlet2/form.html”); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
toregist是跳转页面的servlet import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Servlet implementation class toregist */ public class toregist extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(“text/html;charset=utf-8”); response.sendRedirect(“/Servlet2/regist.html”); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
mysql数据库结构如图
