java批量插入数据到Oracle

  public static void insertDataItem(Connection conn,List<Map<String,String>> data){
    	PreparedStatement pst=null;
    	try {
    		conn.setAutoCommit(false);
    		String sql="insert into t_res_dataitem(ID,NAME_EN,NAME_CN,DATA_TYPE,LENGTH,DE_IDENTIFIER) values(?,?,?,?,?,?)";
    		pst=conn.prepareStatement(sql);
    		for(Map<String,String> row:data){
    			pst.setString(1,row.get("0"));
    			pst.setString(2,row.get("1"));
    			pst.setString(3,row.get("2"));
    			pst.setString(4,row.get("3"));
    			pst.setString(5,row.get("4"));
    			pst.setString(6,row.get("5"));
    			pst.addBatch();
    		}
    		pst.executeBatch();
    		conn.commit();
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			close(null, pst, conn);
		}
    	
    }


版权声明:本文为LinBilin_原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。