,上节课中我们只做出了页面,这节课我们把增删改查都做了,在上次原有的代码中修改,再添加几个java文件
UserDaoImpl中代码:
package com.zhongruan.dao.impl;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.model.User;
import com.zhongruan.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDaoImpl implements IUserDao {
@Override
public User findUserByUsername(String username) {
Connection connection=null;
PreparedStatement statement=null;
ResultSet resultSet=null;
User user=null;
try{
connection= DBUtil.getConnection();
String sql="select * from tb_user where username=?";
statement=connection.prepareStatement(sql);
statement.setString(1,username);
resultSet=statement.executeQuery();
while (resultSet.next()){
user=new User();
user.setId(resultSet.getInt(1));
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
}
}catch (Exception e){
e.printStackTrace();
}finally {
DBUtil.closeAll(resultSet,statement,connection);
}
return user;
}
public List<User> findAll() {
ResultSet resultSet = null;
PreparedStatement statement = null;
Connection connection = null;
List<User>consumers = new ArrayList<>();
try {
connection = DBUtil.getConnection();
String sql = "select * from tb_user";
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt(1));
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
consumers.add(user);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.closeAll(resultSet, statement, connection);
}
return consumers;
}
@Override
public void charu(String username, String password) {
ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
try {
connection= DBUtil.getConnection();
//3.写sql
String sql="insert into tb_user (username,password) values (?,?)";
//4.得到statement对象
statement=connection.prepareStatement(sql);
statement.setString(1,username);
statement.setString(2,password);
statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
//7.关闭资源
DBUtil.closeAll(resultSet,statement,connection);
}
}
@Override
public void delete(int id) {
Connection connection=null;
PreparedStatement statement=null;
try {
connection=DBUtil.getConnection();
statement = connection.prepareStatement("delete from tb_user where id=?");
statement.setInt(1,id);
statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil.closeAll(null,statement,connection);
}
}
@Override
public void up(int id, String username, String password) {
ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
try {
connection= DBUtil.getConnection();
//3.写sql
String sql="update tb_user set username=?,password=? where id=? ";
//4.得到statement对象
statement=connection.prepareStatement(sql);
statement.setInt(3,id);
statement.setString(1,username);
statement.setString(2,password);
statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
//7.关闭资源
DBUtil.closeAll(resultSet,statement,connection);
}
}
}
IUserDao中代码:
package com.zhongruan.dao;
import com.zhongruan.model.User;
import java.util.List;
public interface IUserDao {
User findUserByUsername(String username);
List findAll();
void charu(String username,String password);
void delete(int id);
void up(int id,String username,String password);
}
User中代码:
package com.zhongruan.model;
public class User {
private int id;
private String username;
private String password;
private int type;
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 getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", type=" + type +
'}';
}
}
IUserService中代码:
package com.zhongruan.service;
import com.zhongruan.model.User;
import java.util.List;
public interface IUserService {
Boolean login(String username,String password);
List findAll();
void delete(int id);
void charu(String username,String password);
void up(int id,String username,String password);
}
AddServlet中代码:
package com.zhongruan.servlet;
import com.zhongruan.service.IUserService;
import com.zhongruan.service.impl.UserServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class AddServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username=request.getParameter(“username”);
String password=request.getParameter(“password”);
IUserService userService=new UserServiceImpl();
userService.charu(username,password);
request.getRequestDispatcher("/find").forward(request,response);
}
}
DeleteServlet中代码:
FindServlet中代码:
package com.zhongruan.servlet;
import com.zhongruan.model.User;
import com.zhongruan.service.IUserService;
import com.zhongruan.service.impl.UserServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
public class FindServlet extends HttpServlet {
IUserService userService=new UserServiceImpl();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List users = userService.findAll();
HttpSession session = request.getSession();
session.setAttribute(“userlist”,users);
request.getRequestDispatcher(“allUser.jsp”).forward(request,response);
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List users = userService.findAll();
HttpSession session = request.getSession();
session.setAttribute(“userlist”,users);
request.getRequestDispatcher(“allUser.jsp”).forward(request,response);
}
}
LoginServlet中代码:
UpdateServlet代码:
DBUtil代码:
package com.zhongruan.util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection() throws SQLException{
try {
Class.forName(“com.mysql.jdbc.Driver”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection connection= DriverManager.getConnection(“jdbc:mysql://127.0.0.1:3306/zjgm?characterEncoding=utf-8&user=root&password=123456”);
return connection;
}
public static void closeAll(ResultSet resultSet,Statement statement, Connection connection){
if (resultSet!=null){
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
接下来是jsp网页文件:
addUser代码:
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8” isELIgnored=“false”%>
<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
基于servlet+jsp框架的管理系统:简单实现增、删、改、查。
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>新增用户</small>
</h1>
</div>
</div>
</div>
<form action="/add"
method="post">
用 户 id:<input type="text" name="id"><br><br><br>
用户姓名:<input type="text" name="username"><br><br><br>
用户密码:<input type="text" name="password"><br><br><br>
<input type="submit" value="添加" >
</form>
allUser代码:
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8” isELIgnored=“false”%>
<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
基于servlet+jsp框架的管理系统:简单实现增、删、改、查。
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>用户列表 —— 显示所有用户</small>
</h1>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4 column">
<a class="btn btn-primary" href="addUser.jsp">新增</a>
</div>
</div>
<div class="row clearfix">
<div class="col-md-12 column">
<table class="table table-hover table-striped">
<thead>
<tr>
<th>id</th>
<th>用户名</th>
<th>密码</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<c:forEach var="users" items="${userlist}">
<tr>
<td>${users.id}</td>
<td>${users.username}</td>
<td>${users.password}</td>
<td><a href="/delete?id=${users.id}">删除</a>|<a href="upUser.jsp">修改</a></td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</div>
failure代码:
main代码:
upUser代码:
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8” isELIgnored=“false”%>
<%@ taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>
基于servlet+jsp框架的管理系统:简单实现增、删、改、查。
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>新增用户</small>
</h1>
</div>
</div>
</div>
<form action="/up"
method="post">
用 户 id:<input type="text" name="id"><br><br><br>
用户姓名:<input type="text" name="username"><br><br><br>
用户密码:<input type="text" name="password"><br><br><br>
<input type="submit" value="添加" >
</form>
index中是样式:
最后到网页中看一下:
点删除,他就没了
点修改,就可以修改:
完成这种效果就ok了。