mac java 连接jdbc 慢_Mac上配置JDBC连接大洋数据库

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

下载：JDBC版本建议为mysql-connector-java-5.1.16

安装：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