dbcon.java~10~

来自「JAVA编写的登陆窗体」· JAVA~10~ 代码 · 共 63 行

package loginexample;

import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DBCON {
    public DBCON() {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }

    public boolean selectuser(String name, String pass) //name=str=jTextField1.getText.trim()
    //pass=strpass=jPasswordFeild.getPassword();
    {
        String url =
                "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=bb1";
        Connection con = null; //用来连接数据库
        PreparedStatement ps = null; //用来执行sql语句

        try {
            con = DriverManager.getConnection(url, "sa", "");
            ps = con.prepareStatement(
                    "select * from userinfo where username=? and userpass=?");
//            ps.setString(1,jTextField.getText.trim());
            //          ps.setString(2,"123");
            ps.setString(1, name);
            ps.setString(2, pass);
            ResultSet rs=ps.executeQuery();//执行sql中的select语句的
            if(rs.next())
            {
               return true;
            }
            //select语句的结果类型是===〉记录集==〉ResultSet
        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {

        }

        return false;
    }
    public static void main(String args[])
    {
        DBCON db=new DBCON();
        db.selectuser("aa","123");
    }

}