Spring+SpringMVC+JDBCTemplate简单用户管理功能

package com.um.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import javax.annotation.Resource; import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import com.um.dao.UserDao; import com.um.model.User; @Repository("userDao") public class UserDaoImpl implements UserDao { private JdbcTemplate jdbcTemplate; @Resource public void setDataSource(DataSource dataSource){ this.jdbcTemplate = new JdbcTemplate(dataSource); } @Override public void add(User user) { jdbcTemplate .update("insert into user(username, password, nickname, email) values(?, ?, ?, ?)", user.getUsername(), user.getPassword(), user.getNickname(), user.getEmail()); } @Override public void delete(int id) { jdbcTemplate.update("delete from user where id = ?", id); } @Override public void update(User user) { jdbcTemplate.update("update user set username=?, password=?, nickname=?, email=? where id = ?", user.getUsername(), user.getPassword(), user.getNickname(), user.getEmail(), user.getId()); } @Override public User query(int id) { String sql = "select * from user where id = ?"; User user = jdbcTemplate.queryForObject(sql, new Object[]{id}, new UserMapper()); return user; } @Override public List<User> query() { String sql = "select * from user"; List<User> userList = jdbcTemplate.query(sql, new UserMapper()); return userList; } private class UserMapper implements RowMapper<User> { @Override public User mapRow(ResultSet rs, int rowNum) throws SQLException { User user = new User(); user.setId(rs.getInt("id")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setNickname(rs.getString("nickname")); user.setEmail(rs.getString("email")); return user; } } }