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

精品文档
/用户登陆数据库代码：
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","提

示",JOptionPane.ERROR_MESSAGE);
}
catch(Exceptione){
System.out.println(e);
}
}
可修改