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);
}
}
}