雅士力OA办公管理系统

package operator; import java.sql.SQLException; import java.sql.Types; import java.util.ArrayList; import bean.MsgBean; import bean.UserBean; import common.SqlCon; public class UserBo extends SqlCon { //验证用户名和密码的方法 public UserBean userInvalid(String name, String psw) { UserBean bean = new UserBean(); conn = getConnection(); String sql = "select * from userInfo where userName='" + name + "' and userPsw='" + psw + "'"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { bean.setUserId(rs.getInt(1)); bean.setUserName(rs.getString(2)); bean.setUserPsw(rs.getString(3)); bean.setUserDept(rs.getString(4)); bean.setUserResume(rs.getString(5)); bean.setUserDate(rs.getString(6)); bean.setUserActor(rs.getString(7)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } closeCon(); return bean; } //修改密码的方法 public int resetPsw(String newPsw, int userid) { conn = getConnection(); int rst = 0; String sql = "update userInfo set userPsw='" + newPsw + "' where id=" + userid + ""; try { pstmt = conn.prepareStatement(sql); rst = pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } closeCon(); return rst; } //查询所有用户名的方法 public ArrayList searchUserName(String crrentUser) { ArrayList list = new ArrayList(); System.out.println(crrentUser); conn = getConnection(); String sql = "select userName from userInfo where UserName!='" + crrentUser + "'"; System.out.println(sql); try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); UserBean bean; while (rs.next()) { bean = new UserBean(); bean.setUserName(rs.getString(1)); list.add(bean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } closeCon(); return list; } //通过用户名查询查询密码的方法 public int searchUserId(String name) { int userId = 0; conn = getConnection(); String sql = "select id from userInfo where UserName='" + name + "'"; try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { userId = rs.getInt(1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } closeCon(); return userId; } //用户信息插入方法 public int insertUser(UserBean bean) { int result = 0; conn = getConnection(); String sql = "insert into userInfo(userName,userPsw,userDept,userResume,userActor) values(?,?,?,?,?)"; try { pstmt=conn.prepareStatement(sql); pstmt.setString(1, bean.getUserName()); pstmt.setString(2, bean.getUserPsw()); pstmt.setString(3, bean.getUserDept()); pstmt.setString(4, bean.getUserResume()); pstmt.setString(5, bean.getUserActor()); result=pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return result; } //查询用户信息的方法 public ArrayList searchUsers(String sql) { ArrayList list = new ArrayList(); conn = getConnection(); try { clst = conn.prepareCall(sql); clst.registerOutParameter(1, Types.INTEGER); rs = clst.executeQuery(); UserBean bean; //PageBean page = new PageBean(); while (rs.next()) { bean = new UserBean(); bean.setUserId(rs.getInt(1)); bean.setUserName(rs.getString(2)); bean.setUserPsw(rs.getString(3)); bean.setUserDept(rs.getString(4)); bean.setUserDate(rs.getString(5)); bean.setUserResume(rs.getString(6)); list.add(bean); } Object number =clst.getInt(1);// 根据位置序号获取输出参数 System.out.println(number); //page.setTotalRecorder(number); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } closeCon(); return list; } public int delUser(int id) { int lean=-4; conn = getConnection(); String sql="delete from userInfo where id="+id+""; try { pstmt=conn.prepareStatement(sql); lean=pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { closeCon(); } return lean; } }