oracle建立批量连接,jdbc 连接数据库、批量操作、事务（oracle、mysql）

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class JdbcUtil

{

public static final String USERNAME = "root";

public static final String PASSWORD = "root";

public static final String URL = "jdbc:oracle:thin:@192.168.2.1:1521:orcl";

static

{

try

{

Class.forName("oracle.jdbc.driver.OracleDriver");

}

catch (ClassNotFoundException e)

{

e.printStackTrace();

}

}

public static Connection getConnection()

{

Connection conn = null;

try

{

conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);

}

catch (SQLException e)

{

e.printStackTrace();

}

return conn;

}

public static void closeConnection(ResultSet rs, PreparedStatement ps, Connection conn)

{

try

{

if (rs != null)

{

rs.close();

}

}

catch (Exception e)

{

// TODO: handle exception

}

finally

{

try

{

if (ps != null)

{

ps.close();

}

}

catch (Exception e2)

{

// TODO: handle exception

}

finally

{

try

{

if (conn != null)

{

conn.close();

}

}

catch (SQLException e)

{

e.printStackTrace();

}

}

}

}

}

Java JDBC Thin Driver 连接 Oracle 三种方法说明 http://www.cnblogs.com/zhangliang0115/archive/2012/02/18/2357097.html

JDBC连接MySQL http://www.cnblogs.com/cy163/archive/2008/08/22/1274413.html

JDBC批处理 http://blog.csdn.net/wfgeqgeq/article/details/6783930

JDBC事务控制 http://blog.csdn.net/wfgeqgeq/article/details/6778777

JDBC事务与批量处理(转载) http://junxiangzheng.iteye.com/blog/939762