Advertisement
Guest User

Untitled

a guest
Mar 14th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. DB_CONNECTION_URL = "jdbc:mysql://localHost:3306/test_DB";
  2.  
  3. DB_CONNECTION_URL = "jdbc:mysql://localHost:3306/";
  4.  
  5. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306","root","root");
  6. Statement st = con.createStatement();
  7. DatabaseMetaData meta = con.getMetaData();
  8. ResultSet rs = meta.getCatalogs();
  9. while (rs.next()) {
  10. String listofDatabases=rs.getString("TABLE_CAT");
  11. list.add(listofDatabases);
  12. }
  13. if(list.contains(database)){
  14. System.out.println("Database already exists");
  15.  
  16. String database = DATABASENAME; // "nlshriraam";//bf.readLine();
  17. st.executeUpdate("CREATE DATABASE "+database);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement