安装部署（二） Ubuntu 安装配置 MySQL Connector Java

Ubuntu 安装配置 mysql connector java 

ubuntu 14.04.04 x64

jdk 1.8.0_101

mysql 5.7.14

下载MySQL Connector/J
http://dev.mysql.com/doc/connector-j/5.1/en/connector-j-installing.html
tar xvzf mysql-connector-java-5.1.39.tar.gz
cp mysql-connector-java-5.1.39-bin.jar到以下目录
${JAVA_HOME}/lib
${JAVA_HOME}/jre/lib/ext


环境bash.rc的配置如下
export JAVA_HOME=/usr/lib/java/jdk1.8.0_101
export JRE_HOME=${JAVA_HOME}/jre
export CLASS_PATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib


使用：
import java.sql.*;


public class SqlTest {
public static void main(String[] args) throws Exception {
try {
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://192.1.1.16/stockdata";
String user="root";
String password="fm1106";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from `603999`";
ResultSet res=stmt.executeQuery(sql);
while(res.next())
System.out.println(res.getString("date")+"\t"+res.getString("open"));
res.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}


javac SqlTest.java
java SqlTest


配置参考：
http://www.cnblogs.com/youxin/archive/2012/09/30/2709286.html
http://dev.mysql.com/doc/connector-j/5.1/en/connector-j-installing.html
http://blog.sina.com.cn/s/blog_89af328301015a57.html
使用参考：
http://blog.sina.com.cn/s/blog_8af1069601019wjv.html
http://jingyan.baidu.com/article/a3761b2bbbfc2f1577f9aa54.html
http://www.cnblogs.com/taoweiji/archive/2012/12/11/2812852.html