JSP BBS论坛源码

package com.web.dao; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import com.web.bean.Userinfobean; import com.web.util.MyCon; public class Userinfodao { private Connection con = null; private ResultSet rs = null; private PreparedStatement ps =null; //登陆 public Userinfobean isLogin(String userName,String userPwd){ String sql = "select * from userinfo where uname = ? and upassword = ?"; Userinfobean use = null; try { con = MyCon.getCon(); ps = con.prepareStatement(sql); ps.setString(1, userName); ps.setString(2, userPwd); rs =ps.executeQuery(); while(rs.next()){ use = new Userinfobean(); use.setUid(rs.getInt(1)); use.setUname(rs.getString(2)); use.setUpassWord(rs.getString(3)); use.setUemail(rs.getString(4)); use.setUsex(rs.getInt(5)); use.setUclass(rs.getInt(6)); use.setUstatement(rs.getString(7)); use.setUregDate(rs.getString(8)); use.setUstate(rs.getInt(9)); use.setUpoint(rs.getInt(10)); use.setUrname(rs.getString(11)); use.setUtel(rs.getString(12)); use.setUbrithday(rs.getString(13)); use.setUaddress(rs.getString(14)); use.setUpostcode(rs.getInt(15)); use.setUidCard(rs.getString(16)); use.setUhobby(rs.getString(17)); use.setUtrade(rs.getString(18)); use.setUjob(rs.getString(19)); use.setUmarriage(rs.getString(20)); use.setQq(rs.getString(21)); use.setUimage(rs.getString(22)); use.setUdid(rs.getInt(23)); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return use; } //注册新用户 public boolean append(Userinfobean user){ String sql="insert into userinfo(UName,UPassword,USex,Ustatement,UEmail,URname,UBirthday,UPostcode ," + "UTrade,UHobby,UIDcard,UJob,UTel,Uaddress,QQ,UMarriage,UImage) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; try { con=MyCon.getCon(); ps=con.prepareStatement(sql); ps.setString(1, user.getUname()); ps.setString(2, user.getUpassWord()); ps.setInt(3, user.getUsex()); ps.setString(4, user.getUstatement()); ps.setString(5, user.getUemail()); ps.setString(6, user.getUrname()); ps.setString(7, user.getUbrithday()); ps.setInt(8, user.getUpostcode()); ps.setString(9, user.getUtrade()); ps.setString(10, user.getUhobby()); ps.setString(11, user.getUidCard()); ps.setString(12, user.getUjob()); ps.setString(13, user.getUtel()); ps.setString(14, user.getUaddress()); ps.setString(15, user.getQq()); ps.setString(16, user.getUmarriage()); ps.setString(17, user.getUimage()); int i=ps.executeUpdate(); if(i>0) { return true; } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return false; } public String idtoname(int uid){ String name = null; String sql = "select uname from userinfo where uid="+uid; Userinfobean use = null; try { con = MyCon.getCon(); ps = con.prepareStatement(sql); rs =ps.executeQuery(); if(rs.next()){ name = rs.getString(1); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return name; } //查看所有用户信息 public Userinfobean byuidgetUserinfobean(int uid){ String sql="select * from userinfo where uid=?"; try { Userinfobean use= new Userinfobean(); con=MyCon.getCon(); ps=con.prepareStatement(sql); ps.setInt(1, uid); rs=ps.executeQuery(); if(rs.next()){ use.setUid(rs.getInt(1)); use.setUname(rs.getString(2)); use.setUpassWord(rs.getString(3)); use.setUemail(rs.getString(4)); use.setUsex(rs.getInt(5)); use.setUclass(rs.getInt(6)); use.setUstatement(rs.getString(7)); use.setUregDate(rs.getString(8)); use.setUstate(rs.getInt(9)); use.setUpoint(rs.getInt(10)); use.setUrname(rs.getString(11)); use.setUtel(rs.getString(12)); use.setUbrithday(rs.getString(13)); use.setUaddress(rs.getString(14)); use.setUpostcode(rs.getInt(15)); use.setUidCard(rs.getString(16)); use.setUhobby(rs.getString(17)); use.setUtrade(rs.getString(18)); use.setUjob(rs.getString(19)); use.setUmarriage(rs.getString(20)); use.setQq(rs.getString(21)); use.setUimage(rs.getString(22)); use.setUdid(rs.getInt(23)); } return use; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return null; } public ArrayList queryall(int currentpage,int pagesize,String uname){ try { ArrayList al=new ArrayList(); con=MyCon.getCon(); CallableStatement cs=null; String sql="{call fen (?,?,?)}"; cs=con.prepareCall(sql); cs.setInt(1, currentpage); cs.setInt(2, pagesize); cs.setString(3, uname); cs.execute(); rs=cs.getResultSet(); while(rs.next()){ Userinfobean use= new Userinfobean(); use.setUid(rs.getInt(1)); use.setUname(rs.getString(2)); use.setUpassWord(rs.getString(3)); use.setUemail(rs.getString(4)); use.setUsex(rs.getInt(5)); use.setUclass(rs.getInt(6)); use.setUstatement(rs.getString(7)); use.setUregDate(rs.getString(8)); use.setUstate(rs.getInt(9)); use.setUpoint(rs.getInt(10)); use.setUrname(rs.getString(11)); use.setUtel(rs.getString(12)); use.setUbrithday(rs.getString(13)); use.setUaddress(rs.getString(14)); use.setUpostcode(rs.getInt(15)); use.setUidCard(rs.getString(16)); use.setUhobby(rs.getString(17)); use.setUtrade(rs.getString(18)); use.setUjob(rs.getString(19)); use.setUmarriage(rs.getString(20)); use.setQq(rs.getString(21)); use.setUimage(rs.getString(22)); use.setUdid(rs.getInt(23)); al.add(use); } return al; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return null; } public int allnum(){ int num=0; String sql = "select * from userinfo "; try { con = MyCon.getCon(); ps = con.prepareStatement(sql); rs =ps.executeQuery(); while(rs.next()){ num++; } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close(); } return num; } public ArrayList byudidbyUserinfobean(int udid){ ArrayList al= new ArrayList(); String sql="select * from userinfo where udid=?"; try { con=MyCon.getCon(); ps=con.prepareStatement(sql); ps.setInt(1, udid); rs=ps.executeQuery(); while(rs.next()){ Userinfobean use= new Userinfobean(); use.setUid(rs.getInt(1)); use.setUname(rs.getString(2)); use.setUpassWord(rs.getString(3)); use.setUemail(rs.getString(4)); use.setUsex(rs.getInt(5)); use.setUclass(rs.getInt(6)); use.setUstatement(rs.getString(7)); use.setUregDate(rs.getString(8)); use.setUstate(rs.getInt(9)); use.setUpoint(rs.getInt(10)); use.setUrname(rs.getString(11)); use.setUtel(rs.getString(12)); use.setUbrithday(rs.getString(13)); use.setUaddress(rs.getString(14)); use.setUpostcode(rs.getInt(15)); use.setUidCard(rs.getString(16)); use.setUhobby(rs.getString(17)); use.setUtrade(rs.getString(18)); use.setUjob(rs.getString(19)); use.setUmarriage(rs.getString(20)); use.setQq(rs.getString(21)); use.setUimage(rs.getString(22)); use.setUdid(rs.getInt(23)); al.add(use); } return al; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.Close();