struts+spring +jdbctemplate demo

package com.bp.user.daoImpl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import com.bp.entity.User; import com.bp.user.dao.UserDao; public class UserDaoImple implements UserDao { private JdbcTemplate jdbcTemplate; @Override public int addUser(User user) { String addSql = "insert into user (userName,password) values(?,?)"; int rs = jdbcTemplate.update(addSql, new Object[]{user.getUserName(),user.getPassword()}); return rs ; } @Override public User findUserById(User user) { String selectSql = "select * from user where id= ?"; List<User> users = jdbcTemplate.query(selectSql,new Object[]{user.getId()}, new UserRowMap()); return null != users && users.size() != 0 ? users.get(0) : null; } @Override public User findUserByName(User user) { String selectSql = "select * from user where userName= ?"; List<User> users = jdbcTemplate.query(selectSql,new Object[]{user.getUserName()}, new UserRowMap()); return null != users && users.size() != 0 ? users.get(0) : null; } @Override public List<User> findAllUsers() { String selectSql = "select * from user"; List<User> users = jdbcTemplate.query(selectSql, new UserRowMap()); return users; } @Override public int updateUser(User user) { String addSql = "update user set user.password = ?,user.userName = ? where user.id = ?"; int rs = jdbcTemplate.update(addSql, new Object[]{user.getPassword(),user.getUserName(),user.getId()}); return rs ; } @Override public int deleteUser(User user) { String addSql = "delete from user where user.id = ?"; int rs = jdbcTemplate.update(addSql, new Object[]{user.getId()}); return rs ; } class UserRowMap implements RowMapper{ @Override public User mapRow(ResultSet rs, int index) throws SQLException { User user = new User(); user.setId(rs.getInt("id")); user.setUserName(rs.getString("userName")); user.setPassword(rs.getString("password")); return user; } } @Override public User findUserByNameAndPoss(User user) { String selectSql = "select * from user where user.userName= ? and user.password =?"; List<User> users = jdbcTemplate.query(selectSql, new Object[]{user.getUserName(),user.getPassword()}, new UserRowMap()); return null != users && users.size() != 0 ? users.get(0) : null; } public JdbcTemplate getJdbcTemplate() { return jdbcTemplate; } public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } }