工具类
// 工具类
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
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 DeleteServlet 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 {
response.setContentType("text/html");
Integer id= Integer.parseInt(request.getParameter("id"));
String sql = "delete from usersCar where id=?";
Object[] objs={id};
int count = Selection.update(sql, objs);
request.getRequestDispatcher("usersLsit").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 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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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>