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

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

1、精选优质文档-倾情为你奉上JAVA课程设计报告（图书管理系统）1. 系统目的与功能（1）本系统通链接ACCESS完成对用户信息和图书信息的管理，并制作可视化界面进行操作。（2）系统主要实现的功能有用户的登陆，图书的插入、修改、删除、查看、借阅、归还。2. 开发工具开发工具使用Eclipse作为主用开发环境，并使用VE相关制作系统界面部分。3. 系统说明（以下名字都是类名）1. Access类来进行界面切换，数据库操作等。2. MainMenu、Regsdit类是系统登陆界面和用户注册界面。3. MainCl类是系统的主要界面。4. Insert、Look、Update、Delete、Sendb

2、ook、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 p

3、s = 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 = p

4、assword;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,

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

6、onnection(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.Jdbc

7、OdbcDriver);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=Micro

8、soft 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:dr

9、iver=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.JdbcOdbc

10、Driver);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.Jd

11、bcOdbcDriver);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

12、(+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

13、()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+,+boo

14、kid+,+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.getSt

15、ring(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

16、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.ex

17、ecuteUpdate(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 (SQLExcept

18、ion 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.executeUpdat

19、e(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) Main

20、Menu类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 jFr

21、ame = 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;/* * T

22、his 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 initializ

23、es 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( 用户名);jContent

24、Pane = 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

25、 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 */priv

26、ate 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();Stri

27、ng 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.setBou

28、nds(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

29、 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 M

30、ainMenu();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 JP

31、anel 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;

32、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 jFram

33、e;/* * 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(ge

34、tJButton3(), 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

35、(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)

36、;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 vo

37、id 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.setBoun

38、ds(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

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