【Java/Oracle】怎样往clob字段中写入数据

有一个表是这样的：

create table emp430_1(
    id number(12),
    name nvarchar2(20),
    profile clob,
    primary key(id)
);

其中profile是clob字段。

往这个字段连续塞入数据的程序如下：

package com.hy.lab.clob;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

class Emp{
    long id;
    String name;
    String profile;

    public Emp(long id,String name,String profile){
        this.id=id;
        this.name=name;
        this.profile=profile;
    }
}
public class ClobWriter {
    //-- 以下为连接Oracle数据库的四大参数
    private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
    private static final String URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
    private static final String USER = "luna";
    private static final String PSWD = "1234";

    public static void main(String[] args){
        List<Emp> ls=new ArrayList<>();
        ls.add(new Emp(1,"武松","双刀客"));
        ls.add(new Emp(2,"李逵","双斧头客"));
        ls.add(new Emp(3,"董平","双枪将"));
        ls.add(new Emp(4,"鲁达","扁铲发明者"));

        Connection conn = null;
        PreparedStatement pstmt = null;

        try {
            Class.forName(DRIVER);
            conn = DriverManager.getConnection(URL, USER, PSWD);
            conn.setAutoCommit(false);

            String insertSql="insert into emp430_1(id,name,profile) values(?,?,?)";
            pstmt = conn.prepareStatement(insertSql);

            for(Emp emp:ls){
                pstmt.setLong(1,emp.id);
                pstmt.setString(2,emp.name);
                Clob clob=conn.createClob();
                clob.setString(1,emp.profile);
                pstmt.setClob(3,clob);

                pstmt.addBatch();
            }

            pstmt.executeBatch();
            conn.commit();
            System.out.println("完成写入");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                pstmt.close();
                conn.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

塞入完成后看表数据：

SQL> select * from emp430_1;

        ID NAME
---------- ----------------------------------------
PROFILE
--------------------------------------------------------------------------------
         1 武松
双刀客

         2 李逵
双斧头客

         3 董平
双枪将


        ID NAME
---------- ----------------------------------------
PROFILE
--------------------------------------------------------------------------------
         4 鲁达
扁铲发明者

确如预期。

END