Guest User

Untitled

a guest
Oct 16th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'Data_base'"
  2.  
  3. public boolean dbExists(String puerto, String db, String pass) {
  4. boolean exist = false;
  5. try {
  6. Connection conn = null;
  7. Statement st = null;
  8. Class.forName("com.mysql.jdbc.Driver");
  9. conn = DriverManager.getConnection("jdbc:mysql://localhost:" + puerto + "/" + db, "root", pass);
  10. st = conn.createStatement();
  11. String sql = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '" + db + "'";
  12. ResultSet rs = st.executeQuery(sql);
  13.  
  14. if (rs.next()) {
  15. //JOptionPane.showMessageDialog(main, "La base de datos existe.");
  16. exist = true;
  17. }
  18. } catch (ClassNotFoundException ex) {
  19.  
  20. } catch (SQLException ex) {
  21. //JOptionPane.showMessageDialog(main, "La base de datos no existe.");
  22. exist = false;
  23. }
  24. return exist;
  25. }
Add Comment
Please, Sign In to add comment