JDBC批量插入

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import org.jfree.util.Log;

public class JDBCInsert {

public static void main(String[] args) {

Connection con = null;

Statement stat = null;

int i = 9;

String sql = "";

try {

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

con = DriverManager.getConnection(

"jdbc:oracle:thin:@116.11.11.11:1521:orcl", "root",

"root");

stat = con.createStatement();

for (i = 9; i < 100; i++) {

                                sql="。。。。。。";

stat.execute(sql);

}

Log.info("插入完成");

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

if (con != null) {

// 如果con一开始就是null的话，如果不判断就一直出SQL异常，所以应该先判断一下

con.close();

con = null;

}

if (stat != null) {

stat.close();

stat = null;

}

} catch (Exception e) {

e.printStackTrace();

}

}

}

}