基于java的图书管理系统源代码.docx
- 文档编号:9918444
- 上传时间:2023-05-22
- 格式:DOCX
- 页数:78
- 大小:28.26KB
基于java的图书管理系统源代码.docx
《基于java的图书管理系统源代码.docx》由会员分享,可在线阅读,更多相关《基于java的图书管理系统源代码.docx(78页珍藏版)》请在冰点文库上搜索。
基于java的图书管理系统源代码
声明:
本系统是基于C/S的图书管理系统,主要使用的是Oracle数据库,下面附所有实现代码
packagelibrary;
importclassbook_addextendsJFrameimplementsActionListener{
DataBaseManagerdb=newDataBaseManager();
ResultSetrs;
JPanelpanel1,panel2;
JLabelbook_id_label,book_name_label,author_label,
press_label,press_date_label,price_label,book_num_label,borrowed_num_label,address;
JTextFieldbook_id_TextField,book_name_TextField,author_TextField,
press_TextField,press_date_TextField,price_TextField,book_num_TextField,
borrowed_count;
JComboBoxaddresst;
Containerc;
JButtonclear,add,exit;
publicbook_add()
{
super("添加图书信息");
c=getContentPane();
(newBorderLayout());
book_id_label=newJLabel("编号",;
book_name_label=newJLabel("名称",;
author_label=newJLabel("作者",;
press_label=newJLabel("出版社",;
press_date_label=newJLabel("出版日期",;
price_label=newJLabel("价格",;
book_num_label=newJLabel("库存数",;
borrowed_num_label=newJLabel("已借阅数",;
address=newJLabel("藏书地址",;
book_id_TextField=newJTextField(15);
book_name_TextField=newJTextField(15);
author_TextField=newJTextField(15);
press_TextField=newJTextField(15);
press_date_TextField=newJTextField(15);
price_TextField=newJTextField(15);
book_num_TextField=newJTextField(15);
borrowed_count=newJTextField(15);
("0");
addresst=newJComboBox();
("扬子津图书馆");
("荷花池图书馆");
("瘦西湖图书馆");
("淮海路图书馆");
panel1=newJPanel();
(newGridLayout(9,2));
(book_id_label);
(book_id_TextField);
(book_name_label);
(book_name_TextField);
(press_label);
(press_TextField);
(author_label);
(author_TextField);
(press_date_label);
(press_date_TextField);
(price_label);
(price_TextField);
(book_num_label);
(book_num_TextField);
(borrowed_num_label);
(borrowed_count);
(address);
(addresst);
panel2=newJPanel();
(newGridLayout(1,3));
clear=newJButton("清空");
(this);
add=newJButton("添加");
(this);
exit=newJButton("退出");
(this);
(clear);
(add);
(exit);
(panel1,;
(panel2,;
setVisible(true);
}
publicvoidactionPerformed(ActionEvente)
{
if()==exit)
{
();
}
elseif()==clear)
{
("");
("");
("");
("");
("");
("");
("");
}
elseif()==add)
{
if().trim().equals(""))
{
(null,"书号不能为空");
}
elseif().trim().equals(""))
{
(null,"书名不能为空");
}
elseif().trim().equals(""))
{
(null,"作者不能为空");
}
elseif().trim().equals(""))
{
(null,"出版社不能为空");
}
elseif().trim().equals(""))
{
(null,"出版日期不能为空");
}
elseif().trim().equals(""))
{
(null,"价格不能为空");
}
elseif().trim().equals(""))
{
(null,"库存不能为空");
}
elseif().trim().equals(""))
{
(null,"借阅数不能为空");
}
else{
try{
StringstrSQL="insertintobook(book_id,book_name,press,author,press_date,price,book_count,borrowed_count,store_address)values('"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+().trim()
+"','"
+()+"')";
if(strSQL))
{
();
(null,"添加图书成功");
}
else
{
(null,"添加图书失败");
();
}
();
}catch(Exceptionex)
{
}
}
}
}
}
packagelibrary;
import.*;
import.*;
importclassbook_deleteextendsJFrameimplementsActionListener{
DataBaseManagerdb=newDataBaseManager();
ResultSetrs;
Containerc;
JLabelTipLabel=newJLabel("请选择要删除的书名",;
JComboBoxbb=newJComboBox();
JButtonyes,exit;
JPanelpanel1=newJPanel();
publicbook_delete()
{
super("删除图书信息");
c=getContentPane();
(newBorderLayout());
try{
StringstrSQL="selectbook_namefrombookwherebook_count>borrowed_count";
rs=(strSQL);
while())
{
(1));
}
}catch(SQLExceptionsqle){
}catch(Exceptionex){
}
(TipLabel,;
(bb,;
yes=newJButton("确定");
exit=newJButton("退出");
(this);
(this);
(yes);
(exit);
(panel1,;
setVisible(true);
}
publicvoidactionPerformed(ActionEvente)
{
if()==exit)
{
();
}
elseif()==yes)
{
try{
StringstrSQL="selectborrowed_countfrombookwherebook_name='"
+()+"'";
rs=(strSQL);
if(!
())
{
(null,"书库里没有你要删除的书");
}
else
{
StringstrSql="deletefrombookwherebook_name='"
+()
+"'andborrowed_count=0";
();
intcount=
(1);
if(!
(count==0))
{
(null,"此书还有学生没有还,不可删除");
}
elseif(strSql))
{
(null,"删除成功");
();
();
}
else{
(null,"删除失败");
();
();
}
}
}catch(SQLExceptionsqle){
}catch(Exceptionex){
}
}
}
}
packagelibrary;
importclassbook_modifyextendsJFrameimplementsActionListener{
DataBaseManagerdb=newDataBaseManager();
ResultSetrs;
JPanelpanel1,panel2,panel3;
JLabelTipLabel=newJLabel("输入书名点确定,将调出此书的相关信息");
JLabelbook_name_label,author_label,
press_label,press_date_label,price_label;
JTextFieldbook_name_TextField,author_TextField,
press_TextField,press_date_TextField,price_TextField;
Containerc;
JButtonclear,yes,update,exit;
publicbook_modify()
{
super("修改图书信息");
c=getContentPane();
(newBorderLayout());
panel3=newJPanel();
(TipLabel);
(panel3,;
book_name_label=newJLabel("名称",;
author_label=newJLabel("作者",;
press_label=newJLabel("出版社",;
press_date_label=newJLabel("出版日期",;
price_label=newJLabel("价格",;
book_name_TextField=newJTextField(15);
author_TextField=newJTextField(15);
press_TextField=newJTextField(15);
press_date_TextField=newJTextField(15);
price_TextField=newJTextField(15);
panel1=newJPanel();
(newGridLayout(6,2));
(book_name_label);
(book_name_TextField);
(author_label);
(author_TextField);
(press_label);
(press_TextField);
(press_date_label);
(press_date_TextField);
(price_label);
(price_TextField);
panel2=newJPanel();
(newGridLayout(1,4));
clear=newJButton("清空");
yes=newJButton("确定");
update=newJButton("更新");
exit=newJButton("退出");
(clear);
(yes);
(update);
(exit);
(this);
(this);
(this);
(this);
(false);
(panel1,;
(panel2,;
setVisible(true);
}
publicvoidactionPerformed(ActionEvente)
{
if()==exit)
{
();;
}
elseif()==clear)
{
("");
("");
("");
("");
("");
}
elseif()==yes)
{
try{
StringstrSQL="select*frombookwherebook_name='"
+().trim()+"'";
rs=(strSQL);
while()){
("book_name"));
("author"));
("press"));
("press_date"));
("price"));
}
(true);
}catch(NullPointerExceptionupe){
}catch(Exceptiones){
}
}
elseif()==update)
{
try{
StringstrSQL="updatebooksetbook_name='"
+().trim()+"',press='"
+().trim()+"',author='"
+().trim()+"',press_date='"
+().trim()+"',price='"
+().trim()+"'wherebook_name='"+().trim()+"'";
if(strSQL))
{
();
(null,"更新图书成功");
}
else{
(null,"更新图书失败");
}
();
}catch(Exceptionsqle){
}
}
}
}
packagelibrary;
importclassbookborrowextendsJFrameimplementsActionListener{
DataBaseManagerdb=newDataBaseManager();
ResultSetrs;
Containerc;
JPanelpanel1,panel2;
JLabelborrowname,bookname,borrowdate,returndate,is_return_label;
JTextFieldborrowdateField,returndateField,is_return;
JButtonclear,yes,cancel;
JComboBoxborrownameBox=newJComboBox();
JComboBoxbooknameBox=newJComboBox();
publicbookborrow()
{
super("书籍出借");
c=getContentPane();
(newBorderLayout());
Calendarcal=();
intyear,month,day;
quals(""))
{
(null,"对不起,没有读者借阅");
}
elseif().equals(""))
{
(null,"对不起,现在书库没有书");
}
else{
try{
rim();
SimpleDateFormatformat=newSimpleDateFormat("yyyy-MM-dd");
DatedateStart=(startDate);
Calendarcd=();
(dateStart);
2);
StringreturnDate=());
StringstrSQL="insertintoborrow(student_name,book_name,borrow_date,return_date,is_returned)values('"
+()
+"','"
+()
+"','"
+().trim()
+"','"
+returnDate
+"','"
+().trim()
+"')";
if(strSQL)){
(null,"借阅完成");
strSQL="updatereadersetborrow_count=borrow_count+1wherestudent_name='"+()
+"'";
(strSQL);
strSQL="updatebooksetborrowed_count=borrowed_count+1wherebook_name='"+()+"'";
(strSQL);
();
();
}else{
(null,"借阅失败");
();
();
}
}catch(Exceptionse){
}
}
}
}
}
packagelibrary;
import.*;
import.*;
importclassbookborrowlistextendsJFrameimplementsActionListener{
DataBaseManagerdb=newDataBaseManager();
ResultSetrs;
Containerc;
JPanelpanel1,panel2;
JLabelbookname,studentname;
JTextFieldbooknamet,studentnamet;
JButtonsearch,exit;
JTabletable=null;
DefaultTableModeldefaultModel=null;
publicbookborrowlist()
{
super("借阅列表");
c=getContentPane();
(newBorderLayout());
bookname=newJLabel("书名",;
studentname=newJLabel("人名",;
booknamet=newJTextField(15);
studentnamet=newJTextField(15);
search=newJButton("查询");
exit=newJButton("退出");
(this);
(this);
Boxbox1=();
(studentna
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 基于 java 图书 管理 系统 源代码