车辆管理

it2023-05-05 75

工具类

// 工具类 package org.lizhenhua.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import sun.print.resources.serviceui; public class DBUtil { static { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getConn() { Connection conn = null; try { conn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;databaseName=usercar", "sa", "1"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } public static void close(Connection conn, PreparedStatement ps, ResultSet rs) { try { if (conn != null) conn.close(); if (ps != null) ps.close(); if (rs != null) rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

model数据

package org.lizhenhua.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import sun.print.resources.serviceui; public class DBUtil { static { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static Connection getConn() { Connection conn = null; try { conn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;databaseName=usercar", "sa", "1"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } public static void close(Connection conn, PreparedStatement ps, ResultSet rs) { try { if (conn != null) conn.close(); if (ps != null) ps.close(); if (rs != null) rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

增删改查获取id的方法

package org.lizhenhua.isBean; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.util.DBUtil; public class Selection { public static int update(String sql, Object[] objs) { int count = 0; Connection conn = null; PreparedStatement ps = null; conn = DBUtil.getConn(); try { ps = conn.prepareStatement(sql); for (int i = 0; i < objs.length; i++) { ps.setObject(i + 1, objs[i]); } count = ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.close(conn, ps, null); } return count; } public static UsersCar getId(Integer id) { Connection conn = null; PreparedStatement ps = null; UsersCar userCar = null; ResultSet rs = null; conn = DBUtil.getConn(); try { String sql = "select * from UsersCar where id=? "; ps = conn.prepareStatement(sql); ps.setObject(1, id); rs = ps.executeQuery(); if (rs.next()) { userCar = new UsersCar(); userCar.setId(rs.getInt(1)); userCar.setUserName(rs.getString(2)); userCar.setPwd(rs.getString(3)); userCar.setCarNum(rs.getString(4)); userCar.setColor(rs.getString(5)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.close(conn, ps, null); } return userCar; } public static UsersCar login(String userName, String pwd) { Connection conn = null; PreparedStatement ps = null; UsersCar userCar = null; ResultSet rs = null; conn = DBUtil.getConn(); try { String sql = "select * from UsersCar where user_name=? and pwd =? "; ps = conn.prepareStatement(sql); ps.setObject(1, userName); ps.setObject(2, pwd); rs = ps.executeQuery(); if (rs.next()) { userCar = new UsersCar(); userCar.setId(rs.getInt(1)); userCar.setUserName(rs.getString(2)); userCar.setPwd(rs.getString(3)); userCar.setCarNum(rs.getString(4)); userCar.setColor(rs.getString(5)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.close(conn, ps, null); } return userCar; } public static ArrayList<UsersCar> getMessage() { Connection conn = null; PreparedStatement ps = null; ArrayList<UsersCar> userList = new ArrayList<UsersCar>(); ResultSet rs = null; conn = DBUtil.getConn(); try { String sql = "select * from UsersCar "; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { UsersCar userCar = new UsersCar(); userCar.setId(rs.getInt(1)); userCar.setUserName(rs.getString(2)); userCar.setPwd(rs.getString(3)); userCar.setCarNum(rs.getString(4)); userCar.setColor(rs.getString(5)); userList.add(userCar); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.close(conn, ps, null); } return userList; } }

删除servlet

详情servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.isBean.Selection; public class DetailServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); Integer id = Integer.parseInt(request.getParameter("id")); UsersCar user = Selection.getId(id); request.setAttribute("usersDetail", user); request.getRequestDispatcher("detail.jsp").forward(request, response); } }

登录servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.isBean.Selection; public class LoginServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); String userName = request.getParameter("userName"); String pwd = request.getParameter("pwd"); UsersCar userCar = Selection.login(userName, pwd); if(userCar!=null){ request.setAttribute("userCar", userCar); request.getRequestDispatcher("success.jsp").forward(request, response); }else{ request.getRequestDispatcher("login.jsp").forward(request, response); } } }

注册servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.isBean.Selection; public class RegisterServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); String userName = request.getParameter("userName"); String pwd = request.getParameter("pwd"); String carNum = request.getParameter("carNum"); String color = request.getParameter("color"); String sql = "insert into UsersCar values(?,?,?,?)"; Object[] objs = { userName, pwd, carNum, color }; int count = Selection.update(sql, objs); if(count>0){ request.getRequestDispatcher("login.jsp").forward(request, response); }else{ request.getRequestDispatcher("register.jsp").forward(request, response); } } }

