JComboBox comboBox = new JComboBox(); comboBox.setModel(new DefaultComboBoxModel(new String[] {"DateSave", "Category", "Amount", "Content"})); comboBox.setBounds(250, 476, 107, 26); add(comboBox); textFieldSearch = new JTextField(); textFieldSearch.addKeyListener(new KeyAdapter() { @Override public void keyPressed(KeyEvent arg0) { try{ String selection = (String)comboBox.getSelectedItem(); Class.forName("org.gjt.mm.mysql.Driver"); String url =""; url = "jdbc:mysql://localhost/project"; Connection con = DriverManager.getConnection(url, "ITUser", "user"); String query="Select * from saving where "+selection+" =?"; PreparedStatement pst= (PreparedStatement) con.prepareStatement(query); pst.setString(1,textFieldSearch.getText()); ResultSet rs=pst.executeQuery(); Savingtable.setModel(DbUtils.resultSetToTableModel(rs)); String search = textFieldSearch.getText(); if(search.length() == 0){ //to make back normal when search is empty setTableModelFromDB(); scrollPane.setViewportView(Savingtable); scrollPane.setColumnHeaderView(Savingtable.getTableHeader()); } while(rs.next()) { } pst.close(); }catch(Exception ex){ ex.printStackTrace(); } } }); textFieldSearch.setBounds(716, 474, 146, 26); add(textFieldSearch); textFieldSearch.setColumns(10);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)