项目预览
实现代码
/day_0509_01/src/com/qst/util/DBUtil.java
package com.qst.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
/**
* 得到数据库连接
*/
public Connection getConnection() {
// 通过Config获取数据库配置信息
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://39.105.54.45:3306/zhuxueliang?useUnicod=true&characterEncoding=utf-8";
String user ="root";
String pwd = "123";
try {
// 指定驱动程序
Class.forName(driver);
// 建立数据库连结
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
// 如果连接过程出现异常，抛出异常信息
//throw new SQLException("驱动错误或连接失败！");
return null;
}
return conn;
}
/**
* 释放资源
*/
public void closeAll() {
// 如果rs不空，关闭rs
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 如果pstmt不空，关闭pstmt
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 如果conn不空，关闭conn
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 执行SQL语句，可以进行查询
*/
public ResultSet executeQuery(String preparedSql, Object[] param) {
// 处理SQL,执行SQL
try {
// 得到PreparedStatement对象
pstmt = conn.prepareStatement(preparedSql);
if (param != null) {
for (int i = 0; i < param.length; i++) {
// 为预编译sql设置参数
pstmt.setObject(i + 1, param[i]);
}
}
// 执行SQL语句
rs = pstmt.executeQuery();
} catch (SQLException e) {
// 处理SQLException异常
e.printStackTrace();
}
return rs;
}
/**
* 执行SQL语句，可以进行增、删、改的操作，不能执行查询
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
* @throws ClassNotFoundException
*/
public int executeUpdate(String preparedSql, Object[] param) {
int num = 0;
// 处理SQL,执行SQL
try {
this.getConnection();
// 得到PreparedStatement对象
pstmt = conn.prepareStatement(preparedSql);
if (param != null) {
for (int i = 0; i < param.length; i++) {
// 为预编译sql设置参数
pstmt.setObject(i + 1, param[i]);
}
}
// 执行SQL语句
num = pstmt.executeUpdate();
} catch (SQLException e) {
// 处理SQLException异常
e.printStackTrace();
}finally {
this.closeAll();
}
return num;
}
public static void main(String[] args) {
DBUtil dbUtil = new DBUtil();
System.out.println(dbUtil.getConnection());
}
}
/day_0509_01/src/com/qst/pojos/User.java
package com.qst.pojos;
public class User {
// id,userName,userPwd,sex,age
private int id;
private String userName;
private String userPwd;
private String userRePwd;
private String sex;
private int age;
public User() {
super();
}
public User(String userName, String userPwd, String userRePwd, String sex, int age) {
super();
this.userName = userName;
this.userPwd = userPwd;
this.userRePwd = userRePwd;
this.sex = sex;
this.age = age;
}
public User(int id, String userName, String userPwd, String userRePwd, String sex, int age) {
super();
this.id = id;
this.userName = userName;
this.userPwd = userPwd;
this.userRePwd = userRePwd;
this.sex = sex;
this.age = age;
}
public User(int id, String userName, String userPwd, String sex, int age) {
super();
this.id = id;
this.userName = userName;
this.userPwd = userPwd;
this.sex = sex;
this.age = age;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getUserPwd() {
return userPwd;
}
public void setUserPwd(String userPwd) {
this.userPwd = userPwd;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getUserRePwd() {
return userRePwd;
}
public void setUserRePwd(String userRePwd) {
this.userRePwd = userRePwd;
}
/**
* 重写toString方法
*/
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append("用户Id " + id + "<br>");
sb.append("用户名 " + userName + "<br>");
sb.append("密码 " + userPwd + "<br>");
sb.append("性别 " + (sex.equals("1")?'男':'女') + "<br>");
sb.append("年龄 " + age + "<br>");
sb.append("<a href=\"/day_0509_01/UserAction?method=userList\">隐藏</a>");
return sb.toString();
}
}
/day_0509_01/src/com/qst/pojos/Page.java
package com.qst.pojos;
import java.util.List;
public class Page<T> {
private Integer pageNow;
// private Integer pageCount;
private Integer rowCount;
private Integer pageSize;
private List<T> pageRow;
public Page() {
super();
// TODO Auto-generated constructor stub
}
public Page(Integer pageNow,Integer rowCount, Integer pageSize, List<T> pageRow) {
super();
this.pageNow = pageNow;
this.rowCount = rowCount;
this.pageSize = pageSize;
this.pageRow = pageRow;
}
public Integer getPageNow() {
return pageNow;
}
public void setPageNow(Integer pageNow) {
this.pageNow = pageNow;
}
public Integer getPageCount() {
Integer pageCount = rowCount%pageSize==0?rowCount/pageSize:(rowCount/pageSize+1);
return pageCount;
}
/*public void setPageCount(Integer pageCount) {
this.pageCount = pageCount;
}*/
public Integer getRowCount() {
return rowCount;
}
public void setRowCount(Integer rowCount) {
this.rowCount = rowCount;
}
public Integer getPageSize() {
return pageSize;
}
public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}
public List<T> getpageRow() {
return pageRow;
}
public void setpageRow(List<T> pageRow) {
this.pageRow = pageRow;
}
}
/day_0509_01/src/com/qst/dao/UserDao.java
package com.qst.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.qst.pojos.Page;
import com.qst.pojos.User;
import com.qst.util.DBUtil;
public class UserDao {
DBUtil dbUtil = null;
public UserDao() {
super();
dbUtil = new DBUtil();
}
public int save(User user) {
// id,userName,userPwd,sex,age
String sql = "insert into t_User(userName,userPwd,sex,age) values(?,?,?,?)";
Object[] param = { user.getUserName(), user.getUserPwd(), user.getSex(), user.getAge() };
dbUtil.getConnection();
int result = dbUtil.executeUpdate(sql, param);
dbUtil.closeAll();
return result;
}
public List<User> findAll() {
List<User> users = new ArrayList<User>();
String sql = "select * from t_user";
dbUtil.getConnection();
ResultSet rs = dbUtil.executeQuery(sql, null);
try {
while (rs.next()) {
User user = new User(rs.getInt("id"), rs.getString("userName"), rs.getString("userPwd"),
rs.getString("sex"), rs.getInt("age"));
users.add(user);
}
return users;
} catch (SQLException e) {
e.printStackTrace();
return users;
} finally {
dbUtil.closeAll();
}
}
/**
* 查询方法
*
* @param userName
* @return User对象
*/
public User readUser(String userName) {
User user = null;
String sql = "select * from t_user where userName=?";
Object[] param = { userName };
dbUtil.getConnection();
ResultSet rs = dbUtil.executeQuery(sql, param);
try {
if (rs.next()) {
user = new User(rs.getInt("id"), rs.getString("userName"), rs.getString("userPwd"), rs.getString("sex"),
rs.getInt("age"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
dbUtil.closeAll();
}
return user;
}
/**
* 修改方法
*
* @param user
* @return result
*/
public int updateUser(User user) {
// id,userName,userPwd,sex,age
String sql = "update t_user set userPwd=?,sex=?,age=? where userName=?";
Object[] param = { user.getUserPwd(), user.getSex(), user.getAge(), user.getUserName() };
dbUtil.getConnection();
int result = dbUtil.executeUpdate(sql, param);
dbUtil.closeAll();
return result;
}
/**
* 删除方法
*
* @param id
* userId
* @return result
*/
public int deleteUser(Integer id) {
String sql = "delete from t_user where id=?";
Object[] param = { id };
dbUtil.getConnection();
int result = dbUtil.executeUpdate(sql, param);
dbUtil.closeAll();
return result;
}
public Page<User> queryPage(int pageSize, int pageNow) {
Page<User> page = new Page<User>();
page.setPageSize(pageSize);
page.setPageNow(pageNow);
String sql = "select count(*) from t_user";
dbUtil.getConnection();
ResultSet rs = dbUtil.executeQuery(sql, null);
try {
rs.next();
Integer rowCount = rs.getInt(1);
page.setRowCount(rowCount);
List<User> pageRow = new ArrayList<User>();
String preparedSql = "select * from t_user limit ?,?";
Object[] param = { page.getPageSize() *( page.getPageNow() - 1), page.getPageSize() };
ResultSet res = dbUtil.executeQuery(preparedSql, param);
while (res.next()) {
User user = new User(res.getInt("id"), res.getString("userName"), res.getString("userPwd"),
res.getString("sex"), res.getInt("age"));
pageRow.add(user);
}
page.setpageRow(pageRow);
} catch (SQLException e) {
e.printStackTrace();
} finally {
dbUtil.closeAll();
}
return page;
}
}
/day_0509_01/src/com/qst/service/UserService.java
package com.qst.service;
import java.util.List;
import com.qst.dao.UserDao;
import com.qst.pojos.Page;
import com.qst.pojos.User;
public class UserService {
UserDao userDao = null;
public UserService() {
super();
this.userDao = new UserDao();
}
// 业务逻辑
public boolean addUser(User user) {
// 判断用户的年龄是否大于16周岁
// 判断一下用户的密码是否包含特殊字符（汉子）
// 判断用户的密码和确认密码相同
// return userDao.save(user)>0;
int result = userDao.save(user);
if (result > 0) {
return true;
}
return false;
}
public List<User> getAllUserInfo() {
return userDao.findAll();
}
public User readUser(String userName) {
return userDao.readUser(userName);
}
public boolean updateUser(User user) {
int result = userDao.updateUser(user);
if (result > 0) {
return true;
}
return false;
}
public boolean deleteUser(Integer id) {
int result = userDao.deleteUser(id);
if (result > 0) {
return true;
}
return false;
}
public Page<User> queryPage(Integer pageSize, Integer pageNow) {
return userDao.queryPage(pageSize, pageNow);
}
}
/day_0509_01/src/com/qst/action/UserAction.java
package com.qst.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.qst.pojos.Page;
import com.qst.pojos.User;
import com.qst.service.UserService;
public class UserAction extends HttpServlet {
private static final long serialVersionUID = 1L;
public UserAction() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String method = request.getParameter("method");
if ("addUser".equals(method)) {
addUser(request, response);
} else if ("userList".equals(method)) {
showUserList(request, response);
} else if ("readUser".equals(method)) {
readUser(request, response);
} else {
deleteUser(request, response, method);
}
}
private void showUserList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
UserService userService = new UserService();
// List<User> userList = userService.getAllUserInfo();
String pageNow = request.getParameter("pageNow");
if (pageNow == null||pageNow.isEmpty()) {
Page<User> userList = userService.queryPage(5, 1);
request.setAttribute("userList", userList);
}else {
Page<User> userList = userService.queryPage(5, Integer.parseInt(pageNow));
request.setAttribute("userList", userList);
}
request.getRequestDispatcher("/userList.jsp").forward(request, response);
}
private void addUser(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String userName = request.getParameter("userName");
String userPwd = request.getParameter("userPwd");
String userRePwd = request.getParameter("userRePwd");
String ageStr = request.getParameter("age");
String sex = request.getParameter("sex");
if(userName==null||userPwd==null||userRePwd==null||ageStr==null||sex==null) {
request.getSession().setAttribute("message", "更新失败，请重新填写！");
response.sendRedirect("/day_0509_01/addUser.jsp");
}else {
User user = new User(userName, userPwd, userRePwd, sex, Integer.parseInt(ageStr));
UserService userService = new UserService();
// boolean flag = userService.booleanUser(userName);
User users = userService.readUser(userName);
if (users != null) {
userService.updateUser(user);
} else {
userService.addUser(user);
}
showUserList(request, response);
}
}
private void readUser(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String userName = request.getParameter("userName");
UserService userService = new UserService();
User users = userService.readUser(userName);
request.setAttribute("users", users.toString());
showUserList(request, response);
}
private void deleteUser(HttpServletRequest request, HttpServletResponse response, String method)
throws ServletException, IOException {
UserService userService = new UserService();
Integer id = Integer.parseInt(method);
userService.deleteUser(id);
showUserList(request, response);
}
}
/day_0509_01/WebContent/addUser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<font color="red">${message}</font>
<form action="/day_0509_01/UserAction" method="post">
<table>
<tr>
<th colspan="2">添加用户界面</th>
</tr>
<tr>
<td>用户名</td>
<td><input type="text" name="userName" placeholder="请输入用户名" /></td>
</tr>
<tr>
<td>密码</td>
<td><input type="text" name="userPwd" placeholder="请输入密码" /></td>
</tr>
<tr>
<td>确认密码</td>
<td><input type="text" name="userRePwd" placeholder="请输入密码" /></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="number" name="age" min="16" max="100" /></td>
</tr>
<tr>
<td>性别</td>
<td><input type="radio" name="sex" value="1" />男 <input
type="radio" name="sex" value="" />女</td>
</tr>
<tr>
<td colspan="2"><input type="hidden" value="addUser"
name="method" /> <input type="submit" value="更新数据" /></td>
</tr>
</table>
</form>
</body>
</html>/day_0509_01/WebContent/userList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
import="com.qst.pojos.Page" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body style="text-align: center">
<form action="/day_0509_01/UserAction" method="post">
用户名：<input type="text" name="userName" /> <input type="hidden"
value="readUser" name="method"> <input type="submit"
value="查询">
</form>
${users}
<br />
<table border="1" cellspacing="0" style="width: 75%" align="center">
<tr>
<th>ID</th>
<th>用户名</th>
<th>密码</th>
<th>性别</th>
<th>年龄</th>
<th>更新</th>
<th>删除</th>
</tr>
<c:forEach items="${userList.pageRow}" var="user">
<tr>
<td>${user.id }</td>
<td>${user.userName }</td>
<td>${user.userPwd }</td>
<td>${user.sex==0?'女':'男' }</td>
<td>${user.age }</td>
<td><a href="addUser.jsp">更新</a></td>
<td><a href="/day_0509_01/UserAction?method=${user.id }">删除</a></td>
</tr>
</c:forEach>
</table>
<br />
<c:out value="第${userList.pageNow}页/共${userList.pageCount}页"></c:out>
<a href="<c:url value="UserAction?method=userList&pageNow=${1}" />">首页</a>
<c:if test="${userList.pageNow > 1}">
<a href="<c:url value="UserAction?method=userList&pageNow=${userList.pageNow-1}" />">上一页</a>
</c:if>
<c:choose>
<c:when test="${userList.pageCount < 5 }">
<c:set var="begin" value="1" />
<c:set var="end" value="${userList.pageCount}" />
</c:when>
<c:otherwise>
<c:set var="begin" value="${userList.pageNow - 2 }" />
<c:set var="end" value="${userList.pageNow + 2 }" />
<c:if test="${begin < 1 }">
<c:set var="begin" value="${1}" />
<c:set var="end" value="${5}" />
</c:if>
<c:if test="${end > userList.pageCount }">
<c:set var="begin" value="${userList.pageCount-4}" />
<c:set var="end" value="${userList.pageCount}" />
</c:if>
</c:otherwise>
</c:choose>
<c:forEach var="i" begin="${begin }" end="${end }">
<c:choose>
<c:when test="${i eq userList.pageNow }">
[${i}]
</c:when>
<c:otherwise>
<a href="<c:url value="UserAction?method=userList&pageNow=${i}" />">[${i}]</a>
</c:otherwise>
</c:choose>
</c:forEach>
<c:if test="${userList.pageNow < userList.pageCount}">
<a href="<c:url value="UserAction?method=userList&pageNow=${userList.pageNow+1}" />">下一页</a>
</c:if>
<a href="<c:url value="UserAction?method=userList&pageNow=${userList.pageCount}" />">尾页</a>
</body>
</html>/day_0509_01/WebContent/WEB-INF/web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>day_0509_01</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>UserAction</servlet-name>
<servlet-class>com.qst.action.UserAction</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UserAction</servlet-name>
<url-pattern>/UserAction</url-pattern>
</servlet-mapping>
</web-app>t_user.sql
/*
SQLyog Ultimate - MySQL GUI v8.2
MySQL - 5.5.27
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
create table `t_user` (
`id` double ,
`userName` varchar (150),
`userPwd` varchar (150),
`sex` varchar (6),
`age` double
);
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('25','wq6','ewqe','1','32');
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('26','wq7','ewqe','1','32');
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('27','wq8','ewqe','1','32');
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('28','wq9','ewqe','1','32');
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('29','wq10','ewqe','1','32');
insert into `t_user` (`id`, `userName`, `userPwd`, `sex`, `age`) values('30','wq11','ewqe','1','32');项目截图
优点与不足
- 相比于上一个项目，MVC设计模式更加规范，有种框架的感觉，但没有使用任何框架。
- DBUtil工具类封装的功能更加全面，减少了代i码的冗余。
- 终于实现了只用一个Servlet（UserAction）类来控制整个项目，这得益于使用了隐藏标签分模块化实现方法。
- 分页技术更加完善，这与上一篇文章的分页方法完全不同，如果看不懂本项目的方法可以先参考上一篇文章里的项目是如何分页的。
- 最后，我认为这是自己写的最满意的JavaWeb小项目，打算自己当模板使用的，希望对你有所帮助。
- 项目源码：点击打开链接
606
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
