java图
书
关于书的成语关于读书的排比句社区图书漂流公约怎么写关于读书的小报汉书pdf
管理系统代码[修订]
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 + "'");
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);
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 ) ;
}
}
}