LoginServlet.java ~~~ package zyw.web; import zyw.bean.User; import zyw.service.UserService; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.sql.SQLException; @WebServlet(name = "LoginServlet",urlPatterns = "/login") public class LoginServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String name = request.getParameter("name"); String password = request.getParameter("password"); UserService userService=new UserService(); User user=null; try { //調用service中登錄方法 user = userService.login(name, password); } catch (SQLException e) { e.printStackTrace(); } if (user!=null){ //登錄成功跳轉生鮮種類列表界面 response.sendRedirect(request.getContextPath()+"/category-list.jsp"); }else { //登錄失敗提示 response.setContentType("text/html;charset=utf-8"); response.getWriter().write("用戶登錄失敗"); } } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } } ~~~ UserService.java ~~~ package zyw.service; import zyw.bean.User; import zyw.dao.UserDao; import java.sql.SQLException; public class UserService { //1. 判斷注冊用戶是否存在 public boolean register(String name,String password,String email) { boolean register=false; UserDao userDao = new UserDao(); boolean checkUser = userDao.checkUser(name); //2. 如果不存在就將用戶信息添加到數據庫 if (checkUser) { register = userDao.register(name,password,email); } return register; } public User login(String name, String password) throws SQLException { UserDao userDao=new UserDao(); User user = userDao.login(name, password); return user; } } ~~~ UserDao.java ~~~ package zyw.dao; import com.mchange.v2.c3p0.ComboPooledDataSource; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanHandler; import zyw.bean.User; import java.sql.SQLException; public class UserDao { /** * 檢查用戶是否存在 * @param name * @return */ public boolean checkUser(String name){ try { ComboPooledDataSource dataSource=new ComboPooledDataSource(); QueryRunner queryRunner=new QueryRunner(dataSource); String sql="select name from user where name=?"; User user = queryRunner.query(sql, new BeanHandler<User>(User.class),name); //如果沒有查詢到數據 說明這個用戶名沒有注冊過 if (user==null) { return true; }else { return false; } } catch (SQLException e) { e.printStackTrace(); return false; } } /** * 用戶注冊 * @param * @return */ public boolean register(String name,String password,String email) { try { ComboPooledDataSource dataSource=new ComboPooledDataSource(); QueryRunner queryRunner=new QueryRunner(dataSource); String sql="insert into user values(null,?,?,?)"; int row = queryRunner.update(sql, name,password, email); //行數大于零說明注冊成功 if (row>0) { return true; }else { return false; } } catch (SQLException e) { e.printStackTrace(); return false; } } /** * 用戶登錄 */ public User login(String name, String password) throws SQLException { ComboPooledDataSource dataSource=new ComboPooledDataSource(); QueryRunner queryRunner=new QueryRunner(dataSource); String sql="select * from user where name=? and password=?"; User user = queryRunner.query(sql, new BeanHandler<User>(User.class),name,password); return user; } } ~~~ 結果，如果賬號密碼正確，則跳轉category-list.jsp頁面，如果錯誤