May 6th, 2001, 08:23 PM
|
|
Junior Member
|
|
Join Date: May 2001
Location: Rep. of Ireland
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
This is the basis of it, you'll need to know the name of the MYSQL driver your host is using and change it accordingly.
You'll also need to know the URL of the database, this should also be available from your host.
You can plug this into any Servlet or JSP
Firstly import java.sql.*; into your program, along with whatever else your importing.
PHP Code:
//Credentials for connecting to database
String url = "jdbc:mysql://someurl";
String user = "username;
String pass = "password";
//Attempt connection & catch any errors that occur
try
{
Class.forName( "org.gjt.mm.mysql.Driver" );//MySQL driver
connection = DriverManager.getConnection(url, user, pass );
}
catch ( ClassNotFoundException cnfex )
{
System.err.println( "Failed to load JDBC/ODBC driver." );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
catch ( SQLException sqlex )
{
System.err.println( "Unable to connect" );
sqlex.printStackTrace();
}
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
