JAVA课程设计(基于UI的图书管理系统).doc

java课程设计报告（图书管理系统）1. 系统目的与功能（1）本系统通链接access完成对用户信息和图书信息的管理，并制作可视化界面进行操作。（2）系统主要实现的功能有用户的登陆，图书的插入、修改、删除、查看、借阅、归还。2. 开发工具开发工具使用eclipse作为主用开发环境，并使用ve相关制作系统界面部分。3. 系统说明（以下名字都是类名）1. access类来进行界面切换，数据库操作等。2. mainmenu、regsdit类是系统登陆界面和用户注册界面。3. maincl类是系统的主要界面。4. insert、look、update、delete、sendbook、backbook类分别用来进行图书插入、图书信息查看、图书信息修改、图书删除、借阅图书、归还图书。5. 程序代码access类package access;import java.sql.*;import javax.swing.jlabel;import javax.swing.jpanel;import javax.swing.jtextfield;import view.*;public class access connection conn = null;statement stmt = null;resultset rs = null;preparedstatement ps = null;string username; string temp;string password;string bookname;string bookid;string author;string publisher;string name;int count;jtextfield test;jtextfield test1;jlabel jlabel;jpanel jpane;int result=0;public access(string username, string password) this.username = username;this.password = password;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access(string bookname,string bookid,string author,string publisher,jtextfield test) this.bookname=bookname;this.bookid=bookid;this.author=author;this.publisher=publisher;this.test=test;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access(string bookname,string bookid,string author,string publisher,jlabel jlabel) this.bookname=bookname;this.bookid=bookid;this.author=author;this.publisher=publisher;this.jlabel=jlabel;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access() try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access(string temp,jtextfield test1) this.temp=temp;this.test1=test1;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access(string aname,jpanel jpane,jlabel jlabel) name=aname;this.jpane=jpane;this.jlabel=jlabel;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public access(string aname,jlabel jlabel) name=aname;this.jlabel=jlabel;try class.forname(sun.jdbc.odbc.jdbcodbcdriver);string strurl = jdbc:odbc:driver=microsoft access driver (*.mdb);dbq=d:workspacebookmis.mdb;conn = drivermanager.getconnection(strurl);stmt = conn.createstatement(); catch (exception e) public void regsdit() try result=stmt.executeupdate(insert into userinform(username,password) values(+username+,+password+); catch (sqlexception e) / todo 自动生成 catch 块new fail().getjdialog();if (result = 1) mainmenu mainmenu = new mainmenu();mainmenu.getjframe(); else public void login() try rs=stmt.executequery(select * from userinform where username=+username+ and password=+password+);if(rs.next()maincl maincl =new maincl();maincl.getjframe();else loginfail loginfail=new loginfail();loginfail.getjdialog(); catch (sqlexception e) / todo 自动生成 catch 块e.printstacktrace();public void insert() try result=stmt.executeupdate(insert into bookmis(bookname,num,auther,publisher) values(+bookname+,+bookid+,+author+,+publisher+); catch (sqlexception e) / todo 自动生成 catch 块e.printstacktrace();if(result=1)test.settext(插入成功);else test.settext(插入失败);public void look() look alook =new look();tryrs = stmt.executequery(select * from bookmis);while (rs.next() bookname=rs.getstring(bookname);bookid=rs.getstring(num);author=rs.getstring(auther);publisher=rs.getstring(publisher);count=rs.getint(count);string acount=integer.tostring(count);string temp=书名: +bookname+ 编号: +bookid+ 作者: +author+ 出版社: +publisher+ 数量：+acount;alook.getlist().add(temp);alook.getjframe();alook.getlist().add(nnnn);catch(exception e)public void delete() tryresult=0;result=stmt.executeupdate(delete from bookmis where bookname=+temp+);catch(exception e)if(result=1)test1.settext(删除成功);else test1.settext(删除失败，你输入的书名有误);public void update() try rs = stmt.executequery(select * from bookmis where bookname=+name+);if(rs.next()stmt.executeupdate(delete from bookmis where bookname=+name+);jpane.setvisible(true);elsejlabel.settext(请输入正确的书名); catch (sqlexception e) public void aupdate() try result=stmt.executeupdate(insert into bookmis(bookname,num,auther,publisher) values(+bookname+,+bookid+,+author+,+publisher+); catch (sqlexception e) / todo 自动生成 catch 块e.printstacktrace();if(result=1)jlabel.settext(修改成功);else jlabel.settext(修改失败);public void sendbook() try rs = stmt.executequery(select * from bookmis where bookname=+name+);if(rs.next()int bcount=rs.getint(count);if(bcount=0)jlabel.settext(书已经全部借完);return;stmt.executeupdate(update bookmis set count=count-1 where bookname=+name+);jlabel.settext(借阅成功);elsejlabel.settext(没有这本书); catch (sqlexception e) e.printstacktrace();public void backbook() try stmt.executeupdate(update bookmis set count=count+1 where bookname=+name+);jlabel.settext(还书成功); catch (sqlexception e) mainmenu类package view;import javax.swing.jframe;import javax.swing.jpanel;import java.awt.dimension;import javax.swing.jlabel;import java.awt.rectangle;import javax.swing.jtextfield;import javax.swing.jbutton;import access.access;import javax.swing.jpasswordfield;public class mainmenu private jframe jframe = null; / jve:decl-index=0:visual-constraint=159,78private jpanel jcontentpane = null;private jlabel jlabel = null;private jtextfield jtextfield = null;private jlabel jlabel1 = null;private jbutton jbutton = null;private jbutton jbutton1 = null;private jpasswordfield jpasswordfield = null;/* * this method initializes jframe * * return javax.swing.jframe */public jframe getjframe() if (jframe = null) jframe = new jframe();jframe.setsize(new dimension(461, 320);jframe.settitle(图书管理系统登陆界面);jframe.setcontentpane(getjcontentpane();jframe.setvisible(true);return jframe;/* * this method initializes jcontentpane * * return javax.swing.jpanel */private jpanel getjcontentpane() if (jcontentpane = null) jlabel1 = new jlabel();jlabel1.setbounds(new rectangle(30, 121, 167, 30);jlabel1.settext( 密 码);jlabel = new jlabel();jlabel.setbounds(new rectangle(30, 45, 167, 31);jlabel.settext( 用户名);jcontentpane = new jpanel();jcontentpane.setlayout(null);jcontentpane.add(jlabel, null);jcontentpane.add(getjtextfield(), null);jcontentpane.add(jlabel1, null);jcontentpane.add(getjbutton(), null);jcontentpane.add(getjbutton1(), null);jcontentpane.add(getjpasswordfield(), null);return jcontentpane;/* * this method initializes jtextfield * * return javax.swing.jtextfield */private jtextfield getjtextfield() if (jtextfield = null) jtextfield = new jtextfield();jtextfield.setbounds(new rectangle(211, 44, 223, 35);return jtextfield;/* * this method initializes jbutton * * return javax.swing.jbutton */private jbutton getjbutton() if (jbutton = null) jbutton = new jbutton();jbutton.setbounds(new rectangle(61, 211, 121, 32);jbutton.settext(登陆);jbutton.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) string username=jtextfield.gettext();string password=jpasswordfield.gettext();access access=new access(username,password);access.login();jframe.setvisible(false););return jbutton;/* * this method initializes jbutton1 * * return javax.swing.jbutton */private jbutton getjbutton1() if (jbutton1 = null) jbutton1 = new jbutton();jbutton1.setbounds(new rectangle(269, 210, 139, 32);jbutton1.settext(注册);jbutton1.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) regsdit regsdit=new regsdit();regsdit.getjframe();jframe.setvisible(false););return jbutton1;/* * this method initializes jpasswordfield * * return javax.swing.jpasswordfield */private jpasswordfield getjpasswordfield() if (jpasswordfield = null) jpasswordfield = new jpasswordfield();jpasswordfield.setbounds(new rectangle(211, 121, 225, 29);return jpasswordfield;public static void main(string a)mainmenu mainmenu=new mainmenu();mainmenu.getjframe();maincl类package view;import javax.swing.jframe;import javax.swing.jpanel;import java.awt.dimension;import java.awt.rectangle;import javax.swing.*;import access.access;public class maincl private jframe jframe = null; / jve:decl-index=0:visual-constraint=203,74private jpanel jpanel = null;private jpanel jpanel1 = null;private jlabel jlabel6 = null;private jlabel jlabel7 = null;private jbutton jbutton = null;private jbutton jbutton1 = null;private jbutton jbutton2 = null;private jbutton jbutton3 = null;private jbutton jbutton4 = null;private jbutton jbutton5 = null;private jbutton jbutton6 = null;/* * this method initializes jframe * * return javax.swing.jframe */public jframe getjframe() if (jframe = null) jframe = new jframe();jframe.setsize(new dimension(420, 333);jframe.settitle(图书管理系统);jframe.setcontentpane(getjpanel();jframe.setvisible(true);return jframe;/* * this method initializes jpanel * * return javax.swing.jpanel */private jpanel getjpanel() if (jpanel = null) jpanel = new jpanel();jpanel.setlayout(null);jpanel.add(getjpanel1(), null);jpanel.add(getjbutton(), null);jpanel.add(getjbutton1(), null);jpanel.add(getjbutton2(), null);jpanel.add(getjbutton3(), null);jpanel.add(getjbutton4(), null);jpanel.add(getjbutton5(), null);jpanel.add(getjbutton6(), null);return jpanel;/* * this method initializes jpanel1 * * return javax.swing.jpanel */private jpanel getjpanel1() if (jpanel1 = null) jlabel7 = new jlabel();jlabel7.setbounds(new rectangle(6, 21, 376, 18);jlabel7.settext( 插入，修改，删除操作仅管理员可以操作。);jlabel6 = new jlabel();jlabel6.setbounds(new rectangle(6, 1, 382, 22);jlabel6.settext(相关操作提示;);jpanel1 = new jpanel();jpanel1.setlayout(null);jpanel1.setbounds(new rectangle(12, 211, 391, 41);jpanel1.add(jlabel6, null);jpanel1.add(jlabel7, null);return jpanel1;/* * this method initializes jbutton * * return javax.swing.jbutton */private jbutton getjbutton() if (jbutton = null) jbutton = new jbutton();jbutton.setbounds(new rectangle(15, 44, 150, 34);jbutton.settext(插入书);jbutton.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) insert insert=new insert();insert.getjframe();jframe.setvisible(false););return jbutton;/* * this method initializes jbutton1 * * return javax.swing.jbutton */private jbutton getjbutton1() if (jbutton1 = null) jbutton1 = new jbutton();jbutton1.setbounds(new rectangle(15, 105, 151, 31);jbutton1.settext(修改书);jbutton1.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) new update().getjframe();jframe.setvisible(false););return jbutton1;/* * this method initializes jbutton2 * * return javax.swing.jbutton */private jbutton getjbutton2() if (jbutton2 = null) jbutton2 = new jbutton();jbutton2.setbounds(new rectangle(16, 164, 150, 31);jbutton2.settext(删除书);jbutton2.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) new delete().getjframe();jframe.setvisible(false););return jbutton2;/* * this method initializes jbutton3 * * return javax.swing.jbutton */private jbutton getjbutton3() if (jbutton3 = null) jbutton3 = new jbutton();jbutton3.setbounds(new rectangle(211, 45, 150, 33);jbutton3.settext(查看书);jbutton3.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) access access=new access();access.look(););return jbutton3;/* * this method initializes jbutton4 * * return javax.swing.jbutton */private jbutton getjbutton4() if (jbutton4 = null) jbutton4 = new jbutton();jbutton4.setbounds(new rectangle(211, 104, 150, 35);jbutton4.settext(借阅书);jbutton4.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) new sendbook().getjframe();jframe.setvisible(false););return jbutton4;/* * this method initializes jbutton5 * * return javax.swing.jbutton */private jbutton getjbutton5() if (jbutton5 = null) jbutton5 = new jbutton();jbutton5.setbounds(new rectangle(213, 166, 149, 29);jbutton5.settext(归还书);jbutton5.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) new backbook().getjframe();jframe.setvisible(false););return jbutton5;/* * this method initializes jbutton6 * * return javax.swing.jbutton */private jbutton getjbutton6() if (jbutton6 = null) jbutton6 = new jbutton();jbutton6.setbounds(new rectangle(265, 261, 94, 27);jbutton6.settext(退出);jbutton6.addactionlistener(new java.awt.event.actionlistener() public void actionperformed(java.awt.event.actionevent e) system.exit(0););return jbutton6;insert类package view;import javax.swing.jframe;import javax.swing.jpanel;import java.awt.dimension;import javax.swing.jlabel;import java.awt.rectangle;import javax.swing.jtextfield;import javax.swing.jbutton;import access.access;public class insert private jframe jframe = null; / jve:decl-index=0:visual-constraint=203,93private jpanel jcontentpane = null;private jlabel jlabel = null;private jlabel jlabel1 = null;private jlabel jlabel2 = null;private jlabel jlabel3 = null;private jtextfield jtextfield = null;private jtextfield jtextfield1 = null;private jtextfield jtextfield2 = null;private jtextfield jtextfield3 = null;private jbutton jbutton = null;private jbutton jbutton1 = null;private jtextfield jtextfield4 = null;private jbutton jbutton2 = null;/* * this method initializes jframe * * return javax.swing.jframe */public jframe getjframe() if (jframe = null) jframe = new jframe();jframe.setsize(new dimension(418, 303);jframe.settitle(插入新书);jframe.setcontentpane(getjcontentpane();jframe.setvisible(true);return jframe;/* * this method initializes jcontentpane * * return javax.swing.j