bbsadmin.java

论坛源码

package twm;

import java.sql.ResultSet;
import java.sql.SQLException;
import twm.bbsreg;

public class bbsadmin
{

    bbsreg dbconn;
    ResultSet rs;
    String strSQL;
    boolean yesorno;
    int id;
    String adminname;
    String adminpwd;

    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;
    }
}