Connecting to a database in Java
It should be pretty easy right? Well it is, but difficult to troubleshoot. It will either work or won't, and you won't have a clue why not. So here's a skeleton program that you can use:
import import oracle.jdbc.pool.OracleDataSource;
public class DoDatabaseStuff
public static void main(String args) throws Exception
// Put connection code here..
Make sure you put mysql-connector-java-3.1.8-bin.jar into your classpath when running.
Connection mysqlConn = DriverManager.getConnection("jdbc:mysql://localhost/DBNAME?user=root&password=WhateverYouEntered");
Oracle 10g Express
Make sure you put ojdbc-14.jar into your classpath when running. Oh yeah, and the syntax has changed a bit.
OracleDataSource ds = new OracleDataSource();
Connection conn2 = ds.getConnection();
Once you've got your connection you can then start executing SQL by using a PreparedStatement (look it up in the Java API's). Tommorow I'll post about how to set up your test data using DBUnit.