java图书管理系统代码

//用户登陆数据库代码：
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 + "'");
st();
// 把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);
return false;
}
}
}
//进库数据库代码：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

class BookDatabase {
Connection con;

ResultSet rs;

Statement stmt;

public BookDatabase() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 加载JDBC-ODBC桥驱动程序
String url = "jdbcdbc:Book";
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 boolean insertData(String id, String name, String where, String

price, String date) {
try {
int rtn = stmt.executeUpdate("INSERT INTO Book VALUES('" + id
+ "','"

+ name + "','" + where + "','" + price + "','" + date
+ "')");
if (rtn != 0) {
return true;
} else {
return false;
}
} catch (Exception et) {
System.out.println(et);
return false;
}
}
/*
* public boolean deleteData(String id){ try{ int rtn =
* stmt.executeUpdate("DELETE FROM Book WHERE id=001" ); if( rtn != 0 ){
* return true; } else{ return false; } } 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 != 0 ){ return true; } else{ return false; } } catch(Exception
* e){ System.out.println( e ) ; return false; } }
*/
}
//出库数据库代码：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

class BookDatabase1 {
Connection con;

ResultSet rs;

Statement stmt;

public BookDatabase1() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 加载JDBC-ODBC桥驱动程序
String url = "jdbcdbc:Book";
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 boolean insertData(String id,String name,String
* 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
* et ) { System.out.println( et ) ; return false; } }
*/
public boolean deleteData(String id) {
try {
int rtn = stmt.executeUpdate

("DELETE FROM Book WHERE id='" + id + "'");
if (rtn != 0) {
return true;
} else {
return false;
}
}

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 !=
* 0 ){ return true; } else{ return false; } } catch(Exception e){
* System.out.println( e ) ; return false; } }
*/
}
//查询数据库代码;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

class BookDatabase2 extends JFrame {
String

number, name, address, prices, day;

Connection con;

Statement stmt = null;

ResultSet result = null;

String sql = null;

public BookDatabase2() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 加载JDBC-ODBC桥驱动程序
String url = "jdbc:odbc:Book";
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 void select(String id){
try{
sql = "SELECT * FROM Book where id='"+id+"'" ; result

=stmt.executeQuery(sql) ;
while(result.next()) {
number = result.getString(1) ;
name = result.getString(2

) ;
address = result.getString(3) ;
prices = result.getString(4) ;
day = result.getString(4) ;
}
JOptionPane.showMessageDialog(BookDatabase2.this,"成功查询图书!\n"+"图

书ID:"+number+"\n"+"图书名称:"+name+"\n" +"出版社"+address+"\n"+"价

格:"+prices+"\n"+"出版日期:"+day+"\n","提

示",JOptionPane.ERROR_MESSAGE);
}
catch(Exception e){
System.out.println( e ) ;
}
}
}