logindata.java

里面所含源码是本人平时做程序的一些实例

package data;
import java.sql.*;
public class LoginData {
    //取得数据库连接
    Connection conn=null;
   public Connection setupConn(){
        try{
                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=人事管理系统";
                conn=DriverManager.getConnection(url,"sa","");
                System.out.println("数据库注册成功!");
        }
        catch(Exception e){
            e.printStackTrace();
            System.out.println(" 用户驱动错误!");
        }
        return conn;
    }
    public boolean checkUser(String name,String password){
        //取得数据库连接
            conn=setupConn();
            //创建查询的ProparedStatement类
            String sql="select * from sysuser where user_id=? and user_pwd=?";
            try{
                PreparedStatement ps = conn.prepareStatement(sql);
                ResultSet rs;
                ps.setString(1, name);
                ps.setString(2, password);
                //执行查询操作
                rs=ps.executeQuery();
                if(rs.next()){
                    return true;
                }
            }
            catch(Exception e){e.printStackTrace();}
           return false;
    }

  }