Connor: Created page with "
You can connect to an SQL engine using JDBC. You will need to obtain a JDBC driver from the appropriate database.

The example given is based on the MySQL JDBC..."

2012-07-19T10:48:06Z

Created page with "You can connect to an SQL engine using JDBC. You will need to obtain a JDBC driver from the appropriate database. <ul> <li>The example given is based on the MySQL JDBC..."

New page

You can connect to an SQL engine using JDBC. You will need to obtain
a JDBC driver from the appropriate database.

<ul>
<li>The example given is based on the MySQL JDBC Connector/J which may be found
at [http://dev.mysql.com/downloads/connector/j/ MySQL]
</li>
<li>Extract the MySQL Connector/J into a directory C:\thingies.
(If you know what you are doing you will put this in your classpath.)</li>
<li>The program connects to mysql server running on my computer - the user name
and password is valid - you may use it too.</li>
<li>More examples at [http://progzoo.net/wiki/Read_From_a_Database http://progzoo.net/wiki/Read_From_a_Database]</li>
</ul>
You need to compile and execute the java from the command prompt:

<pre style="padding:1em;border-style:solid;background-color:rgb(192,192,192)">javac CIA.java
java -classpath "C:/thingies/mysql-connector-java-2.0.14;." </pre>
<pre style="padding:1em;border-style:solid;background-color:rgb(192,192,192)">/* CIA.java
From http://sqlzoo.net By Andrew Cumming
*/
import java.sql.*;
public class CIA{
public static void main(String[] args){
Connection myCon;
Statement myStmt;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
// Connect to an instance of mysql with the follow details:
// machine address: pc236nt.napier.ac.uk
// database : gisq
// user name : scott
// password : tiger
myCon = DriverManager.getConnection(
"jdbc:mysql://pc236nt.napier.ac.uk/gisq",
"scott","tiger");
myStmt = myCon.createStatement();
ResultSet result = myStmt.executeQuery(
"SELECT * FROM cia WHERE population>200000000");
while (result.next()){
System.out.println(result.getString("name"));
}
myCon.close();
}
catch (Exception sqlEx){
System.err.println(sqlEx);
}
}
}
>
</pre>
It should respond with the names of four countries.

SQL from Java - Revision history

Connor: Created page with "You can connect to an SQL engine using JDBC. You will need to obtain a JDBC driver from the appropriate database. The example given is based on the MySQL JDBC..."

Connor: Created page with "
You can connect to an SQL engine using JDBC. You will need to obtain a JDBC driver from the appropriate database.

The example given is based on the MySQL JDBC..."