Java+JSP+Mysql+Tomcat实现Web用户信息管理系统

=====================================================================

DBUtil

---

package com.sjsq.vo;

/**

• 管理员类

• @author shuijianshiqing

• @date 2021/4/29 22:11

*/

public class Admin {

// 账号

private String username;

// 密码

private String password;

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;

}

@Override

public String toString() {

return “Admin{” +

“username='” + username + ‘’’ +

“, password='” + password + ‘’’ +

‘}’;

}

}

Admin

---

package com.sjsq.vo;

/**

• 管理员类

• @author shuijianshiqing

• @date 2021/4/29 22:11

*/

public class Admin {

// 账号

private String username;

// 密码

private String password;

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;

}

@Override

public String toString() {

return “Admin{” +

“username='” + username + ‘’’ +

“, password='” + password + ‘’’ +

‘}’;

}

}

AdminDaoImpl

---

package com.sjsq.dao.impl;

import com.sjsq.dao.AdminDao;

import com.sjsq.utils.DBUtil;

import com.sjsq.vo.Admin;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

/**

• @author shuijianshiqing

• @date 2021/5/1 9:49

*/

public class AdminDaoImpl implements AdminDao {

/**

• 用户登录

• @param admin

• @return

*/

@Override

public Admin login(Admin admin) {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

// 1.获取数据库连接

con = DBUtil.getConnection();

// 2.写sql

String sql = “select * from admin where username = ? and password = ?”;

// 3.预编译

ps = con.prepareStatement(sql);

// 4.设置值

ps.setObject(1,admin.getUsername());

ps.setObject(2,admin.getPassword());

rs = ps.executeQuery();

Admin adminLogin = null;

if(rs.next()){

adminLogin = new Admin();

// 从数据库中获取值到实体类的setter方法中

adminLogin.setUsername(rs.getString(“username”));

adminLogin.setPassword(rs.getString(“password”));

// 返回的是你查询出来的完整的对象

return adminLogin;

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}finally {

// 关闭资源，避免出现异常

DBUtil.close(con,ps,rs);

}

return null;

}

}

login.jsp

---

<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>

<%

// 获取绝对路径路径 ,开发项目一定要使用绝对路径，不然肯定出错

String path = request.getContextPath();

String basePath = request.getScheme() + “😕/” + request.getServerName() + “:”

• request.getServerPort() + path + “/”;

%>

用户登录

---

账号： 密码：

fail.jsp

---

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

用户登录

---

登录失败

返回登录

error.jsp

---

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

操作失败

操作出错，请回到上一个页面！

返回上一级

add-user.jsp

---

<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

<%-- 头部 --%>

<jsp:include page=“top.jsp”/>

新增用户

---

返回上一级

用户编号：

用户姓名：

用户密码：

用户年龄：

监狱号码：

用户简介：

用户号码：

用户电话：

创建时间：

添加

重置