圖書信息 · Java學習（三）

BookManage.java ~~~ package zyw.admin; import zyw.tools.DataBase; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.Vector; public class BookManage extends JPanel implements ActionListener { private JSplitPane jsp=new JSplitPane(JSplitPane.VERTICAL_SPLIT,true); private JPanel jpt=new JPanel(); String []str1=new String [7]; String sql; DataBase db; private JLabel[] jlArray=new JLabel[] { new JLabel(" 書號"), new JLabel(" 書名"), new JLabel(" 作者"), new JLabel(" 出版社"), new JLabel(" 購買日期"), new JLabel(" 已預約"), new JLabel(" 已借閱") }; private JTextField[] jtxtArray=new JTextField[] { new JTextField(), new JTextField(), new JTextField(), new JTextField(), new JTextField() }; //設置JButton按鈕的文本 private JButton[] jbArray= { new JButton("圖書入庫"), new JButton("刪除圖書"), new JButton("修改圖書記錄"), new JButton("查找圖書") }; //創建標題 Vector<String> head = new Vector<String>(); { head.add("書號"); head.add("書名"); head.add("作者"); head.add("出版社"); head.add("購買日期"); head.add("是否借閱"); head.add("是否預約"); } //在下部子窗口中設置表格 Vector<Vector> data=new Vector<Vector>(); //創建表格模型 DefaultTableModel dtm=new DefaultTableModel(data,head); //創建Jtable對象 JTable jt=new JTable(dtm); //將JTable封裝到滾動窗格 JScrollPane jspn=new JScrollPane(jt); //創建表示下拉列表框數據模型的字符串數組 private String[] str={"否","是"}; //創建下拉列表框 private JComboBox jcp1=new JComboBox(str); private JComboBox jcp2=new JComboBox(str); public BookManage() { this.setLayout(new GridLayout(1,1)); //設置面板的上部分為空布局管理器 jpt.setLayout(null); //設置jspt中分割條的初始位置 jsp.setDividerLocation(140); //設置分隔條的寬度 jsp.setDividerSize(4); jsp.setTopComponent(jpt); jsp.setBottomComponent(jspn); for(int i=0;i<5;i++) { jpt.add(jtxtArray[i]); } for(int i=0;i<7;i++) { jpt.add(jlArray[i]); if(i<3) { jlArray[i].setBounds(15,10+30*i,100,20); jtxtArray[i].setBounds(115,10+30*i,150,20); } else if(i>2&&i<5) { jlArray[i].setBounds(265,10+30*(i-3),100,20); jtxtArray[i].setBounds(375,10+30*(i-3),120,20); } else { jlArray[i].setBounds(495,10+30*(i-5),100,20); } } for(int i=0;i<5;i++) { jtxtArray[i].addActionListener(this); } this.add(jsp); jpt.add(jcp1); jpt.add(jcp2); //設置下部子窗格 jsp.setBottomComponent(jspn); jcp1.setBounds(595,10,100,20); jcp2.setBounds(595,40,100,20); //將JButton添加進jpt for(int i=0;i<4;i++) { jpt.add(jbArray[i]); jbArray[i].setBounds(150+112*i,100,112,25); } //設置監聽器 for(int i=0;i<4;i++) { jbArray[i].addActionListener(this); } //設置窗體的大小位置及可見性 this.setBounds(5,5,600,500); this.setVisible(true); } public void actionPerformed(ActionEvent e){ //設置鼠標焦點 if(e.getSource()==jtxtArray[0]){ jtxtArray[1].requestFocus(); } if(e.getSource()==jtxtArray[1]){ jtxtArray[2].requestFocus(); } if(e.getSource()==jtxtArray[2]){ jtxtArray[3].requestFocus(); } if(e.getSource()==jtxtArray[3]){ jtxtArray[4].requestFocus(); } if(e.getSource()==jbArray[0]){//添加圖書 this.insertBook(); } if(e.getSource()==jbArray[1]){//將書號為書號框的書從書庫刪除 this.deleteBook(); } if(e.getSource()==jbArray[2]){//將書號為書號框的書信息進行修改 this.updateBook(); } if(e.getSource()==jbArray[3]){//查詢圖書信息 this.searchBook(); } } public void insertBook(){ for(int i=0;i<5;i++){//聲明輸入變量 str1[i]=jtxtArray[i].getText().trim(); } if(str1[0].equals("")&&str1[1].equals("")&&str1[2].equals("") &&str1[3].equals("")&&str1[4].equals("")){//當輸入為空進行提示 JOptionPane.showMessageDialog(this, "圖書信息不能為空！！！", "消息",JOptionPane.INFORMATION_MESSAGE); return; } if(!str1[0].equals("")&&!str1[1].equals("")&&!str1[2].equals("") &&!str1[3].equals("")&&!str1[4].equals("")){//將圖書信息插入Book表 str1[5]=jcp1.getSelectedItem().toString(); str1[6]=jcp2.getSelectedItem().toString(); sql="insert into BOOK values('"+str1[0]+"','"+str1[1]+"','" + str1[2] + "',' "+str1[3]+"','"+ str1[4]+"','"+str1[5]+"','"+str1[6]+"')"; db=new DataBase(); Vector<String> v = new Vector<String>(); for(int i=1;i<=7;i++){//將每列添加到臨時數組v v.add(str1[i-1]); } data.add(v); dtm.setDataVector(data,head);//更新table jt.updateUI(); jt.repaint(); return; } } public void deleteBook(){ String bookno = jtxtArray[0].getText().trim(); if(bookno.equals("")){//當書號輸入為空，提示 JOptionPane.showMessageDialog(this, "書號不能為空！！！", "消息",JOptionPane.INFORMATION_MESSAGE); return; } sql="select * from RECORD where BookNO="+Integer.parseInt(bookno); db=new DataBase(); sql="delete from book where BookNO="+Integer.parseInt(bookno); } public void updateBook(){ String bookno = jtxtArray[0].getText().trim(); if(bookno.equals("")){//當書號輸入為空時，進行提示 JOptionPane.showMessageDialog(this, "請輸入需要更改信息圖書的書號！", "消息",JOptionPane.INFORMATION_MESSAGE); return; } else{//當輸入書號后的情況 for(int i=0;i<5;i++){//聲明文本框輸入的變量 str1[i]=jtxtArray[i].getText().trim(); } db=new DataBase(); int i=0; int flag=0; int b=Integer.parseInt(bookno); if(!str1[1].equals("")){i=i+1;} if(!str1[2].equals("")){i=i+2;} if(!str1[3].equals("")){i=i+4;} if(!str1[4].equals("")){i=i+8;} switch(i){//請詳細解讀switch語句 case 0: JOptionPane.showMessageDialog(this,"信息不能為空！！！", "消息",JOptionPane.INFORMATION_MESSAGE); break; case 1: sql="update BOOK set BookName='"+str1[1]+"' where BookNO="+b; db=new DataBase(); if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 2: sql="update BOOK set Author='"+str1[2]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 3: sql="update BOOK set BookName='"+str1[1]+"',"+"Author='" +str1[2]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 4: sql="update BOOK set Publishment='"+str1[3]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 5: sql="update BOOK set BookName='"+str1[1]+"',"+"Publishment='" +str1[3]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 6: sql="update BOOK set Author='"+str1[2]+"',"+"Publishment='" +str1[3]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 7: sql="update BOOK set BookName='"+str1[1]+"',"+"Author='"+str1[2] +"',"+"Publishment='"+str1[3]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 8: sql="update BOOK set BuyTime='"+str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 9: sql="update BOOK set BookName='"+str1[1]+"',"+"BuyTime='" +str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 10: sql="update BOOK set Author='"+str1[2]+"',"+"BuyTime='" +str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 11: sql="update BOOK set BookName='"+str1[1]+"',"+"Author='"+str1[2] +"',"+"BuyTime='"+str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 12: sql="update BOOK set Publishment='"+str1[3]+"',"+"BuyTime='" +str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 13: sql="update BOOK set BookName='"+str1[1]+"',"+"Publishment='"+str1[3] +"',"+"BuyTime='"+str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 14: sql="update BOOK set Author='"+str1[1]+"',"+"Publishment='"+str1[2] +"',"+"BuyTime='"+str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; case 15: sql="update BOOK set BookName='"+str1[1]+"',"+"Author='"+str1[2]+"',"+ "Publishment='"+str1[3]+"',"+"BuyTime='"+str1[4]+"' where BookNO="+b; if(flag>0){ JOptionPane.showMessageDialog(this,"恭喜你，修改成功!!!", "消息",JOptionPane.INFORMATION_MESSAGE); }break; } } } public void searchBook(){//彈出提示對話框 JOptionPane.showMessageDialog(this, "請點擊左邊窗口的 '查詢圖書' 按鈕！！", "強烈推薦",JOptionPane.INFORMATION_MESSAGE); return; } } ~~~