loginbo.java

网上报名系统,是一个功能很完善的系统,推存给大家,很好用的

package bo;

import myjdbc.DatabaseOperation;
import enrollment.LogInForm;
import java.util.List;

public class LogInBo {
    private static LogInBo rbo = null;
    private static DatabaseOperation db = null;
    private LogInBo() {
        db = DatabaseOperation.getInstance();
    }

    public static LogInBo getInstance() {
        if (rbo == null)
            rbo = new LogInBo();
        return rbo;
    }
    public String verifyUser(LogInForm form)
    {
        String idCard = form.getIdCard();
        String pw = form.getPassword();
        StringBuffer sb = new StringBuffer();
        sb.append("select password , class_id from wb_applicantinfo where id_card = '"+idCard+"' ");
        List result = db.executeSQL(sb.toString());
        if (result.size() == 0)
            return "身份证号输入有误！";
        String pwFromDb = (String)((Object[])result.get(0))[0];
        if (!pw.equals(pwFromDb))
            return "密码输入有误！";

        form.setClassId((String)((Object[])result.get(0))[1]);
        return null;
    }
}