62,612
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//整理了一下,主要是没必要的多了,加了个trim(),加了个close()方法
public class IdPass {
//登陆界面核ID和密码:
public int init(String a,String b) { //a,b 是传入的 id 和 password参数
Connection con = null;
Statement sta = null;
ResultSet rs = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //加载驱动
System.out.println("driver is oK");
con = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://LENOVO-320EB584:1433;DatabaseName=stock",
"sa", "123");
sta = con.createStatement();
rs = sta.executeQuery("select *from holder_login"); //executeQuery
while (rs.next()) {
String user= rs.getString("ID").toString().trim();
String pwd=rs.getString("密码").toString().trim();
if(user.equals(a.trim()) && pwd.equals(b.trim())) return 1;
}
}
catch (Exception e) {
try {
rs.close();
sta.close();
con.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
try {
rs.close();
sta.close();
con.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
return 0;
}
public static void main(String[] args) {
IdPass is_password = new IdPass();
if(is_password.init("id","pass") == 0) {
System.out.println("ok");
}else {
System.out.println("error");
}
}
}