圖書管理系統java版

本文的目的就是通過圖書管理系統掌握數據庫編程技術，能正確連接數據庫，能對數據庫中信息進行查詢、插入、刪除、修改。
內容：在數據庫中創建一張書目信息表，包括書名、作者、出版社、出版日期、書號、價格字段。設計一個GUI界面進行書目管理。在該界面上有四個選項卡，分別是查詢、插入、刪除、修改。點擊查詢選項卡，出現的界面上有書名、作者、出版社、書號四個文本框，一個按鈕和一個只讀文本區。文本框內容可以為空，輸入相應的查詢信息後（例如根據書名查詢可以僅輸入書名），點擊界面上的“查詢”按鈕，可以在界面下方的文本區中顯示出符合條件的書目詳細信息。點擊插入選項卡，出現的界面上有書名、作者、出版社、出版日期、書號、價格文本框，一個按鈕。在文本框中輸入信息後，點擊“插入”按鈕，該書目信息插入數據庫表中。點擊刪除選項卡，出現的界面上有書名文本框和一個按鈕，輸入書名後點擊“刪除”按鈕，該書目信息從數據庫表中刪除。點擊修改選項卡，出現的界面上有書名、作者、出版社、出版日期、書號、價格文本框，一個按鈕。輸入的書名必須是已存在的，否則會彈出消息框顯示出錯信息。輸入信息後，點擊“修改”按鈕，數據庫表中的相應書目信息被修改為新值。
源碼：

BookInfo.java

 * 項目名稱:圖書管理系統* 版本: 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 stub BookInfo 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(); } @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(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 block e1.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 block e1.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 block e.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(); } @Override public int getColumnCount() {//得到列數// TODO Auto-generated method stub return this.colName.size(); } @Override public int getRowCount() {//得到行數// TODO Auto-generated method stub return this.rowData.size(); } @Override public Object getValueAt(int row, int col) {//得到某行某列的數據// TODO Auto-generated method stub return (this.rowData.get(row)).get(col); } @Override public String getColumnName(int column) { // TODO Auto-generated method stub return 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 block e.printStackTrace(); } // initData("SELECT * FROM book_info"); } public void deleteBook(String sql){ try { stmt.executeUpdate(sql); } catch (SQLException e1) { // TODO Auto-generated catch block e1.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); } @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(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 block e1.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(); } @Override public void actionPerformed(ActionEvent e) { // System.out.println(bookPriceText.getText()); // TODO Auto-generated method stub if(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 block e1.printStackTrace(); } JOptionPane.showMessageDialog(this,"修改成功", "提示",JOptionPane.PLAIN_MESSAGE); this.setVisible(false); } else if (n == JOptionPane.NO_OPTION) { return; } } } if(e.getSource()==cancelBut){ this.setVisible(false); } } }

程序運行結果：
主界面：

查詢界面：

添加圖書界面：

修改界面：

刪除操作：

數據庫界面：

關於管理系統的更多內容請點擊《管理系統專題》進行學習

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持武林網。