Mac上配置JDBC连接大洋数据库

1. 下载jdbc驱动，并安装。

1.   下载：JDBC版本建议为mysql-connector-java-5.1.16
2.   安装：sudo mv mysql-connector-java-5.1.16-bin.jar /Library/Java/Extensions/

2. 编写java代码，并保存为Da.java

import java.util.*;
import java.sql.*;

public class Da {

  public static void test4() throws SQLException{
    String dbURL = "jdbc:mysql://1.1.1.1/dbname?user=xxx&password=xxx";

    Properties props = new Properties();

    props.setProperty("characterEncoding", "utf-8");

    Connection con = DriverManager.getConnection(dbURL,props);

    Statement stmt = con.createStatement();

    stmt.executeUpdate("DROP TABLE IF EXISTS t1,t2");
    System.out.println("drop done");

    stmt.executeUpdate("create table t1 (field1 int primary key, field2 int, field3 int)");
    stmt.executeUpdate("create table t2 (field4 int primary key, field5 int, field6 int)");
    System.out.println("create done");

    stmt.executeUpdate("insert into t1 values (1,2,3)");
    stmt.executeUpdate("insert into t2 values (4, 5, 6)");
    System.out.println("insert done");

    ResultSet rs= stmt.executeQuery("select field1, field2+3, field3 f3, 'hello', 'love' v from t1");

    ResultSetMetaData tblMD = rs.getMetaData();

    for (int i = 1; i < tblMD.getColumnCount() + 1; i++) {

      System.out.println(tblMD.getColumnName(i));

      System.out.println(tblMD.getColumnLabel(i));

    }
  }

  public static void main(String[] args) throws Exception {
    // TODO Auto-generated method stub
    try{
      //加载MySql的驱动类
      Class.forName("com.mysql.jdbc.Driver") ;

    }catch(ClassNotFoundException e){
      System.out.println("找不到驱动程序类，加载驱动失败！");
      e.printStackTrace() ;
    }
    try {
      test4();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }

}

3. 编译并执行

• javac Da.java
• java Da

4. 执行结果

raywill:jdbc $ java Da
drop done
create done
insert done
field1
field1
field2+3
field2+3
field3
f3
hello
hello
v
v