Connecting an Java applet to a Postgre SQL database

[Jesse]

Hi all,

Can some ona help me with some examples of how to connect a PostgreSQL
databas via an java Applet anything would be more then welcome.

Thanks in forward,

Jesse

 

[kevin]

Hi all,

Can some ona help me with some examples of how to connect a PostgreSQL
databas via an java Applet anything would be more then welcome.

Thanks in forward,

Jesse

AFAIU...
i haven't tried connecting to an external resource from an applet. You
might find all kinds of nasties in java permissions and html source
tainting.

assuming none of those apply, you could do this...

1) define a Driver class. get the jdbc driver from the postgres site
and install it in your classpath

2) set a driver class for the postgres jdbc driver
try{
Class.forName("org.postgresql.Driver");
}
catch (ClassNotFoundException cnfe){
// crash and burn
}
3) make a connection to that driver passing your db credentials in
try {
Connection =
DriverManager.getConnection("jdbcostgresql:<dbname>", <uid>,
<passwd>);
catch (SQLException sqle) {
// crash and burn
}

you should be able to access the db given all of the nasties haven't
got you.

HTH

kev.

 

[Roedy Green]

Can some ona help me with some examples of how to connect a PostgreSQL
databas via an java Applet anything would be more then welcome.

Normally you would talk to a servlet which in turn would do the
database access. You don't normally expose your database API to Applet
hackers.

 

[Oscar kind]

Can some ona help me with some examples of how to connect a PostgreSQL
databas via an java Applet anything would be more then welcome.

Class.forName("org.postgresql.Driver");
String dbURL = "jdbcostgresql:Test";
//String dbURL = "jdbcostgresql://localhost/Test";
//String dbURL = "jdbcostgresql://localhost:5432/Test";
Connection connection = DriverManager.getConnect(
dbURL, "username", "password");


Classpath, exception handling, etc. I'll leave as an exerise for you.


Oscar

 

[Ryan Stewart]

Class.forName("org.postgresql.Driver");
String dbURL = "jdbcostgresql:Test";
//String dbURL = "jdbcostgresql://localhost/Test";
//String dbURL = "jdbcostgresql://localhost:5432/Test";
Connection connection = DriverManager.getConnect(
dbURL, "username", "password");

That's DriverManager.getConnection(.....