MySql 一边读一边写

1：首先创建一个表clob_test;

create table clob_test(id integer primary key,info text);

insert into clob_test(id,info)values(1,'iisdSDFSD');

2:编写程序

import org.junit.Test;

public class ClobTest {
 @Test
 public void insertText()throws SQLException,FileNotFoundException{
  Connection conn=null;
  PreparedStatement ptmt=null;
  ResultSet rs=null;
  try{
   conn=JdbcYh.getConnect();
   String sql="insert into clob_test(id,info)values(?,?)";
   ptmt=conn.prepareStatement(sql);
   ptmt.setInt(1,10);
   File file=new File("D:\\cs\\jdbc\\dssreader.txt");
   FileReader freader=new FileReader(file);
   BufferedReader buffer=new Buf