import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
public class Example1 {
public static void main(String[] argv) {
System.out.println("Checking if Driver is registered with DriverManager.");
try {
Class.forName("org.postgresql.Driver");
} catch (ClassNotFoundException cnfe) {
System.out.println("Couldn't find the driver!");
System.out.println("Let's print a stack trace, and exit.");
cnfe.printStackTrace();
System.exit(1);
}
System.out.println("Registered the driver ok, so let's make a connection.");
Connection c = null;
try {
// The second and third arguments are the username and password,
// respectively. They should be whatever is necessary to connect
// to the database.
c = DriverManager.getConnection("jdbc:postgresql://localhost/DBname",
"DBuser", "DBpassword");
} catch (SQLException se) {
System.out.println("Couldn't connect: print out a stack trace and exit.");
se.printStackTrace();
System.exit(1);
}
if (c != null)
System.out.println("Hooray! We connected to the database!");
else
System.out.println("We should never get here.");
}
}
'Database > PostgreSQL' 카테고리의 다른 글
create super user with password on postgresql (0) | 2016.07.25 |
---|---|
* No PostgreSQL clusters exist; see "man pg_createcluster" (0) | 2016.07.25 |
psql: FATAL: Peer authentication failed for user (0) | 2016.06.27 |
create database in postgresql (0) | 2016.06.27 |
postgresql user list (0) | 2016.06.27 |
댓글