JAVA
课程设计
报告
软件系统测试报告下载sgs报告如何下载关于路面塌陷情况报告535n,sgs报告怎么下载竣工报告下载
(图书管理系统)
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:\\workspace\\bookmis.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:\\workspace\\bookmis.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:\\workspace\\bookmis.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:\\workspace\\bookmis.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:\\workspace\\bookmis.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:\\workspace\\bookmis.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:\\workspace\\bookmis.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();
try{
rs = 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("\n\n\n\n");
}
}catch(Exception e){
}
}
public void delete() {
try{result=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);
}
else
{
jLabel.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("借阅成功");
}
else
{
jLabel.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,78"
private 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,74"
private 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,93"
private 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.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabel3 = new JLabel();
jLabel3.setBounds(new Rectangle(16, 164, 181, 31));
jLabel3.setText("请输入要插入书的出版社:");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(15, 120, 182, 31));
jLabel2.setText("请输入要插入书的作者:");
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(16, 77, 182, 29));
jLabel1.setText("请输入要插入书的编号:");
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(17, 32, 181, 29));
jLabel.setText("请输入要插入书的书名:");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.add(jLabel, null);
jContentPane.add(jLabel1, null);
jContentPane.add(jLabel2, null);
jContentPane.add(jLabel3, null);
jContentPane.add(getJTextField(), null);
jContentPane.add(getJTextField1(), null);
jContentPane.add(getJTextField2(), null);
jContentPane.add(getJTextField3(), null);
jContentPane.add(getJButton(), null);
jContentPane.add(getJButton1(), null);
jContentPane.add(getJTextField4(), null);
jContentPane.add(getJButton2(), null);
}
return jContentPane;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(239, 30, 151, 29));
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
jTextField1 = new JTextField();
jTextField1.setBounds(new Rectangle(240, 75, 153, 29));
}
return jTextField1;
}
/**
* This method initializes jTextField2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField2() {
if (jTextField2 == null) {
jTextField2 = new JTextField();
jTextField2.setBounds(new Rectangle(241, 120, 153, 29));
}
return jTextField2;
}
/**
* This method initializes jTextField3
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField3() {
if (jTextField3 == null) {
jTextField3 = new JTextField();
jTextField3.setBounds(new Rectangle(240, 166, 155, 28));
}
return jTextField3;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(219, 222, 84, 27));
jButton.setText("重置");
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
jTextField.setText("");
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
}
});
}
return jButton;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.