Java版本:图书管理系统

实验目的：掌握数据库编程技术。能正确连接数据库，能对数据库中信息进行查询、插入、删除、修改。

实验内容：在数据库中创建一张书目信息表，包括书名、作者、出版社、出版日期、书号、价格字段。设计一个GUI界面进行书目管理。在该界面上有四个选项卡，分别是查询、插入、删除、修改。点击查询选项卡，出现的界面上有书名、作者、出版社、书号四个文本框，一个按钮和一个只读文本区。文本框内容可以为空，输入相应的查询信息后（例如根据书名查询可以仅输入书名），点击界面上的“查询”按钮，可以在界面下方的文本区中显示出符合条件的书目详细信息。点击插入选项卡，出现的界面上有书名、作者、出版社、出版日期、书号、价格文本框，一个按钮。在文本框中输入信息后，点击“插入”按钮，该书目信息插入数据库表中。点击删除选项卡，出现的界面上有书名文本框和一个按钮，输入书名后点击“删除”按钮，该书目信息从数据库表中删除。点击修改选项卡，出现的界面上有书名、作者、出版社、出版日期、书号、价格文本框，一个按钮。输入的书名必须是已存在的，否则会弹出消息框显示出错信息。输入信息后，点击“修改”按钮，数据库表中的相应书目信息被修改为新值。

实验源码：

BookInfo.java

