loginaction.java~14~

java(Swing) access做的成绩管理系统

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

        } catch (SQLException ex) {
        }

    }

}