checkuser.java

在线考试系统

package jinghua;

import java.io.PrintStream;
import java.sql.*;

// Referenced classes of package jinghua:
//            JinghuaConn

public class CheckUser
{
    private Connection con;
    private String id;
    private String logname;
    private String logrole;
    private String message;
    private String password;
    private ResultSet rs;
    private Statement stmt;
    private String success;

    public CheckUser()
    {
        success = "false";
        message = "";
    }

    public String getID()
    {
        return id;
    }

    public String getLogname()
    {
        return logname;
    }

    public String getLogrole()
    {
        return logrole;
    }

    public String getMessage()
    {
        JinghuaConn jhcon = new JinghuaConn();
        con = jhcon.getConnection();
        stmt = con.createStatement();
        String sql;
        if(logrole.equals("admin"))
            sql = "select * from sysadmin where userid='" + logname + "'" + "and passwd = " + "'" + password + "'";
        else
        if(logrole.equals("teacher"))
            sql = "select * from teacher where userid='" + logname + "'" + "and passwd = " + "'" + password + "'";
        else
            sql = "select vcUserNo from UserInfo where vcUserNo='" + logname + "'" + "and vcPass = " + "'" + password + "'";
        rs = stmt.executeQuery(sql);
        System.out.println("sql=" + sql);
        if(rs.next())
        {
            message = "OK";
            success = "ok";
            if(logrole.equals("admin") || logrole.equals("teacher"))
                id = String.valueOf(rs.getInt("ID"));
            else
                id = logname;
        } else
        {
            message = "输入的用户名或密码不正确";
            success = "false";
        }
        con.close();
        if(rs == null)
            break MISSING_BLOCK_LABEL_417;
        rs.close();
        break MISSING_BLOCK_LABEL_385;
        SQLException sqlEx;
        sqlEx;
        rs = null;
        if(stmt == null)
            break MISSING_BLOCK_LABEL_416;
        stmt.close();
        break MISSING_BLOCK_LABEL_415;
        sqlEx;
        stmt = null;
        jhcon.dropConnection();
        break MISSING_BLOCK_LABEL_603;
        SQLException e;
        e;
        message = "数据库查询出错" + e.getMessage();
        success = "false";
        if(rs == null)
            break MISSING_BLOCK_LABEL_521;
        rs.close();
        break MISSING_BLOCK_LABEL_489;
        SQLException sqlEx;
        sqlEx;
        rs = null;
        if(stmt == null)
            break MISSING_BLOCK_LABEL_520;
        stmt.close();
        break MISSING_BLOCK_LABEL_519;
        sqlEx;
        stmt = null;
        jhcon.dropConnection();
        break MISSING_BLOCK_LABEL_603;
        Exception exception;
        exception;
        if(rs == null)
            break MISSING_BLOCK_LABEL_595;
        rs.close();
        break MISSING_BLOCK_LABEL_562;
        SQLException sqlEx;
        sqlEx;
        rs = null;
        if(stmt == null)
            break MISSING_BLOCK_LABEL_594;
        stmt.close();
        break MISSING_BLOCK_LABEL_593;
        sqlEx;
        stmt = null;
        jhcon.dropConnection();
        throw exception;
        return message;
    }

    public String getPassword()
    {
        return password;
    }

    public String getSuccess()
    {
        return success;
    }

    public void setLogname(String name)
    {
        logname = name;
    }

    public void setLogrole(String role)
    {
        logrole = role;
    }

    public void setPassword(String pw)
    {
        password = pw;
    }

    
}