<strong>/</strong>* * 项目名称:图书管理系统 * 版本:    1.0 * 创建者:  张俊强 * 创建时间:2016/5/26 * */package librarySystem;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;@SuppressWarnings("serial")public class BookInfo extends JFrame implements ActionListener{//主角面上的控件private JLabel inputLabel;private JTextField inputText;private JButton searchBut;private JTable bookTable;private JScrollPane bookScroll;private JButton addBut;private JButton modifyBut;private JButton deleteBut;private JButton refreshBut;private BookTableModel bookTableModel;public static void main(String[] args) throws SQLException {// TODO Auto-generated method stubBookInfo bookInfo=new BookInfo();bookInfo.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);bookInfo.setBounds(350, 150, 600, 400);bookInfo.setVisible(true);//bookInfo.importSQL();//导出数据bookInfo.setMinWindowLayout();//设置数据}public BookInfo() throws SQLException{//创建主界面上的控件inputLabel=new JLabel("请输入书名:");inputText=new JTextField(10);searchBut=new JButton("查询");bookTableModel=new BookTableModel();bookTable=new JTable(bookTableModel);bookScroll=new JScrollPane(bookTable);addBut=new JButton("添加");modifyBut=new JButton("修改");deleteBut=new JButton("删除");refreshBut=new JButton("刷新");searchBut.addActionListener(this);addBut.addActionListener(this);refreshBut.addActionListener(this);modifyBut.addActionListener(this);deleteBut.addActionListener(this);}void setMinWindowLayout(){//主界面布局Container con1=new Container();con1.setLayout(new FlowLayout());con1.add(inputLabel);con1.add(inputText);con1.add(searchBut);con1.add(refreshBut);Container con2=new Container();con2.setLayout(new FlowLayout());con2.add(addBut);con2.add(modifyBut);con2.add(deleteBut);this.setLayout(new BorderLayout());this.add(con1,BorderLayout.NORTH);this.add(bookScroll,BorderLayout.CENTER);this.add(con2,BorderLayout.SOUTH);this.validate();}@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubif(e.getSource()==searchBut){if(!this.inputText.getText().equals("")){   String bookName=this.inputText.getText();   String sql="SELECT * FROM book_info WHERE book_name ='"+bookName+"'";   try {    bookTableModel=new BookTableModel(sql);bookTable.setModel(bookTableModel);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}   }else{JOptionPane.showMessageDialog(this,"输入不能为空", "提示",JOptionPane.PLAIN_MESSAGE);}}else if(e.getSource()==addBut){@SuppressWarnings("unused")AddBookDialog addWin=new AddBookDialog(this,"添加图书",true);this.refreshTable();}else if(e.getSource()==refreshBut){this.refreshTable();}else if(e.getSource()==deleteBut){int rowNum=bookTable.getSelectedRow();if(rowNum<0||rowNum>bookTable.getRowCount()){JOptionPane.showMessageDialog(this,"未选中", "提示",JOptionPane.PLAIN_MESSAGE);}else{//System.out.print(bookName);int n = JOptionPane.showConfirmDialog(null, "确认删除吗?", "确认删除框", JOptionPane.YES_NO_OPTION);if (n == JOptionPane.YES_OPTION) {String bookNum=(String) bookTable.getValueAt(rowNum, 0);String sql="DELETE FROM book_info WHERE book_num= '"+bookNum+"'";bookTableModel.deleteBook(sql);this.refreshTable();JOptionPane.showMessageDialog(this,"删除成功", "提示",JOptionPane.PLAIN_MESSAGE);} else if (n == JOptionPane.NO_OPTION) {return;}}}else if(e.getSource()==modifyBut){bookTable.setModel(bookTableModel);int rowNum=bookTable.getSelectedRow();if(rowNum<0||rowNum>bookTable.getRowCount()){JOptionPane.showMessageDialog(this,"未选中", "提示",JOptionPane.PLAIN_MESSAGE);}else{@SuppressWarnings("unused")ModifyBook modifyWin=new ModifyBook(this,"修改信息",true,bookTableModel,rowNum);    this.refreshTable();}}}public void refreshTable(){BookTableModel searchBook;try {searchBook = new BookTableModel("SELECT * FROM book_info");bookTable.setModel(searchBook);bookTableModel=searchBook;} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}}

BookTableModel.java

package librarySystem;import java.sql.*;import java.util.*;/* * 图书表模型 * */import javax.swing.table.*;@SuppressWarnings("serial")public class BookTableModel extends AbstractTableModel{//表的元素private Vector<Vector<String>> rowData;private Vector<String> colName;    // 数据库    private PreparedStatement stmt;    private ResultSet result;public BookTableModel(String sql) throws SQLException{this.initData(sql);}public BookTableModel() throws SQLException{this.initData("SELECT * FROM book_info");}public void initData(String sql) throws SQLException{setRowData(new Vector<Vector<String>>());setColName(new Vector<String>());getColName().add("书号");getColName().add("书名");getColName().add("作者");getColName().add("出版社");getColName().add("出版时间");getColName().add("价格");/* * 数据库的导入 * */try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}String url= "jdbc:mysql://localhost:3306/device";String user="root";String password="zjq1314520";Connection con=DriverManager.getConnection(url,user,password);    stmt = con.prepareStatement(sql);    result=stmt.executeQuery();    importSQL();}void importSQL() throws SQLException{// TODO Auto-generated method stub@SuppressWarnings("unused")boolean signNull=true;while(result.next()){Vector<String> item=new Vector<String>();for(int i=1;i<7;i++){item.add(result.getString(i));}getRowData().add(item);signNull=false;}result.close();}@Overridepublic int getColumnCount() {//得到列数// TODO Auto-generated method stubreturn this.colName.size();}@Overridepublic int getRowCount() {//得到行数// TODO Auto-generated method stubreturn this.rowData.size();}@Overridepublic Object getValueAt(int row, int col) {//得到某行某列的数据// TODO Auto-generated method stubreturn (this.rowData.get(row)).get(col);}@Overridepublic String getColumnName(int column) {// TODO Auto-generated method stubreturn this.colName.get(column);}public Vector<Vector<String>> getRowData() {return rowData;}public void setRowData(Vector<Vector<String>> rowData) {this.rowData = rowData;}public Vector<String> getColName() {return colName;}public void setColName(Vector<String> colName) {this.colName = colName;}public void addBook(String sql){try {stmt.executeUpdate(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}//initData("SELECT * FROM book_info");}public void deleteBook(String sql){try {stmt.executeUpdate(sql);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}}

AddBookDialog.java

package librarySystem;import java.awt.*;import java.awt.event.*;import java.sql.SQLException;import javax.swing.*;@SuppressWarnings("serial")public class AddBookDialog extends JDialog implements ActionListener{private JLabel bookNumLabel;private JLabel bookNameLabel;private JLabel bookWriterLabel;private JLabel bookPublishLabel;private JLabel bookPriceLabel;private JLabel bookTimeLabel;private JTextField bookNumText;private JTextField bookNameText;private JTextField bookWriterText;private JTextField bookPublishText;private JTextField bookPriceText;private JTextField bookTimeText;private JButton submitBut;private JButton cancelBut;public AddBookDialog(Frame owner,String title,boolean model){//父窗口,窗口名,是否是模式窗口super(owner,title,model);bookNumLabel=new JLabel("书    号:");bookNameLabel=new JLabel("书    名:");bookWriterLabel=new JLabel("作    者:");bookPublishLabel=new JLabel("出版社:");bookPriceLabel=new JLabel("价    格:");bookTimeLabel=new JLabel("出版时间:");bookNumText=new JTextField(10);bookNameText=new JTextField(10);bookWriterText=new JTextField(10);bookPublishText=new JTextField(10);bookPriceText=new JTextField(10);bookTimeText=new JTextField(9);submitBut=new JButton("确认");cancelBut=new JButton("取消");submitBut.addActionListener(this);cancelBut.addActionListener(this);this.setBounds(350,150,400,260);this.setResizable(false);this.setLayout(new BorderLayout());initLayout();}public void initLayout(){Container[] con1=new Container[6];for(int i=0;i<6;i++) con1[i]=new Container();con1[0].setLayout(new FlowLayout());con1[0].add(bookNumLabel);con1[0].add(bookNumText);con1[1].setLayout(new FlowLayout());con1[1].add(bookNameLabel);con1[1].add(bookNameText);con1[2].setLayout(new FlowLayout());con1[2].add(bookWriterLabel);con1[2].add(bookWriterText);con1[3].setLayout(new FlowLayout());con1[3].add(bookPublishLabel);con1[3].add(bookPublishText);con1[4].setLayout(new FlowLayout());con1[4].add(bookPriceLabel);con1[4].add(bookPriceText);con1[5].setLayout(new FlowLayout());con1[5].add(bookTimeLabel);con1[5].add(bookTimeText);Container con2=new Container();con2.setLayout(new BorderLayout());con2.add(con1[0],BorderLayout.NORTH);con2.add(con1[1],BorderLayout.CENTER);con2.add(con1[2],BorderLayout.SOUTH);Container con3=new Container();con3.setLayout(new BorderLayout());con3.add(con1[3],BorderLayout.NORTH);con3.add(con1[4],BorderLayout.CENTER);con3.add(con1[5],BorderLayout.SOUTH);Container con4=new Container();con4.setLayout(new FlowLayout());con4.add(submitBut);con4.add(cancelBut);Container con5=new Container();con5.setLayout(new BorderLayout());con5.add(con2,BorderLayout.NORTH);con5.add(con3,BorderLayout.CENTER);con5.add(con4,BorderLayout.SOUTH);this.add(con5,BorderLayout.CENTER);this.validate();this.setVisible(true);}@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubif(e.getSource()==submitBut){if(bookNumText.getText().equals("")||bookNameText.getText().equals("")||bookWriterText.getText().equals("")||bookPublishText.getText().equals("")||bookPriceText.getText().equals("")||bookTimeText.getText().equals("")){//System.out.println("输入失败");    JOptionPane.showMessageDialog(this,"输入不能有空", "提示",JOptionPane.PLAIN_MESSAGE);}else{//System.out.println("输入成功");String sql="insert into "+ "book_info(book_num,book_name,book_writer,publish_house,book_price,publish_time)"+ "values('"+bookNumText.getText()+"','"+bookNameText.getText()+"','"+bookWriterText.getText()+"','"+bookPublishText.getText()+"','"+bookPriceText.getText()+"','"+bookTimeText.getText()+"')";try {BookTableModel book=new BookTableModel();book.addBook(sql);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}JOptionPane.showMessageDialog(this,"添加成功", "提示",JOptionPane.PLAIN_MESSAGE);    this.setVisible(false);}}if(e.getSource()==cancelBut){this.setVisible(false);}}}

ModifyBook.java

package librarySystem;import java.awt.*;import java.awt.event.*;import java.sql.SQLException;import javax.swing.*;@SuppressWarnings("serial")public class ModifyBook extends JDialog implements ActionListener{private JLabel bookNumLabel;private JLabel bookNameLabel;private JLabel bookWriterLabel;private JLabel bookPublishLabel;private JLabel bookPriceLabel;private JLabel bookTimeLabel;private JTextField bookNumText;private JTextField bookNameText;private JTextField bookWriterText;private JTextField bookPublishText;private JTextField bookPriceText;private JTextField bookTimeText;private JButton submitBut;private JButton cancelBut;private BookTableModel bookModel;private int rowNum;public ModifyBook(Frame owner,String title,boolean type,BookTableModel model,int row){super(owner,title,type);bookModel=model;rowNum=row;bookNumLabel=new JLabel("书    号:");bookNameLabel=new JLabel("书    名:");bookWriterLabel=new JLabel("作    者:");bookPublishLabel=new JLabel("出版社:");bookPriceLabel=new JLabel("价    格:");bookTimeLabel=new JLabel("出版时间:");bookNumText=new JTextField(10);bookNameText=new JTextField(10);bookWriterText=new JTextField(10);bookPublishText=new JTextField(10);bookPriceText=new JTextField(10);bookTimeText=new JTextField(9);submitBut=new JButton("确认修改");cancelBut=new JButton("取消");submitBut.addActionListener(this);cancelBut.addActionListener(this);this.setBounds(350,150,400,260);this.setResizable(false);this.setLayout(new BorderLayout());this.setValue();this.initLayout();}public void initLayout(){Container[] con1=new Container[6];for(int i=0;i<6;i++) con1[i]=new Container();con1[0].setLayout(new FlowLayout());con1[0].add(bookNumLabel);con1[0].add(bookNumText);con1[1].setLayout(new FlowLayout());con1[1].add(bookNameLabel);con1[1].add(bookNameText);con1[2].setLayout(new FlowLayout());con1[2].add(bookWriterLabel);con1[2].add(bookWriterText);con1[3].setLayout(new FlowLayout());con1[3].add(bookPublishLabel);con1[3].add(bookPublishText);con1[4].setLayout(new FlowLayout());con1[4].add(bookPriceLabel);con1[4].add(bookPriceText);con1[5].setLayout(new FlowLayout());con1[5].add(bookTimeLabel);con1[5].add(bookTimeText);Container con2=new Container();con2.setLayout(new BorderLayout());con2.add(con1[0],BorderLayout.NORTH);con2.add(con1[1],BorderLayout.CENTER);con2.add(con1[2],BorderLayout.SOUTH);Container con3=new Container();con3.setLayout(new BorderLayout());con3.add(con1[3],BorderLayout.NORTH);con3.add(con1[4],BorderLayout.CENTER);con3.add(con1[5],BorderLayout.SOUTH);Container con4=new Container();con4.setLayout(new FlowLayout());con4.add(submitBut);con4.add(cancelBut);Container con5=new Container();con5.setLayout(new BorderLayout());con5.add(con2,BorderLayout.NORTH);con5.add(con3,BorderLayout.CENTER);con5.add(con4,BorderLayout.SOUTH);this.add(con5,BorderLayout.CENTER);this.validate();this.setVisible(true);}public void setValue(){this.bookNumText.setText((String) bookModel.getValueAt(rowNum, 0));this.bookNumText.setEditable(false);this.bookNameText.setText((String) bookModel.getValueAt(rowNum, 1));this.bookWriterText.setText((String) bookModel.getValueAt(rowNum, 2));this.bookPublishText.setText((String) bookModel.getValueAt(rowNum, 3));this.bookTimeText.setText((String) bookModel.getValueAt(rowNum, 4));this.bookPriceText.setText((String) bookModel.getValueAt(rowNum, 5));this.validate();}@Overridepublic void actionPerformed(ActionEvent e) {//System.out.println(bookPriceText.getText());// TODO Auto-generated method stubif(e.getSource()==submitBut){if(bookNumText.getText().equals("")||bookNameText.getText().equals("")||bookWriterText.getText().equals("")||bookPublishText.getText().equals("")||bookPriceText.getText().equals("")||bookTimeText.getText().equals("")){//System.out.println("输入失败");    JOptionPane.showMessageDialog(this,"修改不能有空", "提示",JOptionPane.PLAIN_MESSAGE);}else{int n = JOptionPane.showConfirmDialog(null, "确认修改吗?", "确认修改框", JOptionPane.YES_NO_OPTION);if (n == JOptionPane.YES_OPTION) {String sql="UPDATE book_info SET book_name ='"+bookNameText.getText()+"', book_writer= '"+bookWriterText.getText()+"',publish_house='"+bookPublishText.getText()+"',book_price='"+bookPriceText.getText()+"',publish_time='"+bookTimeText.getText()+"' WHERE book_num = '"+bookNumText.getText()+"' ";try {BookTableModel book=new BookTableModel();book.addBook(sql);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}JOptionPane.showMessageDialog(this,"修改成功", "提示",JOptionPane.PLAIN_MESSAGE);    this.setVisible(false);} else if (n == JOptionPane.NO_OPTION) {return;}}}if(e.getSource()==cancelBut){this.setVisible(false);}}}

程序运行结果：
主界面：

查询界面：

添加图书界面：

修改界面：

删除操作：

数据库界面：