java编写的图书管理系统源代码

/用户登陆数据库代码：

importjava.sql.*;

classDatabase{

Connectioncon;

ResultSetrs;

Statementstmt;

publicDatabase(){

try{

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

//加载JDBC-ODBC桥驱动程序

Stringurl=\"jdbcdbc:HDB\";

con=DriverManager.getConnection(url);

//连接数据库HDB//stmt提供一个创建SQL查询、执行查询、得到返回结果的空间stmt=

//con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

//ResultSet.CONCUR_READ_ONLY);

}catch(Exceptionex){

System.out.println(ex);

}

}

/*根据用户名，获取密码*/

publicStringgetPswd(Stringname){

try{

//rs为执行SQL语句所查询的结果赋给结果集对象rs

rs=stmt.executeQuery(\"SELECTpswdFROMUserWHEREName='\"

+name+\"'\");

rs.last();

//把rs的指针移到最后一行

if(rs.getRow()==0){

returnnull;

}else{

StringpswdDB=rs.getString(\"Pswd\");

//获取rs结果集中的pswd列的数据

returnpswdDB;

}

}catch(Exceptione){

System.out.println(e);

returnnull;

}

}

/*增加一行用户名、密码数据*/

publicbooleaninsertData(Stringname,Stringpswd){

try{

Strings=getPswd(name);

if(s==null){

intrtn=stmt.executeUpdate(\"INSERTINTOUserVALUES('\"+name

+\"','\"+pswd+\"')\");

if(rtn!=0)

returntrue;

}else{

returnfalse;

}

returnfalse;

}catch(Exceptionet){

System.out.println(et);

returnfalse;

}

}

}

//进库数据库代码：

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.ResultSet;

importjava.sql.Statement;

classBookDatabase{

Connectioncon;

ResultSetrs;

Statementstmt;

publicBookDatabase(){

try{

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

//加载JDBC-ODBC桥驱动程序

Stringurl=\"jdbcdbc:Book\";

con=DriverManager.getConnection(url);

//连接数据库HDB//stmt提供一个创建SQL查询、执行查询、得到返回结果的空间

stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_READ_ONLY);

}catch(Exceptionex){

System.out.println(ex);

}

}

/*增加一行用户名、密码数据*/

publicbooleaninsertData(Stringid,Stringname,Stringwhere,String

price,Stringdate){

try{

intrtn=stmt.executeUpdate(\"INSERTINTOBookVALUES('\"+id

+\"','\"

+name+\"','\"+where+\"','\"+price+\"','\"+date

+\"')\");

if(rtn!=0){

returntrue;

}else{

returnfalse;

}

}catch(Exceptionet){

System.out.println(et);

returnfalse;

}

}

/*

*publicbooleandeleteData(Stringid){try{intrtn=

*stmt.executeUpdate(\"DELETEFROMBookWHEREid=001\");if(rtn!=0){

*returntrue;}else{returnfalse;}}catch(Exceptione){

*System.out.println(e);returnfalse;}}publicbooleanSelect(String

*id){try{intrtn=stmt.executeUpdate(\"SELECT*FROMBookInWHERE

*id='\"+id+\"'\");

*

*if(rtn!=0){returntrue;}else{returnfalse;}}catch(Exception

*e){System.out.println(e);returnfalse;}}

*/

}

//出库数据库代码：

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.ResultSet;

importjava.sql.Statement;

classBookDatabase1{

Connectioncon;

ResultSetrs;

Statementstmt;

publicBookDatabase1(){

try{

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

//加载JDBC-ODBC桥驱动程序

Stringurl=\"jdbcdbc:Book\";

con=DriverManager.getConnection(url);

//连接数据库HDB//stmt提供一个创建SQL查询、执行查询、得到返回结果的空间

stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_READ_ONLY);

}catch(Exceptionex){

System.out.println(ex);

}

}

/*

*增加一行用户名、密码数据publicbooleaninsertData(Stringid,Stringname,String

*where,String

*

*price,Stringdate){try{intrtn=stmt.executeUpdate(\"INSERTINTO

*BookInVALUES('\"+id+

*

*\"','\"+name+\"','\"+where+\"','\"+price+\"','\"+date+\"')\");

*

*if(rtn!=0){returntrue;}else{returnfalse;}}catch(Exception

*et){System.out.println(et);returnfalse;}}

*/

publicbooleandeleteData(Stringid){

try{

intrtn=stmt.executeUpdate

(\"DELETEFROMBookWHEREid='\"+id+\"'\");

if(rtn!=0){

returntrue;

}else{

returnfalse;

}

}

catch(Exceptione){

System.out.println(e);

returnfalse;

}

}

/*

*publicbooleanSelect(Stringid){try{intrtn=

*stmt.executeUpdate(\"SELECT*FROMBookInWHEREid='\"+id+\"'\");if(rtn!=

*0){returntrue;}else{returnfalse;}}catch(Exceptione){

*System.out.println(e);returnfalse;}}

*/

}

//查询数据库代码;

importjava.awt.*;

importjava.awt.event.*;

importjava.sql.*;

importjavax.swing.*;

classBookDatabase2extendsJFrame{

String

number,name,address,prices,day;

Connectioncon;

Statementstmt=null;

ResultSetresult=null;

Stringsql=null;

publicBookDatabase2(){

try{

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

//加载JDBC-ODBC桥驱动程序

Stringurl=\"jdbc:odbc:Book\";

con=DriverManager.getConnection(url);

//连接数据库HDB//stmt提供一个创建SQL查询、执行查询、得到返回结果的空间

stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,

ResultSet.CONCUR_READ_ONLY);

}catch(Exceptionex){

System.out.println(ex);

}

}

publicvoidselect(Stringid){

try{

sql=\"SELECT*FROMBookwhereid='\"+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\提

示\

}

catch(Exceptione){

System.out.println(e);

}

}