基于servlet+jsp框架的管理系统:简单实现增、删、改、查
效果如下
这是用户名和密码输入正确后进入的页面
这就新添加了一条新的数据,数据库里也存在这条数据
点击删除,可以实现删除一条数据
点击修改,可以实现修改数据,这里是与昨天不一样的地方,它会自动获取你要改id的信息
代码如下
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DelectServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.DeleteServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DelectServlet</servlet-name>
<url-pattern>/delete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>findServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.findServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>findServlet</servlet-name>
<url-pattern>/find</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>AddServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.AddServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AddServlet</servlet-name>
<url-pattern>/add</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>updateServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.updateServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>updateServlet</servlet-name>
<url-pattern>/up</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>toupdateServlet</servlet-name>
<servlet-class>com.zhongruan.servlet.toupdateServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>toupdateServlet</servlet-name>
<url-pattern>/toupdate</url-pattern>
</servlet-mapping>
</web-app>
UserDaompl
package com.zhongruan.Dao.impl;
import com.zhongruan.Dao.UserDao;
import com.zhongruan.model.User;
import com.zhongruan.DButil.DButil;
import javax.jws.soap.SOAPBinding;
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 UserDaompl implements UserDao {
@Override
public User findUserByUsername(String username) {
User user=null;
ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
try {
connection= DButil.getConnection();
//3.写sql
String sql="select * from tb_user where username=?";
//4.创建statement对象
statement=connection.prepareStatement(sql);
statement.setString(1,username);
//5.执行sql
resultSet=statement.executeQuery();
//6.处理结果集
while (resultSet.next()){
user=new User();
user.setId(resultSet.getInt(1));
user.setUsername(username);
user.setPassword(resultSet.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
//7.关闭资源
DButil.closeAll(resultSet,statement,connection);
}
return user;
}
@Override
public List<User> findAll(){
List<User> users=new ArrayList<>();
Connection connection=null;
PreparedStatement statement