import java.net.URL; import exjava.sql.*; import exgwe.sql.*; public class jdbc_test { public static void main (String argv[] ) { try { // Load the gweMysqlDriver JDBC Driver Class.forName("exgwe.sql.gweMysqlDriver"); // Create the URL of the database we wish to // connect to String url = "jdbc:mysql://localhost:3306/test"; // Set up a connection Connection con = DriverManager.getConnection(url,
"userid", "pass"); // Create statement Statement stmt = con.createStatement(); // Execute query String query = "select name, phone from
test_table"; // Obtain the result set ResultSet rs = stmt.executeQuery(query); // Loop through each result row while (rs.next() ) { System.out.println( rs.getString(0),
rs.getInt(1) ); } // Close result set rs.close(); // Close statement" stmt.close();" // Close connection con.close(); } catch( Exception e ) { e.printStackTrace(); } } }