logindata.java

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

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){}
          }
    }
    
}