|
import java.net.URL;
|
|
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
|
|
while (rs.next() ) {
|
|
int a = rs.getInt(1);
|
|
String str = rs.getString(2);
|
|
System.out.println("key = " + a);
|
|
System.out.println("str = " + str); }
|
