adminuser.java

一个运行成功的论坛

package mybbs;
import java.sql.*;
public class AdminUser {
  public AdminUser(){}
  public StringBuffer getLockedUser(){
    StringBuffer buffer=new StringBuffer();
    DBConn conn=new DBConn();
    String sql="SELECT * FROM bbsuser WHERE islock=1";
  try{
    ResultSet rs=conn.query(sql);
    while (rs.next()) {
      buffer.append("<a href='LockUser.do?action=2&userid="+rs.getInt("id")+"'>");
      buffer.append(rs.getString("nickname")+"</a>&nbsp;&nbsp;&nbsp;");
    }
    conn.DBclose();
  }
  catch(Exception e){
     buffer.append("没以锁定用户！");
   }
   return buffer;
  }
}