教务管理系统（JSP+Servlet+JavaBean+数据库）.zip

package com.soft202.usercase.dao.impl; import com.soft202.usercase.dao.UserDao; import com.soft202.usercase.domain.Edu; import com.soft202.usercase.util.JDBCUtils; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Set; public class UserDaoImpl implements UserDao { private JdbcTemplate template= new JdbcTemplate(JDBCUtils.getDataSource()); @Override public List<Edu> findAll() { String sql="select * from course"; List<Edu> users = template.query(sql, new BeanPropertyRowMapper<Edu>(Edu.class)); return users; } @Override public Edu findUserByUsernameAndPassword(String username, String password) { try { String sql ="select * from userlogin where username=? and password=?"; Edu user = template.queryForObject(sql, new BeanPropertyRowMapper<Edu>(Edu.class), username, password); return user; } catch (Exception e) { e.printStackTrace(); return null; } } @Override public void add(Edu user) { //定义sql String sql="insert into course values(?,?,?,?,?,?,?,?,?)"; //执行sql template.update(sql,user.getCourseid(),user.getCoursename(),user.getTeacherid(),user.getCoursetime(),user.getClassroom(),user.getCourseweek(),user.getCoursetype(),user.getCollegeid(),user.getScore()); } @Override public void delete(int id) { String sql="delete from course where courseID =?"; template.update(sql,id); } @Override public Edu findUserByID(int id) { //定义sql String sql = "select * from course where courseid=?"; return template.queryForObject(sql,new BeanPropertyRowMapper<Edu>(Edu.class),id); } @Override public void update(Edu user) { String sql="update course set coursename=?,teacherid=?,coursetime=?,classroom=?,courseweek=?,coursetype=?,collegeid=?,score=? where courseid=?"; template.update(sql,user.getCoursename(),user.getTeacherid(),user.getCoursetime(), user.getClassroom(),user.getCourseweek(),user.getCoursetype(),user.getCollegeid(),user.getScore(),user.getCourseid()); } @Override public int findTotalCount(Map<String, String[]> condition) { // String sql="select count(*) from user"; String sql="select count(*) from course where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keySet = condition.keySet(); // 定义一个参数的集合 List<Object> params = new ArrayList<Object>(); for (String key : keySet) { // 排除分页条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } // 获取value String value = condition.get(key)[0]; //判断value是否有值 if (value!=null && !"".equals(value)){ //有值 sb.append(" and "+key+" like ? "); params.add("%"+value+"%");//加条件的值 } } // System.out.println(sb.toString()); // System.out.println(params); return template.queryForObject(sb.toString(), Integer.class,params.toArray()); } @Override public List<Edu> findByPage(int start, int rows, Map<String, String[]> condition) { // String sql="select * from user limit ?,?"; String sql="select * from course where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keySet = condition.keySet(); // 定义一个参数的集合 List<Object> params = new ArrayList<Object>(); for (String key : keySet) { // 排除分页条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } // 获取value String value = condition.get(key)[0]; //判断value是否有值 if (value!=null && !"".equals(value)){ //有值 sb.append(" and "+key+" like ? "); params.add("%"+value+"%");//加条件的值 } } sb.append(" limit ?,?"); params.add(start); params.add(rows); sql = sb.toString(); return template.query(sql,new BeanPropertyRowMapper<Edu>(Edu.class),params.toArray()); } @Override public int findTotalCountStudent(Map<String, String[]> condition) { // String sql="select count(*) from user"; String sql="select count(*) from student where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keySet = condition.keySet(); // 定义一个参数的集合 List<Object> params = new ArrayList<Object>(); for (String key : keySet) { // 排除分页条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } // 获取value String value = condition.get(key)[0]; //判断value是否有值 if (value!=null && !"".equals(value)){ //有值 sb.append(" and "+key+" like ? "); params.add("%"+value+"%");//加条件的值 } } // System.out.println(sb.toString()); // System.out.println(params); return template.queryForObject(sb.toString(), Integer.class,params.toArray()); } @Override public List<Edu> findByPageStudent(int start, int rows, Map<String, String[]> condition) { String sql="select * from A_Student where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keySet = condition.keySet(); // 定义一个参数的集合 List<Object> params = new ArrayList<Object>(); for (String key : keySet) { // 排除分页条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } // 获取value String value = condition.get(key)[0]; //判断value是否有值 if (value!=null && !"".equals(value)){ //有值 sb.append(" and "+key+" like ? "); params.add("%"+value+"%");//加条件的值 } } sb.append(" limit ?,?"); params.add(start); params.add(rows); sql = sb.toString(); return template.query(sql,new BeanPropertyRowMapper<Edu>(Edu.class),params.toArray()); } @Override public int findTotalCountTeacher(Map<String, String[]> condition) { String sql="select count(*) from teacher where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keySet = condition.keySet(); // 定义一个参数的集合 List<Object> params = new ArrayList<Object>(); for (String key : keySet) { // 排除分页条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } // 获取value String value = condition.get(key)[0]; //判断value是否有值 if (value!=null && !"".equals(value)){ //有值 sb.append(" and "+key+" like ? "); params.add("%"+value+"%");//加条件的值 } } // System.out.println(sb.toString()); // System.out.println(params); return template.queryForObject(sb.toString(), Integer.class,params.toArray()); } @Override public List<Edu> findByPageTeacher(int start, int rows, Map<String, String[]> condition) { Stri