With terminal I have :
CLASSPATH=/System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Classes/:/Library/Java/Extensions/:./
SUDO_GID=20
SECURITYSESSIONID=210800
_=/usr/bin/printenv
127:/Library/WebServer/Documents/Java root# java TestMySQL
2006-05-21 13:39:00.0 ************************** = OK
127:/Library/WebServer/Documents/Java root#
with
import java.sql.*; /** * mysql-connector-java-3.1.12-bin.jar * */ /** * % javac /Library/WebServer/Documents/Java/TestMySQL.java * % java -classpath /usr/local/lib/mysql/mysql-connector-java-3.1.12-bin.jar:. TestMySQL */ public class TestMySQL { public static void main(String argv[]) throws Exception { // Load the driver class // Class.forName("org.gjt.mm.mysql.Driver"); //Class theClass = null; //try { // theClass = Thread.currentThread().getContextClassLoader().loadClass("org.gjt.mm.mysql.Driver"); //} //catch (ClassNotFoundException e) { // theClass = getClass().getClassLoader().loadClass("org.gjt.mm.mysql.Driver"); //} Connection conn = DriverManager.getConnection( "jdbc:mysql:///test", "", "" ); Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("SELECT now();"); while (rset.next()) { System.out.println(rset.getString(1)); } // Close result set, statement and DB connection // rset.close(); stmt.close(); conn.close(); } }
P.S. This my first approach to java/mysql but I would like to see this short program running on my local web server ...
Thanks.