package data;
import java.sql.*;

public class LoginData {
    public Connection setupConn(){
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=loginC1";
            Connection conn=DriverManager.getConnection(url,"sa","");
            System.out.println("數據庫驅動程序注冊成功");
            return conn;
        }catch(Exception e){
            e.printStackTrace();
            System.out.println("數據庫驅動程序出錯!");
            return null;
        }
    }
    public int checkUser(String name,String password,int state){
        Connection conn=null;
        try{
            //取得數據庫連接
            conn=setupConn();
            //創建查詢的ProparedStatement類
            String sql="select * from loginUser where name=? and password=? "+"and state=?";
            PreparedStatement ps=conn.prepareStatement(sql);
            //創建數據集
            ResultSet rs;
            ps.setString(1,name);
            ps.setString(2,password);
            ps.setInt(3,state);
            //執行查詢操作
            rs=ps.executeQuery();
            if(rs.next()){
                String nameData=rs.getString(2);
                String passwordData=rs.getString(3);
                //檢查用戶名和密碼大小寫
                if((name.compareTo(nameData)==0) && (password.compareTo(passwordData)==0)){
                    return state;
                }else{
                    return -1;
                }
           }else{
                return -1;

            }
        }catch(Exception e){
            e.printStackTrace();
            return -1;
          }finally{
              try{
                  conn.close();
              }
              catch(Exception e){}
          }
    }
    public LoginData() {
    }
}