Java资源 学习JavaWeb做的小型项目

package cn.itcast.dao.impl; import cn.itcast.dao.UserDao; import cn.itcast.domain.User; import cn.itcast.util.JDBCUtils; import org.springframework.dao.DataAccessException; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import java.util.*; public class UserDaoImpl implements UserDao { private JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBCUtils.getDataSource()); @Override public List<User> findAll() { //使用JDBC操作数据库 //1、定义sql String sql = "select * from user"; List<User> users = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class)); return users; } /** * 根据 用户名 + 密码 * @param user * @return */ @Override public User findByUsernameAndPassword(User user) { try { String sql = "select * from user where username = ? and password = ?"; return jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper<>(User.class),user.getUsername(),user.getPassword()); } catch (DataAccessException e) { return null; } } @Override public void addUser(User user) { if (user != null){ String sql = "insert into user values(null,?,?,?,?,?,?,null,null)"; jdbcTemplate.update(sql,user.getName(),user.getGender(),user.getAge(), user.getAddress(),user.getQq(),user.getEmail()); } } @Override public void deleteUserById(int id) { String sql = "delete from user where id = ?"; jdbcTemplate.update(sql,id); } @Override public User findUserById(int id) { String sql = "select * from user where id = ?"; return jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), id); } @Override public void updateUser(User user) { //user.getName(),user.getGender(),user.getAge(), // user.getAddress(),user.getQq(),user.getEmail() String sql = "update user set name = ?,gender = ?,age = ?,address = ?,qq = ?,email = ? where id = ?"; jdbcTemplate.update(sql,user.getName(),user.getGender(),user.getAge(), user.getAddress(),user.getQq(),user.getEmail(),user.getId()); } @Override public int findTotalCount(Map<String, String[]> condition) { String sql = "select count(*) from user where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keys = condition.keySet(); List<Object> params = new ArrayList<>(); for (String key : keys) { //排除分页的条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } String value = condition.get(key)[0]; //判断value是否有值 if (value != null && !"".equals(value)){ //有值，拼接sql sb.append(" and " + key + " like ? "); params.add("%" + value + "%"); //?的值 } } //return jdbcTemplate.queryForObject(sb.toString(),Integer.class,params.toString()); //error return jdbcTemplate.queryForObject(sb.toString(),Integer.class,params.toArray()); } @Override public List<User> findByPage(int start, int rows, Map<String, String[]> condition) { String sql = "select * from user where 1 = 1 "; StringBuilder sb = new StringBuilder(sql); Set<String> keys = condition.keySet(); List<Object> params = new ArrayList<>(); for (String key : keys) { //排除分页的条件参数 if ("currentPage".equals(key) || "rows".equals(key)){ continue; } String value = condition.get(key)[0]; //判断value是否有值 if (value != null && !"".equals(value)){ //有值，拼接sql sb.append(" and " + key + " like ? "); params.add("%" + value + "%"); //?的值 } } //添加分页查询参数 sb.append("limit ?,? "); //添加分页查询参数值 params.add((start - 1) * 5); params.add(rows); System.out.println(sb.toString()); System.out.println(params.toString()); return jdbcTemplate.query(sb.toString(),new BeanPropertyRowMapper<>(User.class),params.toArray()); } }