基于java的图书馆理系统的学生界面查询功能实现.docx

package library;import java.awt.BorderLayout;import java.awt.Font;import java.awt.GridLayout;import java.awt.Panel;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Vector;import javax.swing.JButton;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.JTextField;import javax.swing.JToolBar;import javax.swing.table.DefaultTableModel;public class query extends JFrame implements ActionListener private static final int AUTO_RESIZE_OFF = 0;private static final boolean JComboBox = false;private JTextField idfield;private JTextField namefield;private JTextField catefield;private JTextField authorfield;private JButton querybutton;private DbTableModel tableModel;private ResultSet rs;private String idtext;private String nametext;private String authortext;private JComboBox box;private String string;private Object selectedItem;public query() init();private void init() setDefaultCloseOperation(EXIT_ON_CLOSE);setBounds(200, 200, 470, 400);setTitle(图书信息查询);JPanel panel = new JPanel();add(panel, BorderLayout.NORTH);panel.setLayout(new BorderLayout();JLabel label = new JLabel(高级搜索, JLabel.CENTER);label.setFont(new Font(宋体, Font.BOLD, 12);panel.add(label, BorderLayout.WEST);Panel panel2 = new Panel();panel.add(panel2, BorderLayout.CENTER);panel2.setLayout(new GridLayout(4, 2);JLabel idlabel = new JLabel(编号, JLabel.CENTER);panel2.add(idlabel);idfield = new JTextField();panel2.add(idfield);JLabel labelauthor = new JLabel(作者, JLabel.CENTER);panel2.add(labelauthor);authorfield = new JTextField();panel2.add(authorfield);JLabel namelabel = new JLabel(书名, JLabel.CENTER);panel2.add(namelabel);namefield = new JTextField();panel2.add(namefield);JLabel catelabel = new JLabel(分类, JLabel.CENTER);panel2.add(catelabel);box = new JComboBox();panel2.add(box);box.addItem();JToolBar toolBar = new JToolBar();toolBar.setFloatable(false);add(toolBar, BorderLayout.SOUTH);Panel panel3 = new Panel();panel.add(panel3, BorderLayout.EAST);querybutton = new JButton(搜索);panel3.add(querybutton);querybutton.addActionListener(this);JTable table = new myJtable();table.setAutoResizeMode(AUTO_RESIZE_OFF);add(new JScrollPane(table);tableModel = new DbTableModel();tableModel.setColumnIdentifiers(new String 编号, 书名, 作者, 出版社,数目,类别 );table.setModel(tableModel);try DbUtil util = DbUtil.getUtil();Statement stat = util.getStatement();ResultSet set = stat.executeQuery(select cate_name from bo_cate);while(set.next()string = set.getString(1);box.addItem(string); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public void getRs() try DbUtil util = DbUtil.getUtil();Statement stat = util.getStatement();idtext = idfield.getText();nametext = namefield.getText();authortext = authorfield.getText();selectedItem = box.getSelectedItem();String s1 = book_id= + idtext;String s2 = bo_name= + nametext + ;String s3 = author= + authortext + ;String s4 = cate_name= + + selectedItem+ ;if (idtext.trim().equals() | idtext = null) s1 = 1=1;if (nametext.trim().equals() | nametext = null) s2 = 1=1;if (authortext.trim().equals() | authortext = null) s3 = 1=1;if (box.getSelectedItem().equals() s4 = 1=1;String sql = select * from book where + s1 + and + s2+ and + s3 + and + s4 + order by book_id ;rs = stat.executeQuery(sql);tableModel.removeAll();/ 查询成功清除表格里的数据while (rs.next() / 行内数据Vector vector = new Vector();vector.add(rs.getString(1);vector.add(rs.getString(2);vector.add(rs.getString(3);vector.add(rs.getString(4);vector.add(rs.getString(5);vector.add(rs.getString(6);tableModel.addRow(vector);if (tableModel.getRowCount() = 0) JOptionPane.showMessageDialog(this, 不存在相关信息！);rs.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();class DbTableModel extends DefaultTableModel void removeAll() dataVector.removeAllElements();/ 一定要有，通知view更新fireTableStructureChanged();Overridepublic void actionPerformed(ActionEvent e) Object sou