一、系统介绍
软件环境
IDEA：2018.2
Java：jdk1.8
Mysql：8.0.13
Tomcat：8.5.23
系统功能
1.管理员登录系统
2.增加学生信息
3.修改学生信息
3.删除学生信息
4.查询学生信息
数据库涉及的表
admin
student
二、系统展示
1.登录系统
2.主页面
3.增加学生信息
4.修改学生信息
5.查询学生信息
三、代码实现
AdminDao
package com.sjsq.dao; import com.sjsq.vo.Admin; /** * @author shuijianshiqing * @date 2021/5/1 9:46 */ public interface AdminDao { /** * 用户登录 * @param admin * @return */ public Admin login(Admin admin); }
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; } }
StudentDao
package com.sjsq.dao; import com.sjsq.vo.Student; import java.util.List; /** * @author shuijianshiqing * @date 2021/4/30 7:52 * * 学生信息接口 */ public interface StudentDao { /** * 查询学生信息 * @param sql * @param arr * @return */ public List<Student> selectAll(String sql, Object[] arr); /** * 根据学号进行查询 * @param id * @return */ public Student selectStudent(Integer id); /** * 新增学生信息 * @param student * @return */ public boolean addStudent(Student student); /** * 修改学生信息 * @param student * @return */ public boolean updateStudent(Student student); /** * 删除学生信息 * @param id * @return */ public boolean deleteStudent(Integer id); }
AdminService
package com.sjsq.service; import com.sjsq.vo.Admin; /** * @author shuijianshiqing * @date 2021/5/1 11:13 */ public interface AdminService { /** * 用户登录 * @param admin * @return */ public Admin login(Admin admin); }
AdminServiceImpl
package com.sjsq.service.impl; import com.sjsq.dao.AdminDao; import com.sjsq.dao.impl.AdminDaoImpl; import com.sjsq.service.AdminService; import com.sjsq.vo.Admin; /** * @author shuijianshiqing * @date 2021/5/1 11:13 */ public class AdminServiceImpl implements AdminService { private AdminDao adminDao = new AdminDaoImpl(); @Override public Admin login(Admin admin) { return adminDao.login(admin); } }
StudentService
package com.sjsq.service; import com.sjsq.vo.Student; import java.util.List; /** * @author shuijianshiqing * @date 2021/5/1 8:26 */ public interface StudentService { /** * 查询学生信息 * @param student * @return */ public List<Student> selectAll(Student student); /** * 根据学号进行查询 * @param id * @return */ public Student selectStudent(Integer id); /** * 新增学生信息 * @param student * @return */ public boolean addStudent(Student student); /** * 修改学生信息 * @param student * @return */ public boolean updateStudent(Student student); /** * 删除学生信息 * @param id * @return */ public boolean deleteStudent(Integer id); }
StudentServiceImpl
package com.sjsq.service.impl; import com.sjsq.dao.StudentDao; import com.sjsq.dao.impl.StudentDaoImpl; import com.sjsq.service.StudentService; import com.sjsq.vo.Student; import java.util.ArrayList; import java.util.List; /** * @author shuijianshiqing * @date 2021/5/1 8:26 */ public class StudentServiceImpl implements StudentService { private StudentDao studentDao = new StudentDaoImpl(); @Override public List<Student> selectAll(Student student) { StringBuffer sql = new StringBuffer("select * from student where 1 = 1 "); List<Object> list = new ArrayList<Object>(); if(student != null){ // 根据id来查找对应的学生信息 if(student.getId() != null && student.getId() != 0){ sql.append(" and id = ?"); list.add(student.getId()); } } return studentDao.selectAll(sql.toString(),list.toArray()); } @Override public Student selectStudent(Integer id) { return studentDao.selectStudent(id); } @Override public boolean addStudent(Student student) { return studentDao.addStudent(student); } @Override public boolean updateStudent(Student student) { return studentDao.updateStudent(student); } @Override public boolean deleteStudent(Integer id) { return studentDao.deleteStudent(id); } }
