车辆管理

工具类

// 工具类
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>

  • 2
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值