login.java~10~

来自「一个银行数据中心网站」· JAVA~10~ 代码 · 共 98 行

package com.am;

import java.util.*;
import java.sql.*;
import java.text.*;

public class login extends user {


    private String strSql;
    private Connection dbConn;
    private int errNum;
    private String errDesc;
    SimpleDateFormat dateFormatter;
    public login() {
        super();
        strSql = "";
        errNum = 0;
        errDesc = "";

    }

    public boolean isValidUser() {
        strSql = "select * from 'users' ";
        strSql = strSql + " where userName='" + userName + "'";
       strSql = strSql + " and userPassword='" + userPassword + "'";
        strSql = strSql + " and systemRole= '" + systemRole + "'";
        Statement stmt = null;
        ResultSet rs = null;
        System.out.println("application begin");
        try {
            if(dbConn==null) System.out.println("con is null");
            stmt = dbConn.createStatement();
            if(stmt==null) System.out.println("st is null");
            rs = stmt.executeQuery(strSql);
            if(rs==null) System.out.println("rs is null");
            if (rs.next()) {
                ID = rs.getLong("ID");
                userName = rs.getString("userName");
                userPassword = rs.getString("userPassword");
                name = rs.getString("name");
                company = rs.getString("company");
                depart = rs.getString("depart");
                email = rs.getString("email");
                myfields = rs.getString("myfields");
                systemRole = rs.getString("systemRole");
                createDatetime = rs.getString("createDatetime");
                tag = rs.getInt("tag");

                this.errNum = 0;
                this.errDesc = "";
                return true;
            } else {
                this.errNum = -1;
                this.errDesc = "Not Valid User";
                return false;

            }

        } catch (Exception ex) {
            this.errNum = -1;
            this.errDesc = ex.toString();
            System.out.println("exception");
            return false;

        } finally {

        }

    }

    public void setConnection(Connection dbConn) {
        this.dbConn = dbConn;
    }

    private void exeSql(String strSql) {
        try {
            Statement stmt = dbConn.createStatement();
            stmt.executeUpdate(strSql);
            this.errNum = 0;
            this.errDesc = "";
        } catch (Exception ex) {
            this.errNum = -1;
            this.errDesc = ex.toString();

        }
    }

    public int getErrNum() {
        return errNum;

    }

    public String getErrDesc() {
        return errDesc;
    }
}