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("數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序注冊(cè)成功");
            return conn;
        }catch(Exception e){
            e.printStackTrace();
            return null;
        }
    }
    public int checkUser(String name,String password,int state){
        Connection conn=null;
        try{
            //取得數(shù)據(jù)庫(kù)連接
            conn=setupConn();
            //創(chuàng)建查詢(xún)的ProparedStatement類(lèi)
            String sql="select * from loginUser where name=? and password=? "+"and state=?";
            PreparedStatement ps=conn.prepareStatement(sql);
            //創(chuàng)建數(shù)據(jù)集
            ResultSet rs;
            ps.setString(1,name);
            ps.setString(2,password);
            ps.setInt(3,state);
        }catch(Exception e){
            e.printStackTrace();
            return -1;
          }finally{
              try{
                  conn.close();
              }
              catch(Exception e){}
          }
    }
    public LoginData() {
    }
}