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

        Boolean t;

        return t;
    }

  }