java+JDBC小项目《学生管理系统》源码带注解.docVIP

Java+javabean+JDBC学生管理系统 项目结构 本项目是使用javabean和jdbc做的，这个包是实体包 这个是菜单包，源码不会再发这些，自己写就好了。 项目运行结果 源码 废话不多说，直接上源码： 这两个是关键源码，是负责登录和学生信息操作的逻辑类： public class AdminDaoImpl extends DBHelper implements AdminDao { Admin admin = null; /** * 登录 */ @SuppressWarnings(resource) @Override public Admin login(String name) { String sql = select * from admin where username=?; Object[] param = {name}; Object obj = this.excute(sql, param); ResultSet rs = (ResultSet) obj; try { while (rs.next()) { admin = new Admin(); String username = rs.getString(username); String password = rs.getString(password); admin.setUsername(username); admin.setPassword(password); } } catch (SQLException e) { System.out.println(未找到此name); } return admin; } } public class StudentDaoImpl extends DBHelper implements StudentDao { Student stu = null; ListStudent list = null; @SuppressWarnings(resource) @Override public Student getInfoByid(int id) { String sql = select * from student where id=?; Object[] param = { id }; Object obj = this.excute(sql, param); ResultSet rs = (ResultSet) obj; stu = new Student(); try { while (rs.next()) { stu.setId(rs.getInt(id)); stu.setName(rs.getString(name)); stu.setAge(rs.getInt(age)); stu.setGender(rs.getString(gender)); stu.setGrade(rs.getString(grade)); stu.setPhone(rs.getLong(phone)); stu.setEmail(rs.getString(email)); stu.setAddress(rs.getString(address)); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(); } return stu; } @SuppressWarnings(resource) @Override public ListStudent getAllStu() { String sql = select * from student; Object obj = this.excute(sql, null); ResultSet rs = (ResultSet) obj; list = new ArrayListStudent(); try { while (rs.next()) { stu = new Student(); stu.setId(rs.getInt(id)); stu.setName(rs.getString(name)); stu.setAge(rs.getInt(age)); stu.setGender(rs.getString(gender)); s