java​/jdbc

# cd /usr/local/arch
# wget http://dev.mysql.com/.../mysql-connector-java-3.0.16-ga.tar.gz/.../MySQL/
# cd ../src
# tar xvzf ../arch/mysql-connector-java-3.0.16-ga.tar.gz
# cd mysql-connector-java-3.0.16-ga
# cp mysql-connector-java-3.0.16-ga-bin.jar /home/test/WEB-INF/lib

# cd /home/test/src/com/domain/test
# vi JdbcTest.java

package com.domain.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class JdbcTest{
  public static void main(String args[]) {
    String driver="org.gjt.mm.mysql.Driver";
    String url="jdbc:mysql://localhost:3306/test";
    String username="test";
    String password="test";
    String sql="select test_name from test_data where test_id=1";
    try{
      Class.forName(driver);
      Connection conn=DriverManager.getConnection(url,username,password);
      Statement stmt=conn.createStatement();
      ResultSet rs=stmt.executeQuery(sql);
      while (rs.next()){
        String testName = rs.getString(1);
        System.out.println(testName);
      }
      rs.close();
      stmt.close();
      conn.close();
    }catch (Exception e){
      e.printStackTrace();
    }
  }
}

# cd /home/test
# ant
# export CLASSPATH=/home/test/WEB-INF/lib/mysql-connector-java-3.0.16-ga-bin.jar
# export CLASSPATH=/home/test/WEB-INF/classes:${CLASSPATH}
# java com.domain.test.JdbcTest