//用户登陆数据库代码:
import java.sql.*;
class Database {
Connection con;
ResultSet rs;
Statement stmt;
public Database() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 加载JDBC-ODBC桥驱动程序
String url = "jdbcdbc:HDB";
con = DriverManager.getConnection(url);
// 连接数据库HDB //stmt提供一个创建SQL查询、执行查询、得到返回结果的空间 stmt =
// con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
// ResultSet.CONCUR_READ_ONLY);
} catch (Exception ex) {
System.out.println(ex);
}
}
/* 根据用户名,获取密码 */
public String getPswd(String name) {
try {
// rs为执行SQL语句所查询的结果赋给结果集对象rs
rs = stmt.executeQuery("SELECT pswd FROM User WHERE Name = '"
+ name + "'");
rs.last();
// 把rs的指针移到最后一行
if (rs.getRow() == 0) {
return null;
} else {
String pswdDB = rs.getString("Pswd");
// 获取rs结果集中的pswd列的数据
return pswdDB;
}
} catch (Exception e) {
System.out.println(e);
return null;
}
}
/* 增加一行用户名、密码数据 */
public boolean insertData(String name, String pswd) {
try {
String s = getPswd(name);
if (s == null) {
int rtn = stmt.executeUpdate("INSERT INTO User VALUES('" + name
+ "','" + pswd + "')");
if (rtn != 0)
return true;
} else {
return false;
}
return false;
} catch (Exception et) {
System.out.println(et);