Example - Using Imaginary’s mSQL Driver

import java.sql.*;

import imaginary.sql.*;

class Select {

public static void main (String argv[] ) {

try {

//load the class imaginary/sql/iMsqlDriver

Class.forName (“ imaginary.sql.iMsqlDriver”);

String url = jdbc:msql://host.npac.syr.edu:4333/test”;

//connect to the test database using the driver URL

Connection conn = DriverManager.getConnection( url, “scott”, “tiger”);

//create the query statement and get the result set

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery (“ select * from

test_table order by id”);

System.out.println (“Got results :”);

//print the results in a loop