Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'Data_base'"
- public boolean dbExists(String puerto, String db, String pass) {
- boolean exist = false;
- try {
- Connection conn = null;
- Statement st = null;
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection("jdbc:mysql://localhost:" + puerto + "/" + db, "root", pass);
- st = conn.createStatement();
- String sql = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '" + db + "'";
- ResultSet rs = st.executeQuery(sql);
- if (rs.next()) {
- //JOptionPane.showMessageDialog(main, "La base de datos existe.");
- exist = true;
- }
- } catch (ClassNotFoundException ex) {
- } catch (SQLException ex) {
- //JOptionPane.showMessageDialog(main, "La base de datos no existe.");
- exist = false;
- }
- return exist;
- }
Add Comment
Please, Sign In to add comment