bbsadmin.java

本书注重理论联系实际

// Source File Name:   bbsadmin.java
package test;
import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;

// Referenced classes of package test:
//            bbsreg

public class bbsadmin
{
    public bbsadmin()
    {
        dbconn = new bbsreg();
        rs = null;
        id = 0;
        adminname = "";
        adminpwd = "";
    }

    public boolean checkAdminPassword(String s, String s1)
    {//检查管理用户的密码
        rs = null;
        strSQL = "select * from admin where adminname='" + s + "' and adminpwd='" + s1 + "'";
        try
        {
            rs = dbconn.executeQuery(strSQL);
            if(rs.next())
            {
                yesorno = true;
                adminname = rs.getString("adminname");
                adminpwd = rs.getString("adminpwd");
            } else
            {
                yesorno = false;
            }
            rs.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
            System.err.println("checkuserpassword.STRSQL:: " + strSQL);
        }
        return yesorno;
    }
    public String getAdminName()
    {//返回管理员的用户名
        return adminname;
    }
    public String getAdminPassword()
    {//返回管理员密码
        return adminpwd;
    }
    bbsreg dbconn;
    ResultSet rs;
    String strSQL;
    boolean yesorno;
    int id;
    String adminname;
    String adminpwd;
}