【java/oracle】以JDBC方式向clob字段输入大文本
【建表】
create table test03( id number(3), content clob, primary key(id) )
【程序】
import java.io.BufferedReader; import java.io.FileInputStream; import java.io.InputStreamReader; import java.sql.Clob; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; public class ClobWriter { public static void main(String[] args) throws Exception{ // 四大参数 final String DRIVER = "oracle.jdbc.driver.OracleDriver"; final String URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";// sqlplus里敲show parameter service; final String USER = "luna"; final String PSWD = "1234"; Class.forName(DRIVER); Connection conn = DriverManager.getConnection(URL, USER, PSWD); String sql="insert into test03(id,content) values('1',?)"; PreparedStatement ps=conn.prepareStatement(sql); Clob clob= conn.createClob(); String text=readFromFile("c:\\hy\\twgx.txt"); clob.setString(1,text); ps.setClob(1,clob); ps.executeUpdate(); ps.close(); conn.close(); } static String readFromFile(String path) throws Exception{ BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(path), "UTF-8")); String line = null; StringBuilder sb=new StringBuilder(); while( ( line = br.readLine() ) != null ) { sb.append(line+"\n"); } br.close(); return sb.toString(); } }
【查询效果】
SQL> select * from test03; ID ---------- CONTENT -------------------------------------------------------------------------------- 1 豫章故郡,洪都新府。星分翼轸,地接衡庐。襟三江而带五湖,控蛮荆而引瓯越。物华天宝
【读出】
END