springmvc+oracle实现用户登录和用户管理

package com.dragon.dao.impl; import java.util.ArrayList; import java.util.List; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; import org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper; import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport; import com.dragon.dao.UserInfoDao; import com.dragon.entity.UserInfo; @SuppressWarnings("deprecation") public class UserInfoDaoImpl extends SimpleJdbcDaoSupport implements UserInfoDao{ /** * 获得所有 */ public List<UserInfo> getAll() { // TODO Auto-generated method stub List<UserInfo> userInfoList = new ArrayList<UserInfo>(); String sql = "select * from UserInfo"; userInfoList = super.getSimpleJdbcTemplate().query(sql,ParameterizedBeanPropertyRowMapper.newInstance(UserInfo.class)); return userInfoList; } /** * 增加 */ public int insertUserInfo(UserInfo userInfo) { // TODO Auto-generated method stub String sql="INSERT INTO UserInfo values(:user_id,:user_name,:user_password)"; //返回受影响的行数 int count = super.getSimpleJdbcTemplate().update(sql, new MapSqlParameterSource().addValue("user_id", userInfo.getUser_id()).addValue("user_name", userInfo.getUser_name()).addValue("user_password", userInfo.getUser_password())); return count; } /** * 删除 */ public int deleteUser(int user_id){ String sql = "delete UserInfo where user_id="+user_id; int count = super.getSimpleJdbcTemplate().update(sql); return count; } /** * 查找 */ public UserInfo findUserInfoById(int user_id) { List<UserInfo> userInfoList = new ArrayList<UserInfo>(); String sql = "select * from UserInfo where user_id="+user_id; userInfoList = super.getSimpleJdbcTemplate().query(sql, ParameterizedBeanPropertyRowMapper.newInstance(UserInfo.class)); return userInfoList.get(0); } /** * 修改 */ public void updateUserInfo(UserInfo userInfo) { String sql = "update UserInfo set user_name='"+userInfo.getUser_name()+"'，user_password='"+userInfo.getUser_password()+"' where user_id="+userInfo.getUser_id(); System.out.println(sql); super.getSimpleJdbcTemplate().update(sql); } @Override public boolean login(String name, String password) { List<UserInfo> userInfoList = new ArrayList<UserInfo>(); String sql="select * from UserInfo where user_name='"+name+"'and user_password='"+password+"'"; userInfoList= super.getSimpleJdbcTemplate().query(sql, ParameterizedBeanPropertyRowMapper.newInstance(UserInfo.class)); if(userInfoList!=null && userInfoList.size()>0){ return true; } return false; } }