package data;
import java.sql.*;
public class LoginData {
    //取得數據庫連接
    Connection conn=null;
   public Connection setupConn(){
        try{
                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=人事管理系統";
                conn=DriverManager.getConnection(url,"sa","");
                System.out.println("數據庫注冊成功!");
        }
        catch(Exception e){
            e.printStackTrace();
            System.out.println(" 用戶驅動錯誤!");
        }
        return conn;
    }
    public boolean checkUser(String name,String password){
        //取得數據庫連接
            conn=setupConn();
            //創建查詢的ProparedStatement類
            String sql="select * from loginUser where user_id=? and user_pwd=? "+"and state=?";
            PreparedStatement ps=conn.prepareStatement(sql);
            //創建數據集
            ResultSet rs;
            ps.setString(1,name);
            ps.setString(2,password);

        Boolean t;

        return t;
    }

  }