Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void updateSearchTable(){
- Connection con=null;
- try {
- Class.forName(dbClass);
- con = DriverManager.getConnection (dbUrl,dbUsername, dbPassword);
- Statement stmt = con.createStatement();
- String userQuery = "SAMPLE SQL QUERY";
- ResultSet userResult = stmt.executeQuery(userQuery);
- if(!userResult.next()){
- JOptionPane.showMessageDialog(null, "No Results.");
- }
- else{
- ResultSetMetaData rsMetaData =userResult.getMetaData();
- DefaultTableModel dtm = new DefaultTableModel();
- int cols = rsMetaData.getColumnCount();
- Vector colName = new Vector();
- Vector dataRows = new Vector();
- for (int i=1; i<cols; i++){
- colName.addElement(rsMetaData.getColumnName(i));
- }
- dtm.setColumnIdentifiers(colName);
- while(userResult.next()){
- dataRows = new Vector();
- for(int j = 1; j<cols; j++){
- dataRows.addElement(userResult.getString(j));
- }
- dtm.addRow(dataRows);
- }
- searchTable.setModel(dtm);
- }
- }
- catch(ClassNotFoundException | SQLException e) {
- JOptionPane.showMessageDialog(null, "Database Error.");
- }
- finally{
- try {
- con.close();
- } catch (SQLException ex) {
- Logger.getLogger(PatientSearchResults.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement