Guest User

Untitled

a guest
Apr 16th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. DefaultTableModel model=(DefaultTableModel)dbTbl.getModel();
  2. try{
  3. Class.forName("com.mysql.jdbc.Driver");
  4. Connection con=DriverManager.getConnection("jdbc:mysql//localhost/:3306","root","password");
  5. Statement stmt=con.createStatement();
  6. ResultSet rs=stmt.executeQuery("show databases;");
  7. while(rs.next())
  8. {
  9. String db=rs.getString(1);
  10. model.addRow(new Object[] {db});
  11. }
  12. rs.close();
  13. stmt.close();
  14. con.close();
  15. }
  16. catch(Exception e)
  17. {
  18. JOptionPane.showMessageDialog(null,"nahi chalda");
  19. }
  20.  
  21. DefaultTableModel model = (DefaultTableModel) dbTbl.getModel();
  22. Class.forName("com.mysql.jdbc.Driver");
  23. Connection con = DriverManager.getConnection("jdbc:mysql://localhost/:3306","root","password");
  24. DatabaseMetaData meta = con.getMetaData();
  25. ResultSet res = meta.getCatalogs();
  26. while (res.next()) {
  27. String db = res.getString("TABLE_CAT");
  28. model.addRow(new Object[] {db});
  29. }
  30. res.close();
  31.  
  32. Connection con=DriverManager.getConnection("jdbc:mysql://localhost/:3306","root","password");
Add Comment
Please, Sign In to add comment