先自我介绍一下，小编浙江大学毕业，去过华为、字节跳动等大厂，目前阿里P7
深知大多数程序员，想要提升技能，往往是自己摸索成长，但自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！
因此收集整理了一份《2024年最新Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友。
既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上Java开发知识点，真正体系化！
由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新
如果你需要这些资料，可以添加V获取：vip1024b （备注Java）
正文
INSERT INTO t_student VALUES (1, ‘001’, ‘123456’, ‘李四’, 4, ‘120’, ‘男’, ‘123456’);
INSERT INTO t_student VALUES (2, ‘002’, ‘123456’, ‘王五’, 5, ‘201’, ‘男’, ‘123456’);
SET FOREIGN_KEY_CHECKS = 1;
5.工程截图
二、系统展示
======
1.登录界面
2.学生-主页面
3.学生-缺勤记录
4.学生-修改密码
5.宿舍管理员-主页面
6.宿舍管理员-学生查看
7.宿舍管理员-缺勤记录
8.宿舍管理员-修改密码
9.系统管理员-主页面
10.系统管理员-宿舍管理员管理
11.系统管理员-学生管理
12.系统管理员-宿舍楼管理
13.系统管理员-缺勤记录
14.系统管理员-修改密码
三、部分代码
======
DormBuildDao
package com.lero.dao;
import com.lero.model.DormBuild;
import com.lero.model.DormManager;
import com.lero.model.PageBean;
import com.lero.util.StringUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class DormBuildDao {
public static String dormBuildName(Connection con, int dormBuildId) throws Exception {
String sql = “select * from t_dormBuild where dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, dormBuildId);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getString(“dormBuildName”);
}
return null;
}
public List dormBuildList(Connection con, PageBean pageBean, DormBuild s_dormBuild) throws Exception {
List dormBuildList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_dormBuild t1”);
if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {
sb.append(" where t1.dormBuildName like ‘%" + s_dormBuild.getDormBuildName() + "%’");
}
if (pageBean != null) {
sb.append(" limit " + pageBean.getStart() + “,” + pageBean.getPageSize());
}
PreparedStatement pstmt = con.prepareStatement(sb.toString());
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormBuild dormBuild = new DormBuild();
dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));
dormBuild.setDormBuildName(rs.getString(“dormBuildName”));
dormBuild.setDetail(rs.getString(“dormBuildDetail”));
dormBuildList.add(dormBuild);
}
return dormBuildList;
}
public int dormBuildCount(Connection con, DormBuild s_dormBuild) throws Exception {
StringBuffer sb = new StringBuffer(“select count(*) as total from t_dormBuild t1”);
if (StringUtil.isNotEmpty(s_dormBuild.getDormBuildName())) {
sb.append(" where t1.dormBuildName like ‘%" + s_dormBuild.getDormBuildName() + "%’");
}
PreparedStatement pstmt = con.prepareStatement(sb.toString());
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getInt(“total”);
} else {
return 0;
}
}
public DormBuild dormBuildShow(Connection con, String dormBuildId) throws Exception {
String sql = “select * from t_dormBuild t1 where t1.dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuildId);
ResultSet rs = pstmt.executeQuery();
DormBuild dormBuild = new DormBuild();
if (rs.next()) {
dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));
dormBuild.setDormBuildName(rs.getString(“dormBuildName”));
dormBuild.setDetail(rs.getString(“dormBuildDetail”));
}
return dormBuild;
}
public int dormBuildAdd(Connection con, DormBuild dormBuild) throws Exception {
String sql = “insert into t_dormBuild values(null,?,?)”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuild.getDormBuildName());
pstmt.setString(2, dormBuild.getDetail());
return pstmt.executeUpdate();
}
public int dormBuildDelete(Connection con, String dormBuildId) throws Exception {
String sql = “delete from t_dormBuild where dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuildId);
return pstmt.executeUpdate();
}
public int dormBuildUpdate(Connection con, DormBuild dormBuild) throws Exception {
String sql = “update t_dormBuild set dormBuildName=?,dormBuildDetail=? where dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuild.getDormBuildName());
pstmt.setString(2, dormBuild.getDetail());
pstmt.setInt(3, dormBuild.getDormBuildId());
return pstmt.executeUpdate();
}
public boolean existManOrDormWithId(Connection con, String dormBuildId) throws Exception {
boolean isExist = false;
// String sql=“select * from t_dormBuild,t_dormManager,t_connection where dormManId=managerId and dormBuildId=buildId and dormBuildId=?”;
String sql = “select *from t_dormManager where dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuildId);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
isExist = true;
} else {
isExist = false;
}
String sql1 = “select * from t_dormBuild t1,t_dorm t2 where t1.dormBuildId=t2.dormBuildId and t1.dormBuildId=?”;
PreparedStatement p = con.prepareStatement(sql1);
p.setString(1, dormBuildId);
ResultSet r = pstmt.executeQuery();
if (r.next()) {
return isExist;
} else {
return false;
}
}
public List dormManWithoutBuild(Connection con) throws Exception {
List dormManagerList = new ArrayList();
String sql = “SELECT * FROM t_dormManager WHERE dormBuildId IS NULL OR dormBuildId=0”;
PreparedStatement pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormManager dormManager = new DormManager();
dormManager.setDormBuildId(rs.getInt(“dormBuildId”));
dormManager.setDormManagerId(rs.getInt(“dormManId”));
dormManager.setName(rs.getString(“name”));
dormManager.setUserName(rs.getString(“userName”));
dormManager.setSex(rs.getString(“sex”));
dormManager.setTel(rs.getString(“tel”));
dormManagerList.add(dormManager);
}
return dormManagerList;
}
public List dormManWithBuildId(Connection con, String dormBuildId) throws Exception {
List dormManagerList = new ArrayList();
String sql = “select *from t_dormManager where dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuildId);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormManager dormManager = new DormManager();
dormManager.setDormBuildId(rs.getInt(“dormBuildId”));
dormManager.setDormManagerId(rs.getInt(“dormManId”));
dormManager.setName(rs.getString(“name”));
dormManager.setUserName(rs.getString(“userName”));
dormManager.setSex(rs.getString(“sex”));
dormManager.setTel(rs.getString(“tel”));
dormManagerList.add(dormManager);
}
return dormManagerList;
}
public int managerUpdateWithId(Connection con, String dormManagerId, String dormBuildId) throws Exception {
String sql = “update t_dormManager set dormBuildId=? where dormManId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormBuildId);
pstmt.setString(2, dormManagerId);
return pstmt.executeUpdate();
}
}
DormManagerDao
package com.lero.dao;
import com.lero.model.DormManager;
import com.lero.model.PageBean;
import com.lero.util.StringUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class DormManagerDao {
public List dormManagerList(Connection con, PageBean pageBean, DormManager s_dormManager) throws Exception {
List dormManagerList = new ArrayList();
StringBuffer sb = new StringBuffer(“SELECT * FROM t_dormManager t1 ORDER BY t1.userName”);
if (StringUtil.isNotEmpty(s_dormManager.getName())) {
sb.append(" where t1.name like ‘%" + s_dormManager.getName() + "%’");
} else if (StringUtil.isNotEmpty(s_dormManager.getUserName())) {
sb.append(" where t1.userName like ‘%" + s_dormManager.getUserName() + "%’");
}
if (pageBean != null) {
sb.append(" limit " + pageBean.getStart() + “,” + pageBean.getPageSize());
}
PreparedStatement pstmt = con.prepareStatement(sb.toString());
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormManager dormManager = new DormManager();
dormManager.setDormManagerId(rs.getInt(“dormManId”));
int dormBuildId = rs.getInt(“dormBuildId”);
dormManager.setDormBuildId(dormBuildId);
dormManager.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
dormManager.setName(rs.getString(“name”));
dormManager.setSex(rs.getString(“sex”));
dormManager.setUserName(rs.getString(“userName”));
dormManager.setTel(rs.getString(“tel”));
dormManager.setPassword(rs.getString(“password”));
dormManagerList.add(dormManager);
}
return dormManagerList;
}
public int dormManagerCount(Connection con, DormManager s_dormManager) throws Exception {
StringBuffer sb = new StringBuffer(“select count(*) as total from t_dormManager t1”);
if (StringUtil.isNotEmpty(s_dormManager.getName())) {
sb.append(" where t1.name like ‘%" + s_dormManager.getName() + "%’");
} else if (StringUtil.isNotEmpty(s_dormManager.getUserName())) {
sb.append(" where t1.userName like ‘%" + s_dormManager.getUserName() + "%’");
}
PreparedStatement pstmt = con.prepareStatement(sb.toString());
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getInt(“total”);
} else {
return 0;
}
}
public DormManager dormManagerShow(Connection con, String dormManagerId) throws Exception {
String sql = “select * from t_dormManager t1 where t1.dormManId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormManagerId);
ResultSet rs = pstmt.executeQuery();
DormManager dormManager = new DormManager();
if (rs.next()) {
dormManager.setDormManagerId(rs.getInt(“dormManId”));
dormManager.setDormBuildId(rs.getInt(“dormBuildId”));
dormManager.setName(rs.getString(“name”));
dormManager.setSex(rs.getString(“sex”));
dormManager.setUserName(rs.getString(“userName”));
dormManager.setTel(rs.getString(“tel”));
dormManager.setPassword(rs.getString(“password”));
}
return dormManager;
}
public int dormManagerAdd(Connection con, DormManager dormManager) throws Exception {
String sql = “insert into t_dormManager values(null,?,?,null,?,?,?)”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormManager.getUserName());
pstmt.setString(2, dormManager.getPassword());
pstmt.setString(3, dormManager.getName());
pstmt.setString(4, dormManager.getSex());
pstmt.setString(5, dormManager.getTel());
return pstmt.executeUpdate();
}
public int dormManagerDelete(Connection con, String dormManagerId) throws Exception {
String sql = “delete from t_dormManager where dormManId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormManagerId);
return pstmt.executeUpdate();
}
public int dormManagerUpdate(Connection con, DormManager dormManager) throws Exception {
String sql = “update t_dormManager set userName=?,password=?,name=?,sex=?,tel=? where dormManId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormManager.getUserName());
pstmt.setString(2, dormManager.getPassword());
pstmt.setString(3, dormManager.getName());
pstmt.setString(4, dormManager.getSex());
pstmt.setString(5, dormManager.getTel());
pstmt.setInt(6, dormManager.getDormManagerId());
return pstmt.executeUpdate();
}
public boolean haveManagerByUser(Connection con, String userName) throws Exception {
String sql = “select * from t_dormmanager t1 where t1.userName=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, userName);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
return true;
}
return false;
}
}
RecordDao
package com.lero.dao;
import com.lero.model.DormBuild;
import com.lero.model.Record;
import com.lero.util.StringUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class RecordDao {
public List recordList(Connection con, Record s_record) throws Exception {
List recordList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_record t1”);
if (StringUtil.isNotEmpty(s_record.getStudentNumber())) {
sb.append(" and t1.studentNumber like ‘%" + s_record.getStudentNumber() + "%’");
} else if (StringUtil.isNotEmpty(s_record.getStudentName())) {
sb.append(" and t1.studentName like ‘%" + s_record.getStudentName() + "%’");
}
if (s_record.getDormBuildId() != 0) {
sb.append(" and t1.dormBuildId=" + s_record.getDormBuildId());
}
if (StringUtil.isNotEmpty(s_record.getDate())) {
sb.append(" and t1.date=" + s_record.getDate());
}
if (StringUtil.isNotEmpty(s_record.getStartDate())) {
sb.append(" and TO_DAYS(t1.date)>=TO_DAYS(‘" + s_record.getStartDate() + "’)");
}
if (StringUtil.isNotEmpty(s_record.getEndDate())) {
sb.append(" and TO_DAYS(t1.date)<=TO_DAYS(‘" + s_record.getEndDate() + "’)");
}
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Record record = new Record();
record.setRecordId(rs.getInt(“recordId”));
record.setStudentNumber(rs.getString(“studentNumber”));
record.setStudentName(rs.getString(“studentName”));
int dormBuildId = rs.getInt(“dormBuildId”);
record.setDormBuildId(dormBuildId);
record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
record.setDormName(rs.getString(“dormName”));
record.setDate(rs.getString(“date”));
record.setDetail(rs.getString(“detail”));
recordList.add(record);
}
return recordList;
}
public List recordListWithBuild(Connection con, Record s_record, int buildId) throws Exception {
List recordList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_record t1”);
if (StringUtil.isNotEmpty(s_record.getStudentNumber())) {
sb.append(" and t1.studentNumber like ‘%" + s_record.getStudentNumber() + "%’");
} else if (StringUtil.isNotEmpty(s_record.getStudentName())) {
sb.append(" and t1.studentName like ‘%" + s_record.getStudentName() + "%’");
}
sb.append(" and t1.dormBuildId=" + buildId);
if (StringUtil.isNotEmpty(s_record.getStartDate())) {
sb.append(" and TO_DAYS(t1.date)>=TO_DAYS(‘" + s_record.getStartDate() + "’)");
}
if (StringUtil.isNotEmpty(s_record.getEndDate())) {
sb.append(" and TO_DAYS(t1.date)<=TO_DAYS(‘" + s_record.getEndDate() + "’)");
}
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Record record = new Record();
record.setRecordId(rs.getInt(“recordId”));
record.setStudentNumber(rs.getString(“studentNumber”));
record.setStudentName(rs.getString(“studentName”));
int dormBuildId = rs.getInt(“dormBuildId”);
record.setDormBuildId(dormBuildId);
record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
record.setDormName(rs.getString(“dormName”));
record.setDate(rs.getString(“date”));
record.setDetail(rs.getString(“detail”));
recordList.add(record);
}
return recordList;
}
public List recordListWithNumber(Connection con, Record s_record, String studentNumber) throws Exception {
List recordList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_record t1”);
if (StringUtil.isNotEmpty(studentNumber)) {
sb.append(" and t1.studentNumber =" + studentNumber);
}
if (StringUtil.isNotEmpty(s_record.getStartDate())) {
sb.append(" and TO_DAYS(t1.date)>=TO_DAYS(‘" + s_record.getStartDate() + "’)");
}
if (StringUtil.isNotEmpty(s_record.getEndDate())) {
sb.append(" and TO_DAYS(t1.date)<=TO_DAYS(‘" + s_record.getEndDate() + "’)");
}
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Record record = new Record();
record.setRecordId(rs.getInt(“recordId”));
record.setStudentNumber(rs.getString(“studentNumber”));
record.setStudentName(rs.getString(“studentName”));
int dormBuildId = rs.getInt(“dormBuildId”);
record.setDormBuildId(dormBuildId);
record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
record.setDormName(rs.getString(“dormName”));
record.setDate(rs.getString(“date”));
record.setDetail(rs.getString(“detail”));
recordList.add(record);
}
return recordList;
}
public List dormBuildList(Connection con) throws Exception {
List dormBuildList = new ArrayList();
String sql = “select * from t_dormBuild”;
PreparedStatement pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormBuild dormBuild = new DormBuild();
dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));
dormBuild.setDormBuildName(rs.getString(“dormBuildName”));
dormBuild.setDetail(rs.getString(“dormBuildDetail”));
dormBuildList.add(dormBuild);
}
return dormBuildList;
}
//
// public int studentCount(Connection con, Student s_student)throws Exception {
// StringBuffer sb = new StringBuffer(“select count(*) as total from t_student t1”);
// if(StringUtil.isNotEmpty(s_student.getName())) {
// sb.append(" and t1.name like ‘%“+s_student.getName()+”%’");
// } else if(StringUtil.isNotEmpty(s_student.getStuNumber())) {
// sb.append(" and t1.stuNum like ‘%“+s_student.getStuNumber()+”%’");
// } else if(StringUtil.isNotEmpty(s_student.getDormName())) {
// sb.append(" and t1.dormName like ‘%“+s_student.getDormName()+”%’");
// }
// if(s_student.getDormBuildId()!=0) {
// sb.append(" and t1.dormBuildId="+s_student.getDormBuildId());
// }
// PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
// ResultSet rs = pstmt.executeQuery();
// if(rs.next()) {
// return rs.getInt(“total”);
// } else {
// return 0;
// }
// }
public Record recordShow(Connection con, String recordId) throws Exception {
String sql = “select * from t_record t1 where t1.recordId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, recordId);
ResultSet rs = pstmt.executeQuery();
Record record = new Record();
if (rs.next()) {
record.setRecordId(rs.getInt(“recordId”));
record.setStudentNumber(rs.getString(“studentNumber”));
record.setStudentName(rs.getString(“studentName”));
int dormBuildId = rs.getInt(“dormBuildId”);
record.setDormBuildId(dormBuildId);
record.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
record.setDormName(rs.getString(“dormName”));
record.setDate(rs.getString(“date”));
record.setDetail(rs.getString(“detail”));
}
return record;
}
public int recordAdd(Connection con, Record record) throws Exception {
String sql = “insert into t_record values(null,?,?,?,?,?,?)”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, record.getStudentNumber());
pstmt.setString(2, record.getStudentName());
pstmt.setInt(3, record.getDormBuildId());
pstmt.setString(4, record.getDormName());
pstmt.setString(5, record.getDate());
pstmt.setString(6, record.getDetail());
return pstmt.executeUpdate();
}
public int recordDelete(Connection con, String recordId) throws Exception {
String sql = “delete from t_record where recordId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, recordId);
return pstmt.executeUpdate();
}
public int recordUpdate(Connection con, Record record) throws Exception {
String sql = “update t_record set studentNumber=?,studentName=?,dormBuildId=?,dormName=?,detail=? where recordId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, record.getStudentNumber());
pstmt.setString(2, record.getStudentName());
pstmt.setInt(3, record.getDormBuildId());
pstmt.setString(4, record.getDormName());
pstmt.setString(5, record.getDetail());
pstmt.setInt(6, record.getRecordId());
return pstmt.executeUpdate();
}
}
StudentDao
package com.lero.dao;
import com.lero.model.DormBuild;
import com.lero.model.Student;
import com.lero.util.StringUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class StudentDao {
// public List studentList(Connection con, PageBean pageBean, Student s_student)throws Exception {
// List studentList = new ArrayList();
// StringBuffer sb = new StringBuffer(“select * from t_student t1”);
// if(StringUtil.isNotEmpty(s_student.getName())) {
// sb.append(" and t1.name like ‘%“+s_student.getName()+”%’");
// } else if(StringUtil.isNotEmpty(s_student.getStuNumber())) {
// sb.append(" and t1.stuNum like ‘%“+s_student.getStuNumber()+”%’");
// } else if(StringUtil.isNotEmpty(s_student.getDormName())) {
// sb.append(" and t1.dormName like ‘%“+s_student.getDormName()+”%’");
// }
// if(s_student.getDormBuildId()!=0) {
// sb.append(" and t1.dormBuildId="+s_student.getDormBuildId());
// }
// if(pageBean != null) {
// sb.append(" limit “+pageBean.getStart()+”,"+pageBean.getPageSize());
// }
// PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
// ResultSet rs = pstmt.executeQuery();
// while(rs.next()) {
// Student student=new Student();
// student.setStudentId(rs.getInt(“studentId”));
// int dormBuildId = rs.getInt(“dormBuildId”);
// student.setDormBuildId(dormBuildId);
// student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
// student.setDormName(rs.getString(“dormName”));
// student.setName(rs.getString(“name”));
// student.setSex(rs.getString(“sex”));
// student.setStuNumber(rs.getString(“stuNum”));
// student.setTel(rs.getString(“tel”));
// student.setPassword(rs.getString(“password”));
// studentList.add(student);
// }
// return studentList;
// }
public static Student getNameById(Connection con, String studentNumber, int dormBuildId) throws Exception {
String sql = “select * from t_student t1 where t1.stuNum=? and t1.dormBuildId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, studentNumber);
pstmt.setInt(2, dormBuildId);
ResultSet rs = pstmt.executeQuery();
Student student = new Student();
if (rs.next()) {
student.setName(rs.getString(“name”));
student.setDormBuildId(rs.getInt(“dormBuildId”));
student.setDormName(rs.getString(“dormName”));
}
return student;
}
public List studentList(Connection con, Student s_student) throws Exception {
List studentList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_student t1”);
if (StringUtil.isNotEmpty(s_student.getName())) {
sb.append(" and t1.name like ‘%" + s_student.getName() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
sb.append(" and t1.stuNum like ‘%" + s_student.getStuNumber() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getDormName())) {
sb.append(" and t1.dormName like ‘%" + s_student.getDormName() + "%’");
}
if (s_student.getDormBuildId() != 0) {
sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId());
}
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Student student = new Student();
student.setStudentId(rs.getInt(“studentId”));
int dormBuildId = rs.getInt(“dormBuildId”);
student.setDormBuildId(dormBuildId);
student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
student.setDormName(rs.getString(“dormName”));
student.setName(rs.getString(“name”));
student.setSex(rs.getString(“sex”));
student.setStuNumber(rs.getString(“stuNum”));
student.setTel(rs.getString(“tel”));
student.setPassword(rs.getString(“password”));
studentList.add(student);
}
return studentList;
}
public boolean haveNameByNumber(Connection con, String studentNumber) throws Exception {
String sql = “select * from t_student t1 where t1.stuNum=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, studentNumber);
ResultSet rs = pstmt.executeQuery();
Student student = new Student();
if (rs.next()) {
student.setName(rs.getString(“name”));
student.setDormBuildId(rs.getInt(“dormBuildId”));
student.setDormName(rs.getString(“dormName”));
return true;
}
return false;
}
public List studentListWithBuild(Connection con, Student s_student, int buildId) throws Exception {
List studentList = new ArrayList();
StringBuffer sb = new StringBuffer(“select * from t_student t1”);
if (StringUtil.isNotEmpty(s_student.getName())) {
sb.append(" and t1.name like ‘%" + s_student.getName() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
sb.append(" and t1.stuNum like ‘%" + s_student.getStuNumber() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getDormName())) {
sb.append(" and t1.dormName like ‘%" + s_student.getDormName() + "%’");
}
sb.append(" and t1.dormBuildId=" + buildId);
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
Student student = new Student();
student.setStudentId(rs.getInt(“studentId”));
int dormBuildId = rs.getInt(“dormBuildId”);
student.setDormBuildId(dormBuildId);
student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
student.setDormName(rs.getString(“dormName”));
student.setName(rs.getString(“name”));
student.setSex(rs.getString(“sex”));
student.setStuNumber(rs.getString(“stuNum”));
student.setTel(rs.getString(“tel”));
student.setPassword(rs.getString(“password”));
studentList.add(student);
}
return studentList;
}
public List dormBuildList(Connection con) throws Exception {
List dormBuildList = new ArrayList();
String sql = “select * from t_dormBuild”;
PreparedStatement pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
DormBuild dormBuild = new DormBuild();
dormBuild.setDormBuildId(rs.getInt(“dormBuildId”));
dormBuild.setDormBuildName(rs.getString(“dormBuildName”));
dormBuild.setDetail(rs.getString(“dormBuildDetail”));
dormBuildList.add(dormBuild);
}
return dormBuildList;
}
public int studentCount(Connection con, Student s_student) throws Exception {
StringBuffer sb = new StringBuffer(“select count(*) as total from t_student t1”);
if (StringUtil.isNotEmpty(s_student.getName())) {
sb.append(" and t1.name like ‘%" + s_student.getName() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getStuNumber())) {
sb.append(" and t1.stuNum like ‘%" + s_student.getStuNumber() + "%’");
} else if (StringUtil.isNotEmpty(s_student.getDormName())) {
sb.append(" and t1.dormName like ‘%" + s_student.getDormName() + "%’");
}
if (s_student.getDormBuildId() != 0) {
sb.append(" and t1.dormBuildId=" + s_student.getDormBuildId());
}
PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst(“and”, “where”));
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getInt(“total”);
} else {
return 0;
}
}
public Student studentShow(Connection con, String studentId) throws Exception {
String sql = “select * from t_student t1 where t1.studentId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, studentId);
ResultSet rs = pstmt.executeQuery();
Student student = new Student();
if (rs.next()) {
student.setStudentId(rs.getInt(“studentId”));
int dormBuildId = rs.getInt(“dormBuildId”);
student.setDormBuildId(dormBuildId);
student.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
student.setDormName(rs.getString(“dormName”));
student.setName(rs.getString(“name”));
student.setSex(rs.getString(“sex”));
student.setStuNumber(rs.getString(“stuNum”));
student.setTel(rs.getString(“tel”));
student.setPassword(rs.getString(“password”));
}
return student;
}
public int studentAdd(Connection con, Student student) throws Exception {
String sql = “insert into t_student values(null,?,?,?,?,?,?,?)”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, student.getStuNumber());
pstmt.setString(2, student.getPassword());
pstmt.setString(3, student.getName());
pstmt.setInt(4, student.getDormBuildId());
pstmt.setString(5, student.getDormName());
pstmt.setString(6, student.getSex());
pstmt.setString(7, student.getTel());
return pstmt.executeUpdate();
}
public int studentDelete(Connection con, String studentId) throws Exception {
String sql = “delete from t_student where studentId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, studentId);
return pstmt.executeUpdate();
}
public int studentUpdate(Connection con, Student student) throws Exception {
String sql = “update t_student set stuNum=?,password=?,name=?,dormBuildId=?,dormName=?,sex=?,tel=? where studentId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, student.getStuNumber());
pstmt.setString(2, student.getPassword());
pstmt.setString(3, student.getName());
pstmt.setInt(4, student.getDormBuildId());
pstmt.setString(5, student.getDormName());
pstmt.setString(6, student.getSex());
pstmt.setString(7, student.getTel());
pstmt.setInt(8, student.getStudentId());
return pstmt.executeUpdate();
}
}
UserDao
package com.lero.dao;
import com.lero.model.Admin;
import com.lero.model.DormManager;
import com.lero.model.Student;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class UserDao {
public Admin Login(Connection con, Admin admin) throws Exception {
Admin resultAdmin = null;
String sql = “select * from t_admin where userName=? and password=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, admin.getUserName());
pstmt.setString(2, admin.getPassword());
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
resultAdmin = new Admin();
resultAdmin.setAdminId(rs.getInt(“adminId”));
resultAdmin.setUserName(rs.getString(“userName”));
resultAdmin.setPassword(rs.getString(“password”));
resultAdmin.setName(rs.getString(“name”));
resultAdmin.setSex(rs.getString(“sex”));
resultAdmin.setTel(rs.getString(“tel”));
}
return resultAdmin;
}
public DormManager Login(Connection con, DormManager dormManager) throws Exception {
DormManager resultDormManager = null;
String sql = “select * from t_dormmanager where userName=? and password=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, dormManager.getUserName());
pstmt.setString(2, dormManager.getPassword());
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
resultDormManager = new DormManager();
resultDormManager.setDormManagerId(rs.getInt(“dormManId”));
resultDormManager.setUserName(rs.getString(“userName”));
resultDormManager.setPassword(rs.getString(“password”));
resultDormManager.setDormBuildId(rs.getInt(“dormBuildId”));
resultDormManager.setName(rs.getString(“name”));
resultDormManager.setSex(rs.getString(“sex”));
resultDormManager.setTel(rs.getString(“tel”));
}
return resultDormManager;
}
public Student Login(Connection con, Student student) throws Exception {
Student resultStudent = null;
String sql = “select * from t_student where stuNum=? and password=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, student.getStuNumber());
pstmt.setString(2, student.getPassword());
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
resultStudent = new Student();
resultStudent.setStudentId(rs.getInt(“studentId”));
resultStudent.setStuNumber(rs.getString(“stuNum”));
resultStudent.setPassword(rs.getString(“password”));
int dormBuildId = rs.getInt(“dormBuildId”);
resultStudent.setDormBuildId(dormBuildId);
resultStudent.setDormBuildName(DormBuildDao.dormBuildName(con, dormBuildId));
resultStudent.setDormName(rs.getString(“dormName”));
resultStudent.setName(rs.getString(“name”));
resultStudent.setSex(rs.getString(“sex”));
resultStudent.setTel(rs.getString(“tel”));
}
return resultStudent;
}
public int adminUpdate(Connection con, int adminId, String password) throws Exception {
String sql = “update t_admin set password=? where adminId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, password);
pstmt.setInt(2, adminId);
return pstmt.executeUpdate();
}
public int managerUpdate(Connection con, int managerId, String password) throws Exception {
String sql = “update t_dormmanager set password=? where dormManId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, password);
pstmt.setInt(2, managerId);
return pstmt.executeUpdate();
}
public int studentUpdate(Connection con, int studentId, String password) throws Exception {
String sql = “update t_student set password=? where studentId=?”;
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, password);
pstmt.setInt(2, studentId);
return pstmt.executeUpdate();
}
}
PropertiesUtil
package com.lero.util;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class PropertiesUtil {
public static String getValue(String key) {
Properties prop = new Properties();
InputStream in = new PropertiesUtil().getClass().getResourceAsStream(“/dorm.properties”);
try {
prop.load(in);
} catch (IOException e) {
e.printStackTrace();
}
return (String) prop.get(key);
}
}
login.jsp
<%@ page language=“java” contentType=“text/html; charset=utf-8”
pageEncoding=“utf-8” %>
<%@ page import=“com.lero.model.Admin” %>
<%@ page import=“com.lero.model.DormManager” %>
<%@ page import=“com.lero.model.Student” %>
<%
if (request.getAttribute(“user”) == null) {
String userName = null;
String password = null;
String userType = null;
String remember = null;
Cookie[] cookies = request.getCookies();
for (int i = 0; cookies != null && i < cookies.length; i++) {
if (cookies[i].getName().equals(“dormuser”)) {
userName = cookies[i].getValue().split(“-”)[0];
password = cookies[i].getValue().split(“-”)[1];
userType = cookies[i].getValue().split(“-”)[2];
remember = cookies[i].getValue().split(“-”)[3];
}
}
if (userName == null) {
userName = “”;
}
if (password == null) {
password = “”;
}
if (userType == null) {
userType = “”;
} else if (“admin”.equals(userType)) {
pageContext.setAttribute(“user”, new Admin(userName, password));
pageContext.setAttribute(“userType”, 1);
} else if (“dormManager”.equals(userType)) {
pageContext.setAttribute(“user”, new DormManager(userName, password));
pageContext.setAttribute(“userType”, 2);
} else if (“student”.equals(userType)) {
pageContext.setAttribute(“user”, new Student(userName, password));
pageContext.setAttribute(“userType”, 3);
}
if (“yes”.equals(remember)) {
pageContext.setAttribute(“remember”, 1);
}
}
%>
宿舍管理系统
<input id=“userName” name=“userName” value=“${user.userName }” type=“text” class=“input-block-level”
placeholder=“账号”>
<input id=“password” name=“password” value=“${user.password }” type=“password” class=“input-block-level”
placeholder=“密码”>
系统管理员
<input id=“dormManager” type=“radio” name=“userType” value=“dormManager” ${userType==2?‘checked’:‘’} />
宿舍管理员
<input id=“student” type=“radio” name=“userType” value=“student” ${userType==3?‘checked’:‘’}/> 学生
<input id=“remember” name=“remember” type=“checkbox” value=“remember-me” ${remember==1?‘checked’:‘’}>记住我
${error }
登录
重置
版权所有2021
最后
Java架构进阶面试及知识点文档笔记
这份文档共498页，其中包括Java集合，并发编程，JVM，Dubbo,Redis，Spring全家桶，MySQL，Kafka等面试解析及知识点整理
Java分布式高级面试问题解析文档
其中都是包括分布式的面试问题解析，内容有分布式消息队列，Redis缓存，分库分表，微服务架构，分布式高可用，读写分离等等！
互联网Java程序员面试必备问题解析及文档学习笔记
Java架构进阶视频解析合集
网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。
需要这份系统化的资料的朋友，可以添加V获取：vip1024b （备注Java）
一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！
signin .form-signin-heading,
.form-signin .checkbox {
margin-bottom: 10px;
}
.form-signin input[type=“text”],
.form-signin input[type=“password”] {
font-size: 16px;
height: auto;
margin-bottom: 15px;
padding: 7px 9px;
}
宿舍管理系统
<input id=“userName” name=“userName” value=“${user.userName }” type=“text” class=“input-block-level”
placeholder=“账号”>
<input id=“password” name=“password” value=“${user.password }” type=“password” class=“input-block-level”
placeholder=“密码”>
系统管理员
<input id=“dormManager” type=“radio” name=“userType” value=“dormManager” ${userType==2?‘checked’:‘’} />
宿舍管理员
<input id=“student” type=“radio” name=“userType” value=“student” ${userType==3?‘checked’:‘’}/> 学生
<input id=“remember” name=“remember” type=“checkbox” value=“remember-me” ${remember==1?‘checked’:‘’}>记住我
${error }
登录
重置
版权所有2021
最后
Java架构进阶面试及知识点文档笔记
这份文档共498页，其中包括Java集合，并发编程，JVM，Dubbo,Redis，Spring全家桶，MySQL，Kafka等面试解析及知识点整理
[外链图片转存中…(img-D2EO7NhW-1713476294454)]
Java分布式高级面试问题解析文档
其中都是包括分布式的面试问题解析，内容有分布式消息队列，Redis缓存，分库分表，微服务架构，分布式高可用，读写分离等等！
[外链图片转存中…(img-nDyICLO9-1713476294455)]
互联网Java程序员面试必备问题解析及文档学习笔记
[外链图片转存中…(img-VikoaI21-1713476294455)]
Java架构进阶视频解析合集
网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。
需要这份系统化的资料的朋友，可以添加V获取：vip1024b （备注Java）
[外链图片转存中…(img-gwdy66By-1713476294455)]
一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！
扫一扫
269
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
