logindata.java~2~

来自「里面所含源码是本人平时做程序的一些实例」· JAVA~2~ 代码 · 共 43 行

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();
            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);
        }catch(Exception e){
            e.printStackTrace();
            return -1;
          }finally{
              try{
                  conn.close();
              }
              catch(Exception e){}
          }
    }
    public LoginData() {
    }
}