java图书管理系统代码

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