JSP版BBS（MyEclipse+sql2005内含数据库）

package bbs; import jdbc.DB; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; import com.sun.java_cup.internal.internal_error; import beans.UserBean; public class BBSUsers{ final int top=20; final int n=10; public int getPageCount() { int pageCount = 0; DB db = new DB(); String sql = "select count(*) from BBSUsers";//返回版块的记录总数 ResultSet rs = db.getResultSet(sql); try { if (rs.next()) { int count = rs.getInt(1);//记录总数 pageCount = count /n;//得到总页数 if (count % n > 0) {//有余数 pageCount++;//总页数+1 } } } catch (SQLException ex) { ex.printStackTrace(); return 0; } db.setClose(); return pageCount; } public int getPageCount(String username) { int pageCount = 0; DB db = new DB(); String sql = "select count(*) from BBSUsers where uname like '"+username+"' or uname like'"+username+"%' or uname like '%"+username+"%' or uname like'%"+username+"'";//返回版块的记录总数 ResultSet rs = db.getResultSet(sql); try { if (rs.next()) { int count = rs.getInt(1);//记录总数 pageCount = count /n;//得到总页数 if (count % n > 0) {//有余数 pageCount++;//总页数+1 } } } catch (SQLException ex) { ex.printStackTrace(); return 0; } db.setClose(); return pageCount; } public boolean addUser(UserBean userbean) { DB db = new DB(); String name = userbean.getUsername(); String password = userbean.getPassword(); String sex = userbean.getSex(); String email = userbean.getEmail(); String statement = userbean.getStatement(); String sql = "insert into BBSUsers(uname,upassword,usex,uemail,ustatement,uregDate,upoint,ureport,umoney,uimage,uonline) " + " values('" + name + "','" + password + "','"+sex+"','" +email+"','"+statement+"',"+"CONVERT(varchar, getdate(), 120 ) "+",default,default,default,default,default)"; if (db.setUpdate(sql)) { return true; } else { return false; } } public boolean deleteUser(String name){ DB db=new DB(); String sql="delete from BBSUsers where uname='"+name+"'"; if(db.setUpdate(sql)) return true; else return false; } //返回全部注册用户的数量 public String getAllUsersCount(){ DB db=new DB(); String result=null; String sql="select count(*) from BBSUsers"; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) result=rs.getString(1); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } return result; } public String getAllUsersCount(String username){ DB db=new DB(); String result=null; String sql="select count(*) from BBSUsers where uname like '"+username+"' or uname like'"+username+"%' or uname like '%"+username+"%' or uname like'%"+username+"'"; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) result=rs.getString(1); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } return result; } //判断用户名是否存在 public boolean isUser(UserBean userbean){ DB db=new DB(); String name=userbean.getUsername(); String sql="select Uname from BBSUsers where Uname='"+name+"'"; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) return false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return false; } return true; } //返回用户上次登录时间 public String getUserLastTime(int value) { DB db=new DB(); String result=null; String sql="select Ulasttime from BBSUsers where UID="+value; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) result=rs.getString(1); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } return result; } public UserBean ListUser(String username){ String sql="select * from BBSUsers where uclass>0 and uname='"+username+"'"; UserBean userBean=new UserBean(); try{ DB db=new DB(); if(db.getResultSet(sql).next()){ userBean.setUsername(db.getString("uname")); userBean.setPassword(db.getString("upassword")); userBean.setSex(db.getString("usex")); userBean.setEmail(db.getString("uemail")); userBean.setStatement(db.getString("ustatement")); userBean.setRegDate(db.getString("uregDate")); userBean.setClasses(db.getString("uclass")); } else userBean=null; db.setClose(); }catch(Exception e){ e.printStackTrace(); } return userBean; } public String isLogin(String name, String password) { try{ String info = "0"; UserBean user = this.ListUser(name); if(user != null){ if((user.getPassword()).equals(password)) info = "success"; else info = "2"; } else info = "1"; return info; }catch(Exception e){ e.printStackTrace(); return "-1"; } } //判断是否为管理员 public String isAdmin(String name, String password) { try{ String info = "0"; UserBean user = this.ListUser(name); if(user != null&&user.getClasses().equals("50")){ if((user.getPassword()).equals(password)) info = "success"; else info = "2"; } else info = "1"; return info; }catch(Exception e){ e.printStackTrace(); return "-1"; } } //锁定用户,将用户等级设置为0 public boolean lockupUsers(String username){ DB db=new DB(); String sql="update BBSUsers set Uclass=0 where uname='"+username+"'"; if(db.setUpdate(sql)) return true; else return false; } public boolean unfreezeUsers(String username){ DB db=new DB(); String sql="update BBSUsers set Uclass=1 where uname='"+username+"'"; if(db.setUpdate(sql)) return true; else return false; } //返回用户的编号 public int userID(String name){ DB db=new DB(); int uid = 0; String sql="select UID from BBSUsers where Uname='"+name+"'"; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) uid=Integer.parseInt(rs.getString(1)); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return -1; } db.setClose(); return uid; } //返回用户名 public String[] getUserName(String username){ String[] array=username.split(","); return array; } public ArrayList<Integer> userID(ArrayList<String> name){ DB db=new DB(); ArrayList<Integer> arrayList=new ArrayList<Integer>(); for(int i=0;i<name.toArray().length;i++){ String sql="select UID from BBSUsers where Uname='"+name.get(i)+"'"; ResultSet rs=db.getResultSet(sql); try { if(rs.next()) arrayList.add(Integer.parseInt(rs.getString(1))); } catch (NumberFormatException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } catch (SQLExcepti