Advertisement
Guest User

Untitled

a guest
Jul 19th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. public ResultSet getusers()
  2. {
  3. try
  4. {
  5. sql="select userid,username,fullname,gender from users";
  6. st=con.prepareStatement(sql);
  7. rs=st.executeQuery();
  8. return rs;
  9. }
  10. catch(SQLException e)
  11. {
  12. e.printStackTrace();
  13. return null;
  14. }
  15. }
  16. public static DefaultTableModel buildTableModel(ResultSet rs)
  17. throws SQLException {
  18.  
  19. ResultSetMetaData metaData = rs.getMetaData();
  20.  
  21. // names of columns
  22. Vector<String> columnNames = new Vector<String>();
  23. int columnCount = metaData.getColumnCount();
  24. for (int column = 1; column <= columnCount; column++) {
  25. columnNames.add(metaData.getColumnName(column));
  26. }
  27.  
  28. // data of the table
  29. Vector<Vector<Object>> data = new Vector<Vector<Object>>();
  30. while (rs.next()) {
  31. Vector<Object> vector = new Vector<Object>();
  32. for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {
  33. vector.add(rs.getObject(columnIndex));
  34. }
  35. data.add(vector);
  36. }
  37.  
  38. return new DefaultTableModel(data, columnNames);
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement