问题描述
//这是一个处理类(处理users表)<--->操作UserBean//业务逻辑在这里packagecom.tsinghua;importjava.sql.*;importjava.util.*;publicclassUserBeanCl{//业务逻辑privateConnectionct=null;privatePreparedStatementps=null;privateResultSetrs=null;privateintpageCount=0;//共有几页(计算)//修改用户publicbooleanupdateUser(Stringid,Stringemail,Stringpasswd,Stringgrade){booleanb=false;try{//得到连接ConnDBcd=newConnDB();ct=cd.getConn();Stringsql="updateuserssetpasswd='"+passwd+"',email='"+email+"',grade='"+grade+"'whereuserid='"+id+"'";//打印System.out.println("sql===="+sql);ps=ct.prepareStatement(sql);intnum=ps.executeUpdate();if(num==1){//删除成功!b=true;}}catch(Exceptionex){ex.printStackTrace();}finally{this.close();}returnb;}//删除用户publicbooleandelUser(Stringid){booleanb=false;try{//得到连接ConnDBcd=newConnDB();ct=cd.getConn();Stringsql="deletefromuserswhereuserid='"+id+"'";ps=ct.prepareStatement(sql);intnum=ps.executeUpdate();if(num==1){//删除成功!b=true;}}catch(Exceptionex){ex.printStackTrace();}finally{this.close();}returnb;}//返回pageCount;publicintgetPageCount(){returnthis.pageCount;}//分页显示publicArrayListgetResultByPage(intpageNow,intpageSize){ArrayListal=newArrayList();try{introwCount=0;//共有几条记录(查表)//得到rowCountConnDBcd=newConnDB();ct=cd.getConn();ps=ct.prepareStatement("selectcount(*)fromusers");rs=ps.executeQuery();if(rs.next()){rowCount=rs.getInt(1);}//计算pageCountif(rowCount%pageSize==0){pageCount=rowCount/pageSize;}else{pageCount=rowCount/pageSize+1;}ps=ct.prepareStatement("selecttop"+pageSize+"*fromuserswhereuserIdnotin(selecttop"+pageSize*(pageNow-1)+"userIdfromusers)");rs=ps.executeQuery();while(rs.next()){//将rs中的每条记录封装到UserBeanubUserBeanub=newUserBean();ub.setUserId(rs.getInt(1));ub.setUserName(rs.getString(2));ub.setPasswd(rs.getString(3));ub.setMail(rs.getString(4));ub.setGrade(rs.getInt(5));//将ub,放入到ArrayList中al.add(ub);}}catch(Exceptionex){ex.printStackTrace();}finally{this.close();}returnal;}//验证用户publicbooleancheckUser(Stringu,Stringp){booleanb=false;try{//得到连接ConnDBcd=newConnDB();ct=cd.getConn();ps=ct.prepareStatement("selecttop1passwdfromuserswhereusername=?");ps.setString(1,u);rs=ps.executeQuery();if(rs.next()){StringdbPasswd=rs.getString(1);if(dbPasswd.equals(p)){b=true;}}}catch(Exceptionex){ex.printStackTrace();}finally{this.close();}returnb;}//关闭资源publicvoidclose(){try{if(rs!=null){rs.close();rs=null;}if(ps!=null){ps.close();ps=null;}if(ct!=null){ct.close();ct=null;}}catch(Exceptionex){ex.printStackTrace();}}}
解决方案
解决方案二:
该回复于2011-03-16 08:36:02被版主删除