登陆、修改个人信息、更新功能的个人管理系统功能

package com.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import com.dao.BaseDao; import com.dao.upadeDao; import com.entity.User; public class UpdateUser implements upadeDao { private Connection conn=null; private PreparedStatement ptmt=null; private ResultSet rs=null; BaseDao baseDao=new BaseDao(); public User FindUser(String loginName,String loginPaw) { conn=baseDao.getConn(); User user=null; try{ String sql="Select * from Table_UserInfo where LoginName=? and PassWord=?"; ptmt=conn.prepareStatement(sql); ptmt.setString(1, loginName); ptmt.setString(2, loginPaw); rs=ptmt.executeQuery(); while(rs.next()){ user=new User(); user.setLoginName(rs.getString(1)); user.setUserName(rs.getString(2)); user.setPassWord(rs.getString(3)); user.setAge(rs.getInt(4)); user.setAddress(rs.getString(5)); } }catch(Exception e){ e.printStackTrace(); System.out.print("查询用户信息出错！"); }finally{ baseDao.closeAll(rs, ptmt, conn); } return user; } public int UpdateUserInfor(User NewUser,User user) { int i=0; conn=baseDao.getConn(); try{ String sql="Update Table_UserInfo set LoginName=?,UserName=?,Age=?,address=? where loginName=? and PassWord=?"; ptmt=conn.prepareStatement(sql); ptmt.setString(1, NewUser.getLoginName()); ptmt.setString(2, NewUser.getUserName()); ptmt.setInt(3, NewUser.getAge()); ptmt.setString(4, NewUser.getAddress()); ptmt.setString(5, user.getLoginName()); ptmt.setString(6, user.getPassWord()); i=ptmt.executeUpdate(); }catch(Exception e){ e.printStackTrace(); System.out.print("修改用户信息出错！"); }finally{ baseDao.closeAll(rs, ptmt, conn); } return i; } }