checkuser.jad

在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构

// Decompiled by DJ v3.2.2.67 Copyright 2002 Atanas Neshkov  Date: 2005-6-24 22:46:34
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   CheckUser.java

package jinghua;

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

// Referenced classes of package jinghua:
//            JinghuaConn

public class CheckUser
{

    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 = "\u8F93\u5165\u7684\u7528\u6237\u540D\u6216\u5BC6\u7801\u4E0D\u6B63\u786E";
            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 = "\u6570\u636E\u5E93\u67E5\u8BE2\u51FA\u9519" + 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;
    }

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