Dao包

Userdao

package dao; import model.User; import util.DBUtil; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class UserDao { public int add(User user) { Connection connection = null; PreparedStatement pstmt =null; int count = 0; try{ connection = DBUtil.getConnection(); //获得执行sql的Statement对象 pstmt = connection.prepareStatement("insert into user (name,password,age)values(?,?,?)"); pstmt.setString (1,user.getName()); pstmt.setString (2,user.getPassword()); pstmt.setString (3,user.getAge()); //执行sql，获得结果 count = pstmt.executeUpdate(); System.out.println("insert操作："+count); return count; }catch (Exception e) { e.printStackTrace(); }finally { try { DBUtil.closeAll(null, pstmt, connection); } catch (SQLException e) { e.printStackTrace(); } } return count; } public int del(User user){ Connection connection = null; PreparedStatement pstmt = null; int count = 0; try{ connection = DBUtil.getConnection(); System.out.println("连接成功"); pstmt = connection.prepareStatement("delete from user where name=? and password=? and age = ?"); pstmt.setString(1,user.getName()); pstmt.setString(2,user.getPassword()); pstmt.setString(3,user.getAge()); count = pstmt.executeUpdate(); System.out.println("delete操作:"+count); return count; }catch (Exception e){ e.printStackTrace(); }finally { try { DBUtil.closeAll(null,pstmt,connection); } catch (SQLException e) { e.printStackTrace(); } } return count; } public User selectByName(String name){ ResultSet rs = null; Connection connection = null; PreparedStatement pstmt=null; DBUtil util=new DBUtil(); User user=new User(); try{ connection=util.getConnection(); pstmt=connection.prepareStatement("select*from a where name=?"); pstmt.setString(1,name); while(rs.next()){ user.setId(rs.getInt(1)); user.setName(rs.getString(2)); user.setPassword(rs.getString(3)); user.setAge(rs.getString(4)); } }catch (Exception e){ e.printStackTrace(); }finally { try{ util.closeAll(rs,pstmt,connection); }catch (SQLException e){ e.printStackTrace(); } return user; } } }

Model包

User

package model; public class User { private int id; private String name; private String password; private String age; //alt+insert public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getAge() { return age; } public void setAge(String age) { this.age = age; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", password='" + password + '\'' + ", age='" + age + '\'' + '}'; } }

Service包

UserService

package service; import dao.UserDao; import model.User; import java.sql.SQLException; public class UserService { UserDao userDao = new UserDao(); public int add(User user) { System.out.println("service中add方法被调用"); return userDao.add(user); } public int del(User user){ System.out.println("service中del方法被调用"); return userDao.del(user); } public User selectByName(String name){ return userDao.selectByName(name); } }

Servlet包

AddServlet

其中包含了insert添加，search搜索，delete删除 3种方法

package servlet; import model.User; import service.UserService; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.sql.SQLException; import static org.omg.IOP.TaggedProfileHelper.insert; public class AddServlet extends HttpServlet { UserService userService = new UserService(); protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException, IOException { System.out.println("执行了dopost"); String method = req.getParameter("method"); if(method.equals("save")){ insert(req,resp); }else if (method.equals("search")){ search(req,resp); } } public void insert(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException, IOException{ User user = new User(); String name = req.getParameter("name"); String password = req.getParameter("password"); String age = req.getParameter("age"); user.setName(name); user.setPassword(password); user.setAge(age); System.out.println(user); int count = userService.add(user); if(count>0) { resp.sendRedirect("/index.jsp"); }else{ resp.getWriter().write("<h1>failed</h1>"); } } public void search(HttpServletRequest req,HttpServletResponse resp) throws IOException { String name = req.getParameter("name"); User user1 = userService.selectByName(name); if(user1!=null){ resp.getWriter().write("用户名："+user1.getName()+"密码："+user1.getPassword()+"年龄："+user1.getAge()); } else{ resp.getWriter().write("失败！"); } } public void delete(HttpServletRequest req,HttpServletResponse resp) throws ServletException, IOException { User user = new User(); String name = req.getParameter("name"); String password = req.getParameter("password"); String age = req.getParameter("age"); user.setName(name); user.setPassword(password); user.setAge(age); System.out.println(user); int count = userService.del(user); if(count>0){ resp.sendRedirect("/index.jsp"); }else { resp.getWriter().write("<h2>failed</h2>"); } } }

hellowServlet

package servlet; import javax.servlet.*; import java.io.IOException; public class HelloServlet implements Servlet { @Override public void init(ServletConfig servletConfig) throws ServletException { } @Override public ServletConfig getServletConfig() { return null; } @Override public void service(ServletRequest servletRequest, ServletResponse servletResponse) throws ServletException, IOException { servletResponse.getWriter().write("hello,servelt"); } @Override public String getServletInfo() { return null; } @Override public void destroy() { } }

loginServlet

其中包含了登陆的方法，以及用“123”“123”的账号密码进行测试实验 在输入正确错误密码后各会弹出不同的页面。

package servlet; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; public class LoginServlet extends HttpServlet { protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException, IOException { String name = req.getParameter("name"); String password = req.getParameter("password"); if(name.equals("123")&&password.equals("123")){ resp.getWriter().write("success!"); }else{ resp.getWriter().write("failed!"); } } }

Util包

BDutil

package util; import java.sql.*; public class DBUtil { public static Connection getConnection() throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); System.out.println("连接数据库"); //创建连接 Connection connection = DriverManager.getConnection("jdbc:mysql:localhost:3306/a?useSSL=false","root","123456"); return connection; } public static void closeAll(ResultSet rs, Statement stmt,Connection conn) throws SQLException { if(rs!=null) { rs.close(); } if(stmt!=null){ stmt.close(); } if(conn!=null){ conn.close();; } } }

web包

Web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0"> <servlet> <servlet-name>helloServlet</servlet-name> <servlet-class>servlet.HelloServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>helloServlet</servlet-name> <url-pattern>/hello</url-pattern> </servlet-mapping> <servlet> <servlet-name>loginservlet</servlet-name> <servlet-class>servlet.LoginServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>loginservlet</servlet-name> <url-pattern>/login</url-pattern> </servlet-mapping> <servlet> <servlet-name>AddServlet</servlet-name> <servlet-class>servlet.AddServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>AddServlet</servlet-name> <url-pattern>/add</url-pattern> </servlet-mapping> </web-app>

add.jsp

注册页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>注册</title> </head> <body> <form action="/add?method=save" method="post"> name:<input name="name" type="text"> password:<input name="password" type="password"> age:<input name="age" type="text"> <input type="submit" value="注册"> </form> </body> </html>

delete.jsp

删除页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>注销账户</title> </head> <h1>注销</h1> <body> <form action="/del?method=delete" method="post"> <!-- 对应AddServlet中的if语句--> name:<input name="name" type="text"> password:<input name="password" type="password"> age:<input name="age" type="text"> <input type="submit" value="注销" > </form> </body> </html>

serch.jsp

搜索页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>查找</title> </head> <body> <form action="/add>method=search" method="post"> <input name="name" placeholder="请输入需要查找的名字"> <input type="submit" value="查找"> </form> </body> </html>

index.jsp

主页面（包含登陆功能）

<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>ASD</title> </head> <body> <form action="/login" method="post"> name:<input name="name" type="text"> password:<input name="password" type="password"> <input type="submit" value="login"> </form> <a href="add.jsp">跳转到注册页面</a> <a href="search.jsp">跳转到搜索页面</a> <a href="delete.jsp">跳转到删除页面</a> </body> </html>