预备删除 servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.isBean.Selection; public class ToUpdateServlet extends HttpServlet { /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); Integer id = Integer.parseInt(request.getParameter("id")); UsersCar user = Selection.getId(id); request.setAttribute("usersToUpdate", user); request.getRequestDispatcher("toUpdate.jsp").forward(request, response); } }

删除servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.isBean.Selection; public class UpdateServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); Integer id = Integer.parseInt(request.getParameter("id")); String userName = request.getParameter("userName"); String pwd = request.getParameter("pwd"); String carNum = request.getParameter("carNum"); String color = request.getParameter("color"); String sql = "update UsersCar set user_name=?,pwd=?,car_num=?,color=? where id=?"; Object[] objs = { userName, pwd, carNum, color,id }; int count = Selection.update(sql, objs); request.getRequestDispatcher("usersList").forward(request, response); } }

页面查询信息servlet

package org.lizhenhua.action; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.lizhenhua.dao.UsersCar; import org.lizhenhua.isBean.Selection; public class UsersListServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html"); ArrayList<UsersCar> usersList = Selection.getMessage(); request.setAttribute("usersList", usersList); request.getRequestDispatcher("usersList.jsp").forward(request, response); } }

详情页面jsp

<%@ 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> <base href="<%=basePath%>"> <title>My JSP 'detail.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> 编号： <input type="text" value="${usersDetail.id }" readonly="readonly" /> <br /> 用户名： <input type="text" value="${usersDetail.userName }" readonly="readonly" /> <br /> 密码： <input type="password" value="${usersDetail.pwd }" readonly="readonly" /> <br /> 车牌号： <input type="text" value="${usersDetail.carNum}" readonly="readonly" /> <br /> 颜色： <input type="text" value="${usersDetail.color }" readonly="readonly" /> <br /> <a href="usersList">点击返回所有信息</a> </body> </html>

登录页面jsp

<%@ 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> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <form action="login" method="post"> 用户名： <input type="text" name="userName" /> <br /> 密码： <input type="password" name="pwd" /> <br /> <input type="submit" value="提交" /> <a href="register.jsp">还没有账号？点击注册</a> <br /> </form> </body> </html>

注册页面

<%@ 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> <base href="<%=basePath%>"> <title>My JSP 'register.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <form action="register" method="post"> 用户名： <input type="text" name="userName" /> <br /> 密码： <input type="password" name="pwd" /> <br /> 确认密码： <input type="password" name="pwd" /> <br /> 车牌号： <input type="text" name="carNum" /> <br /> 颜色： <input type="text" name="color" /> <br /> <input type="submit" value="注册" /> <br /> <a href="login.jsp">已有账号？点击登录</a> </form> </body> </html>

登陆成功页面 jsp

<%@ 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> <base href="<%=basePath%>"> <title>My JSP 'success.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <table> <tr> <th> 编号 </th> <th> 用户名 </th> <th> 密码 </th> <th> 车牌号 </th> <th> 车色 </th> </tr> <tr> <td> ${userCar.id} </td> <td> ${userCar.userName} </td> <td> ${userCar.pwd} </td> <td> ${userCar.carNum} </td> <td> ${userCar.color} </td> </tr> </table> <a href="usersList">点击查看其它信息</a> </body> </html>

修改页面jsp

<%@ 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> <base href="<%=basePath%>"> <title>My JSP 'toUpdate.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <form action="update" method="post"> 编号： <input type="text" name="id" value="${usersToUpdate.id }" readonly="readonly" /> <br /> 用户名： <input type="text" name="userName" value="${usersToUpdate.userName }" /> <br /> 密码： <input type="password" name="pwd" value="${usersToUpdate.pwd }" /> <br /> 车牌号： <input type="text" name="carNum" value="${usersToUpdate.carNum}" /> <br /> 颜色： <input type="text" name="color" value="${usersToUpdate.color }" /> <br /> <input type="submit" value="提交" /> <br /> </form> </body> </html>

详情页面jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <% 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> <base href="<%=basePath%>"> <title>My JSP 'usersList.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <table> <tr> <th> 编号 </th> <th> 用户名 </th> <th> 密码 </th> <th> 车牌号 </th> <th> 车色 </th> <th> 操作 </th> </tr> <c:forEach items="${usersList}" var="userCar"> <tr> <td> ${userCar.id} </td> <td> <a href="detail?id=${userCar.id}">${userCar.userName}</a> </td> <td> ${userCar.pwd} </td> <td> ${userCar.carNum} </td> <td> ${userCar.color} </td> <td> <a href="delete?id=${userCar.id}">删除</a> <a href="toUpdate?id=${userCar.id}">修改</a> </td> </tr> </c:forEach> </table> </body> </html>

最新回复(0)