java resultset to table
public static DefaultTableModel buildTableModel(ResultSet rs)
throws SQLException {
ResultSetMetaData metaData = rs.getMetaData();
// names of columns
Vector<String> columnNames = new Vector<String>();
int columnCount = metaData.getColumnCount();
for (int column = 1; column <= columnCount; column++) {
columnNames.add(metaData.getColumnName(column));
}
// data of the table
Vector<Vector<Object>> data = new Vector<Vector<Object>>();
while (rs.next()) {
Vector<Object> vector = new Vector<Object>();
for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {
vector.add(rs.getObject(columnIndex));
}
data.add(vector);
}
return new DefaultTableModel(data, columnNames);
}
Also in Java:
- web app runtime for java
- 2d array java
- java get location of jar file
- number of matches regex java
- replaceall in java
- how to cut a certion part from a string in java
- set top corner of shape radius programmatically android
- java create file if not exists
- java shortest if else statement
- java convert a set to array
- java
- a recursive function that calculates the greatest common divisor from user's input in java
- cosinus-1 java
- spigot custom mob
- java iterate over list
- check java version
- java read file text
- how to create a Rectangle in java
- java singleton implementation
- init cap java
- javafx textarea font size
- int to binary string java
- loop through array java
- multiplication program java