package cabby;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * 批处理演示
 * @author Cabby
 *
 */
public class BatchDemo {
    public static void main(String[] args) {
        batchSql();
    }
    public static void batchSql(){
        String sql="insert into mytemp_xxx(id) values(?)";
        Connection conn=null;
        PreparedStatement stmt=null;
        try {
            conn=JDBCUtil.getConnection();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        try {
            conn.setAutoCommit(false);
            stmt=conn.prepareStatement(sql);
            for(int i=1;i
ITPub博客

oracle数据库批处理演示

最新文章
