java课程设计图书馆管理系统

1、.广西外国语学院信息工程学院 面向对象java程序设计 实验报告班级网络工程1301姓名李亮锋学号日期实验地点实验名称广外图书馆管理系统一. 实验目的1、掌握java图形用户设计swing常用组件。2、掌握sql server 2005数据库、数据表的创建与使用。3、掌握事件的监听机制。4、熟悉使用sql语言操作数据库，如增加、删除、查询和修改等。5、熟悉应用程序的开发流程。6、程序的打包与安装。7、锻炼学生的逻辑思维。实验设备（仪器、材料、软件等）硬件：计算机软件：jdk、eclipse精品.三、实验内容本系统将会涉及到图书馆日常管理工作的基本常见细节，诸如新图书的入库登记，图书馆所有书籍的

2、分类管理，图书的查询，图书的借阅、退还手续的登记，费旧图书的清理撤除等，本系统所要实现的这些功能基本上涵盖了图书馆的日常管理工作，基本能够满足校园图书馆的工作人员的管理需要。在对本系统的具体开发过程当中，将采用java语言进行开发，以sqlserver实现后台数据库，本系统是完全基于图形化用户界面(gui)的单机版本。四、实验步骤请参见教材第20章综合案例快递打印系统格式来书写，要求有界面和核心代码。图书馆管理系统要有的信息：用户登录（注册），新图书入库，图书信息查询，图书更新（修改），旧图书删除，办理借阅证登记，图书借阅管理，软件说明及关于作者等。以下是示例，每个同学可以有自己的功能设计和数

3、据库设计。系统的功能结构精品.图书入库对应数据库学生信息表对应数据库精品.用户信息表对应数据库精品.（一）图书菜单主菜单源代码如下：package book;import java.awt.container;import java.awt.event.actionevent;import java.awt.event.actionlistener;import javax.swing.abstractaction;import javax.swing.icon;import javax.swing.imageicon;import javax.swing.jframe;import java

4、x.swing.jlabel;import javax.swing.jmenu;import javax.swing.jmenubar;import javax.swing.jmenuitem;import javax.swing.jpanel;import llf.frane.login;import booksystem.bookdelete;import booksystem.bookquery;import booksystem.bookupdate;import booksystem.dengji;public class mainframe extends jframejmenub

5、ar menubar=null;jmenu jm=null;jpanel jp;/图片icon icon;/图片jlabel jl;/图片public mainframe()精品.setsize(558,370);settitle(广外图书管理系统);setjmenubar(getjmenubar1();setlocationrelativeto(null);setresizable(false); private jmenubar getjmenubar1() / todo auto-generated method stubif(menubar=null)menubar=new jmenu

6、bar();jmenu jm1=new jmenu(菜单);jmenu jm2=new jmenu(选项);jmenu jm3=new jmenu(帮助);menubar.add(jm1);menubar.add(jm2);menubar.add(jm3);jmenuitem bookinsert=new jmenuitem(新图书入库);jmenuitem bookquery=new jmenuitem(图书信息查询);jmenuitem bookupdate=new jmenuitem(图书更新);jmenuitem bookdelete=new jmenuitem(旧图书删除); jme

7、nuitem bookexit=new jmenuitem(退出系统); jmenuitem dengji=new jmenuitem(办理借阅证登记); jmenuitem manage=new jmenuitem(图书借阅管理); jmenuitem denglu=new jmenuitem(用户登陆); jmenuitem introduce=new jmenuitem(软件说明); jmenuitem author =new jmenuitem(关于作者); jm1.add(bookinsert); jm1.add(bookquery); jm1.add(bookupdate); jm

8、1.add(bookdelete);jm1.add(bookexit);jm2.add(dengji);jm2.add(manage);jm2.add(denglu);jm3.add(introduce);jm3.add(author);jpanel jp=new jpanel();/图片icon iocn=new imageicon(c:/users/administrator/desktop/李亮锋135502113/tushuguan.jpg);jlabel jl=new jlabel(iocn);/图片jp.add(jl);/图片this.add(jp);/图片精品.bookinser

9、t.addactionlistener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stubbookinsert bi=new bookinsert();bi.setdefaultcloseoperation(jframe.dispose_on_close);bi.setvisible(true););bookquery.addactionlistener(new actionlistener() public void actionperform

10、ed(actionevent arg0) / todo auto-generated method stubbookquery bq=new bookquery();bq.setdefaultcloseoperation(jframe.dispose_on_close);bq.setvisible(true););bookupdate.addactionlistener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stubbookupdate bu

