menagerinfo.java~8~

基于WEB的作业提交系统,是用JSP,JBUILDER,TOMCAT,MYSQL联合开发的JSP系统

package work.info;
import work.tools.*;

public class MenagerInfo {
    private String mid;
    private String mpass;
    String status="操作成功";
    private ConnectBean cb=new ConnectBean();

    public MenagerInfo() {

    }
    public void setMid(String mid) {
        this.mid = mid;
    }

    public void setMpass(String mPass) {
        this.mpass = mPass;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getMid() {
        return mid;
    }

    public String getMpass() {
        return mpass;
    }

    public String getStatus() {
        return status;
    }

    public boolean login() {
    String oldPassword;
    boolean bl = false;
    try {
        cb.openConnection();
        String query =
                "select mpass from menager where mid='" +
                mid + "'";
        System.out.println(query);
        cb.createPreparedStatement(query);

        System.out.println("ok");
        cb.executeQuery();
        if (cb.next()) {
            //userId = cb.getIntData(1); ;
            oldPassword = cb.getData(2);
            if (oldPassword.trim().equals(mpass)) {
                System.out.println("OK!!!");
                return bl = true;
            } else {
                status = "密码错误!!!";
            }
        } else {
            status = "用户不存在!";
        }
    } catch (Exception e) {
        status = e + "";
    }
    return bl;
}



}