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

《最新JAVA课程设计(基于UI的图书管理系统).doc》由会员分享，可在线阅读，更多相关《最新JAVA课程设计(基于UI的图书管理系统).doc（202页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Four short words sum up what has lifted most successful individuals above the crowd: a little bit more.-author-dateJAVA课程设计(基于UI的图书管理系统)JAVA课程设计(基于UI的图书管理系统)JAVA课程设计报告（图书管理系统）1. 系统目的与功能（1）本系统通链接ACCESS完成对用户信息和图书信息的管理，并制作可视化界面进行操作。（2）系统主要实现的功能有用户的登陆，图书的插入、修改、删除、查看、借阅、归还。2. 开发工具开发工具使用Eclipse作为主用开发环境，并使

2、用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;impo

3、rt 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;JTe

4、xtField 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 = D

5、riverManager.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

6、.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 jlabe

7、l) 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 = co

8、nn.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 A

9、ccess(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

10、) 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.c

11、reateStatement(); 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 =

12、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.getJF

13、rame(); 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 块

14、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

15、 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=书名: +bookna

16、me+ 编号: +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(删除成功);el

17、se 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

18、 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(s

19、elect * 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

20、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 j

21、avax.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;

22、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 Dimensio

23、n(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 Recta

24、ngle(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);jCon

25、tentPane.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();j

26、TextField.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.addAction

27、Listener(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 i

28、nitializes 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.aw

29、t.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 JPassword

30、Field();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;i

31、mport 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

32、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 = ne

33、w 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(n

34、ull);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 initialize

35、s 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(相关操作提示;);jPanel

36、1 = 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

37、();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 in

38、itializes 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

39、.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(f