LJ Archive

Listing 1. Example Java Code

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(); } } }
LJ Archive