loginaction.java~16~

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

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;//登录成功
                }
            }
        } catch (SQLException ex) {
        }

    }

}