11、=new bookupdate();bu.setdefaultcloseoperation(jframe.dispose_on_close);bu.setvisible(true););bookdelete.addactionlistener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stubbookdelete bd=new bookdelete();bd.setdefaultcloseoperation(jframe.dispose_on_c

12、lose);bd.setvisible(true););bookexit.addactionlistener(new actionlistener() /退出public void actionperformed(actionevent arg0) / todo auto-generated method stubsystem.exit(1););dengji.addactionlistener(new actionlistener() /办理借阅证登记public void actionperformed(actionevent arg0) / todo auto-generated met

13、hod stubdengji dj=new dengji();精品.dj.setdefaultcloseoperation(jframe.dispose_on_close);dj.setvisible(true););introduce.addactionlistener(new actionlistener() /软件说明public void actionperformed(actionevent arg0) / todo auto-generated method stubintroduce id=new introduce();id.setdefaultcloseoperation(j

14、frame.dispose_on_close);id.setvisible(true););manage.addactionlistener(new actionlistener() /图书借阅管理public void actionperformed(actionevent arg0) / todo auto-generated method stubmanage ma=new manage();ma.setdefaultcloseoperation(jframe.dispose_on_close);ma.setvisible(true););denglu.addactionlistener

15、(new actionlistener() /登陆public void actionperformed(actionevent arg0) / todo auto-generated method stublogin lg=new login();lg.setdefaultcloseoperation(jframe.dispose_on_close);lg.setvisible(true););author.addactionlistener(new actionlistener() /关于作者public void actionperformed(actionevent arg0) / t

16、odo auto-generated method stubauthor at=new author();at.setdefaultcloseoperation(jframe.dispose_on_close);at.setvisible(true););return menubar;精品.public static void main(string args) / todo auto-generated method stubmainframe mf=new mainframe();mf.setvisible(true);mf.setdefaultcloseoperation(jframe.

17、exit_on_close);（二）登录界面登陆界面源代码如下：package llf.frane;import java.awt.component;import java.awt.font;import java.awt.gridlayout;import java.awt.event.actionevent;import java.awt.event.actionlistener;import javax.swing.jbutton;import javax.swing.jframe;精品.import javax.swing.jlabel;import javax.swing.jpan

