本文详细介绍了用户数据的添加、查询及详情获取过程，通过使用Spring JDBC模板进行数据库操作。
添加用户
public void addUser(User user) {
StringBuffer strSql = new StringBuffer();
strSql .append("insert into user(id ,name) values(:id, :name)");
try {
SqlParameterSource ps = new BeanPropertySqlParameterSource(user);
simpleJdbcTemplate.update(strSql.toString(), ps);
} catch (Exception e) {
throw new DAOException("添加用户异常");
}
}
查询用户列表
public List<User> findAllUser(String name) {
List<User> userList = null;
StringBuffer strSql = new StringBuffer();
strSql .append(" SELECT id, name FROM user where name= :name ");
try {
userList = simpleJdbcTemplate.query(sbSql.toString(),
new BeanPropertyRowMapper<User>(User.class),
new MapSqlParameterSource().addValue("name ", name));
} catch (Exception e) {
throw new DAOException("查询用户列表异常");
}
return userList;
}
查询用户
public User findProduct(int id) {
User user = null;
StringBuffer strSql = new StringBuffer();
strSql .append("select id, name from user t where t.id= :id");
MapSqlParameterSource parameterSource = new MapSqlParameterSource().addValue("id", id);
try {
user= simpleJdbcTemplate.queryForObject(
sbSql.toString(),
new BeanPropertyRowMapper<User>(User.class),parameterSource);
} catch (Exception e) {
throw new DAOException("用户不存在");
}
return user;
}
扫一扫
12
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
