Select a postgres database after onnect on java [duplicate]

Question

This code connects abd create a database ,how can I select the created database to use it?

public class Connect {

    public static void main(String[] args) {
        Connection connection = null;
        try {
            Class.forName("org.postgresql.Driver");
            connection = DriverManager.getConnection(
            "jdbc:postgresql://localhost:5432/","postgres", "12345");


            Statement statement = connection.createStatement();
            statement.execute("CREATE DATABASE mydb");
            //now I hav to connect to mydb

            connection.close();
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(OracleToPostgres.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(OracleToPostgres.class.getName()).log(Level.SEVERE, null, ex);
        }   
    }
}

have you considered creating another connection with your new database? — Jim Jones
– Jim Jones, Commented Feb 19, 2018 at 15:45
Why don't you simply close the connection and open another one with the correct db? — BackSlash
– BackSlash, Commented Feb 19, 2018 at 15:45

Jim Jones · Accepted Answer · 2018-02-19 15:47:40Z

0

Something like this will do ...

Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/mydb", "user", "password");

answered Feb 19, 2018 at 15:47

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select a postgres database after onnect on java [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related