loginaction.java~17~

来自「java(Swing) access做的成绩管理系统」· JAVA~17~ 代码 · 共 45 行

package edu.xscj.action;

import java.sql.*;
import edu.xscj.conn.ConnectDataBase;
import edu.xscj.bean.*;

public class LoginAction {
    /**
     * LoginAction
     */
    Connection conn = null;

    public LoginAction() {
        if (conn == null) {
            conn = ConnectDataBase.getConn();
        }
    }

    public int isAvailabe(Admin admin) {
        Statement stmt = null;
        ResultSet rst = null;
        String sql = "select * from admin where adminNo='" + admin.getAdminNo() +
                     "'";
        try {
            stmt = conn.createStatement();
            rst = stmt.executeQuery(sql);
            if (rst.next()) {
                String pwd = rst.getString("adminPwd");
                if (pwd.equals(admin.getAdminPwd())) {
                    return 1; //登录成功
                }
                else{
                    return 2;//密码错误
                }
            }
            else{
                return 3;
            }
        } catch (SQLException ex) {
        }

    }

}