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 sysuser where user_id=? and user_pwd=?";
            try{
                PreparedStatement ps = conn.prepareStatement(sql);
                ResultSet rs;
                ps.setString(1, name);
                ps.setString(2, password);
                //執行查詢操作
                rs=ps.executeQuery();
                if(rs.next()){
                    return true;
                }
            }
            catch(Exception e){e.printStackTrace();}
           return false;
    }

  }