18、el;import javax.swing.jpasswordfield;import javax.swing.jtextfield;public class login extends jframejpanel jp1,jp2,jp3,jp4;jlabel jl1,jl2,jl3;jtextfield tf;jpasswordfield pf;jbutton b1,b2,b3;public login()jl1=new jlabel(广外图书馆);jl1.setfont(new font(隶书,font.bold,40);jl2=new jlabel(账户：);jl3=new jlabel(

19、密码：);b1=new jbutton(登陆);b2=new jbutton(取消);b3=new jbutton(重置);tf=new jtextfield(15);pf=new jpasswordfield(15);jp1=new jpanel();jp2=new jpanel();jp3=new jpanel();jp4=new jpanel();setlayout(new gridlayout(4,1);jp1.add(jl1);jp2.add(jl2);jp2.add(tf);jp3.add(jl3);jp3.add(pf);jp4.add(b1);jp4.add(b2);jp4.a

20、dd(b3);this.add(jp1);this.add(jp2);this.add(jp3);this.add(jp4);settitle(用户登陆);setsize(500,400);setlocationrelativeto(null);精品.setdefaultcloseoperation(jframe.exit_on_close);setvisible(true);b2.addactionlistener(new actionlistener() public void actionperformed(actionevent e) / todo auto-generated met

21、hod stubsystem.exit(1););b3.addactionlistener(new actionlistener()public void actionperformed(actionevent arg0) / todo auto-generated method stubtf.settext();pf.settext(););public static void main(string args) login lg=new login();（三）新图书入库精品.新图书入库源代码package book;import java.awt.gridlayout;import jav

22、a.awt.headlessexception;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.sql.connection;import java.sql.preparedstatement;import java.sql.sqlexception;import javax.swing.abstractbutton;import javax.swing.jbutton;import javax.swing.jframe;import javax.swing.jlabel;im

23、port javax.swing.joptionpane;import javax.swing.jpanel;import javax.swing.jtextfield;import llf.frane.dao;public class bookinsert extends jframe 精品.jlabel jl1,jl2,jl3,jl4,jl5;jtextfield jt1,jt2,jt3,jt4,jt5;jbutton jb1,jb2;jpanel jp1,jp2,jp3,jp4,jp5,jp6;public bookinsert()setsize(400,300);settitle(新图

24、书入库);setlocationrelativeto(null);setdefaultcloseoperation(jframe.exit_on_close);setvisible(true);setlayout(new gridlayout(6,1);jp1=new jpanel();jp2=new jpanel();jp3=new jpanel();jp4=new jpanel();jp5=new jpanel();jp6=new jpanel();jl1=new jlabel(图书编号);jl2=new jlabel(图书名称);jl3=new jlabel(出版日期);jl4=new

25、jlabel(出版社名称);jl5=new jlabel(图书总数);jt1=new jtextfield(15);jt2=new jtextfield(15);jt3=new jtextfield(15);jt4=new jtextfield(15);jt5=new jtextfield(15);jb1=new jbutton(入库);jb2=new jbutton(重置);jp1.add(jl1);jp1.add(jt1);jp2.add(jl2);jp2.add(jt2);jp3.add(jl3);jp3.add(jt3);jp4.add(jl4);jp4.add(jt4);jp5.ad

26、d(jl5);jp5.add(jt5);jp6.add(jb1);jp6.add(jb2);精品.this.add(jp1);this.add(jp2);this.add(jp3);this.add(jp4);this.add(jp5);this.add(jp6);jb1.addactionlistener(new actionlistener() public void actionperformed(actionevent e) /system.exit(1);string sname=jt1.gettext().trim();string sno=jt2.gettext().trim()

27、;string sriqi=jt3.gettext().trim();string schubanshe=jt4.gettext().trim();string szongshu=jt5.gettext().trim();string sex;try if(sname.equals()|sno.equals()|sriqi.equals()|schubanshe.equals()|szongshu.equals()joptionpane.showmessagedialog(null,请输入完整信息);elseconnection conn=null;preparedstatement ps=n

28、ull;conn=dao.getconn();ps=conn.preparestatement(insert into inputbook values (+sname+,+sno+,+sriqi+,+schubanshe+,+szongshu+);int i=ps.executeupdate();if(i=1)joptionpane.showmessagedialog(null,入库成功);elsejoptionpane.showmessagedialog(null,入库失败); catch (headlessexception e1) / todo auto-generated catch

29、 blocke1.printstacktrace(); catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace();精品.);jb2.addactionlistener(new actionlistener()public void actionperformed(actionevent arg0) / todo auto-generated method stubjt1.settext();jt2.settext();jt3.settext();jt4.settext();jt5.settext(

30、););public static void main(string args) / todo auto-generated method stubbookinsert b=new bookinsert();b.setvisible(true);b.setresizable(false);（四）图书信息查询图书信息查询源代码如下：package booksystem;import java.awt.gridlayout;import java.awt.headlessexception;精品.import java.awt.event.actionevent;import java.awt.e

31、vent.actionlistener;import java.sql.connection;import java.sql.preparedstatement;import java.sql.resultset;import java.sql.sqlexception;import javax.swing.jbutton;import javax.swing.jframe;import javax.swing.jlabel;import javax.swing.joptionpane;import javax.swing.jpanel;import javax.swing.jtextfiel

32、d;import llf.frane.dao;public class bookquery extends jframe jlabel jl1,jl2,jl3,jl4;jtextfield jf1,jf2,jf3,jf4;/文本jbutton jb1;/按钮jpanel jp1,jp2,jp3,jp4;public bookquery()jl1=new jlabel(查询图书的名称：);jl2=new jlabel(图书编号：);jl3=new jlabel(入库日期);jl4=new jlabel(入库总数：);jf1=new jtextfield(15);jf2=new jtextfiel

33、d(15);jf3=new jtextfield(15);jf4=new jtextfield(15);jb1=new jbutton(查询);jp1=new jpanel();jp2=new jpanel();jp3=new jpanel();jp4=new jpanel();this.setlayout(new gridlayout(4, 1);jp1.add(jl1);jp1.add(jf1);jp1.add(jb1);精品.jp2.add(jl2);jp2.add(jf2);jp3.add(jl3);jp3.add(jf3);jp4.add(jl4);jp4.add(jf4);this

34、.add(jp1);this.add(jp2);this.add(jp3);this.add(jp4);settitle(图书查询);setsize(400,300);setdefaultcloseoperation(jframe.dispose_on_close);setlocationrelativeto(null);setvisible(true);jb1.addactionlistener(new actionlistener() public void actionperformed(actionevent e) / todo auto-generated method stubst

35、ring bookname=jf1.gettext().trim();connection conn=null;preparedstatement ps=null;resultset rs=null;conn=dao.getconn();try if(bookname.equals()joptionpane.showmessagedialog(null,请输入你要查询的书名);elsestring sql=select * from inputbook where bookname=+bookname+;ps=conn.preparestatement(sql);rs=ps.executequ

36、ery();if(rs.next()jf2.settext(rs.getstring(1);jf3.settext(rs.getstring(3);elsejoptionpane.showmessagedialog(null,你查询的图书不存在); catch (headlessexception e1) / todo auto-generated catch blocke1.printstacktrace();精品. catch (sqlexception e1) / todo auto-generated catch blocke1.printstacktrace(););public s

37、tatic void main(string args) / todo auto-generated method stubbookquery bc=new bookquery();（五）图书更新图书更新源代码如下：package booksystem;import java.awt.gridlayout;import java.awt.headlessexception;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.sql.connection;import java.sq

38、l.preparedstatement;import java.sql.resultset;import java.sql.sqlexception;精品.import javax.swing.jbutton;import javax.swing.jframe;import javax.swing.jlabel;import javax.swing.joptionpane;import javax.swing.jpanel;import javax.swing.jtextfield;import llf.frane.dao;public class bookupdate extends jfr

39、ame jlabel jl1,jl2,jl3,jl4,jl5;jtextfield jt1,jt2,jt3,jt4,jt5;/文本jbutton jb1,jb2;jpanel jp1,jp2,jp3,jp4,jp5,jp6;public bookupdate()jl1=new jlabel(图书名称);jl2=new jlabel(图书编号);jl3=new jlabel(入库日期);jl4=new jlabel(入库日期);jl5=new jlabel(入库总数);jt1=new jtextfield(15);jt2=new jtextfield(15);jt3=new jtextfield

40、(15);jt4=new jtextfield(15);jt5=new jtextfield(15);jb1=new jbutton(查询);jb2=new jbutton(修改);jp1=new jpanel();jp2=new jpanel();jp3=new jpanel();jp4=new jpanel();jp5=new jpanel();jp6=new jpanel();setlayout(new gridlayout(6, 1);jp1.add(jl1);jp1.add(jt1);jp2.add(jl2);jp2.add(jt2);jp3.add(jl3);jp3.add(jt3

41、);jp4.add(jl4);jp4.add(jt4);jp5.add(jl5);jp5.add(jt5);jp6.add(jb1);jp6.add(jb2);this.add(jp1);this.add(jp2);精品.this.add(jp3);this.add(jp4);this.add(jp5);this.add(jp6);settitle(图书更新);setsize(500,350);setlocationrelativeto(null);setdefaultcloseoperation(dispose_on_close);setvisible(true);jb1.addaction

42、listener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stubstring bookname=jt1.gettext().trim();connection conn=null;preparedstatement ps=null;resultset rs=null;conn=dao.getconn();try if(bookname.equals()joptionpane.showmessagedialog(null,请输入你要查询的书名)

43、;elsestring sql=select * from inputbook where bookname=+bookname+;ps=conn.preparestatement(sql);rs=ps.executequery();if(rs.next()jt2.settext(rs.getstring(1);jt3.settext(rs.getstring(3);elsejoptionpane.showmessagedialog(null,你查询的图书不存在); catch (headlessexception e1) / todo auto-generated catch blocke1

44、.printstacktrace(); catch (sqlexception e1) / todo auto-generated catch block精品.e1.printstacktrace(););jb2.addactionlistener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stub/jt1.settext();jt2.settext();jt3.settext();/jt4.settext();jt5.settext(););p

45、ublic static void main(string args) / todo auto-generated method stubbookupdate bu=new bookupdate();（六）旧图书删除旧图书删除源代码如下：package booksystem;/说明删除界面精品.import java.awt.gridlayout;import java.awt.headlessexception;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.sql.conn

46、ection;import java.sql.preparedstatement;import java.sql.sqlexception;import javax.swing.jbutton;import javax.swing.jframe;import javax.swing.jlabel;import javax.swing.joptionpane;import javax.swing.jpanel;import javax.swing.jtextfield;import llf.frane.dao;public class bookdelete extends jframejlabe

47、l jl1;jtextfield jf1;jbutton jb1,jb2;jpanel jp1,jp2,jp3;public bookdelete()jl1=new jlabel(请输入你要删除的图书名称);jf1=new jtextfield(18);jb1=new jbutton(删除);jb2=new jbutton(重置);jp1=new jpanel();jp2=new jpanel();jp3=new jpanel();setlayout(new gridlayout(3, 1);jp1.add(jl1);jp2.add(jf1);jp3.add(jb1);jp3.add(jb2)

48、;this.add(jp1);this.add(jp2);this.add(jp3);settitle(旧图书删除);setsize(400,250);setdefaultcloseoperation(jframe.dispose_on_close);setlocationrelativeto(null);setvisible(true);精品.jb1.addactionlistener(new actionlistener() public void actionperformed(actionevent arg0) / todo auto-generated method stubstring dlname=jf1.gettext().trim();try if(dlname.equals()joptionpane.showmessagedialog(null, 请输入你要删除的图书名称);elseconnection conn=null;preparedstatement ps=null;int i;conn=dao.getconn();string sql=delete * from inputbook where bookname=+dlname+;/执行sqlps=conn.preparestat