Skip to content

Latest commit

 

History

History
26 lines (19 loc) · 875 Bytes

README.md

File metadata and controls

26 lines (19 loc) · 875 Bytes
Raw

DBUtil

Java Library for Generate Table/ComboBox/List Models and Vectors from sql ResultSets

Example of Usage

  • Suppose you have a ResultSet called res created by executing following sql Query SELECT name AS Name, age AS Age FROM student

  • DefaultTableModel DefaultTableModel dtm = DBUtil.resultSetToTableModel(res);

  • DefaultComboBoxModel DefaultComboBoxModel<Object> dcm = DBUtil.resultSetToComboBoxModel(res);

  • ListModel DefaultListModel<Object> dlm = DBUtil.resultSetToListModel(res);

  • Vector filled with column names in ResultSet Vector<String> col = DBUtil.resultSetToColumnNameVector(res);

  • Vector of Vectors with row data Vector<Object> rows = DBUtil.resultSetToRowsVector(res);

Notes

  • Add dbutil.jar file to your classpath before using.
  • And import DBUtil by import org.gck.DBUtil;
  • See JavaDocs for other useful overloaded methods.