clubmasterlogin.java

特色说明： 1.沿袭今晚在线论坛独有的双风格分桢形式 2.社区最多可进行3级分类

/*
 * Made in GamVan
 */
package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
public class ClubMasterLogin{
    private String gvcmName, gvcmPass, gvcmPassSave;
    private int cmgID = 0;
    private Statement sta;
    EncodeString ens = new EncodeString();
    private boolean temp = false; //验证管理员是否通过
    Gb clubgb = new Gb();
    public boolean clubMasterLogin(){
        String sqlCommand;
        try{
        ConnClub bridge = new ConnClub();
        ResultSet rs;
        sqlCommand = new String();
        Connection con = bridge.getConnection();
        sta = con.createStatement();
        sqlCommand = "SELECT * FROM GVclubMaster where cmName='" + gvcmName + "' and cmPass = '"+ gvcmPass +"'";
        rs = sta.executeQuery(sqlCommand);
        temp = rs.next();
        //rs.next();
        cmgID = rs.getInt("cmgID");
        rs.close();
        sta.close();
        con.close();
        }catch(Exception e){
        }
        return temp;
    }
    public int getCmgID(){
        return this.cmgID;
    }
    public void setCmName(String cmName){
        cmName = clubgb.Gb(cmName);
        this.gvcmName = cmName;
    }
    public void setCmPass(String cmPass){
        cmPass = ens.encodeString("md5of16",cmPass);
        this.gvcmPass = cmPass;
    }
    public void setPassSave(String cmPassSave){
        this.gvcmPassSave = cmPassSave;
    }
}