JDBC处理大文本（字符读写）模板代码

 public void  insertchar(){

        Connection conn=null;

        PreparedStatement st=null;

        ResultSet rs=null;

            try {

                conn=JdbcUtils.getconnection();

                String sql=" insert into  testclob(id,resume) values(?,?)";

                st=conn.prepareStatement(sql);

                st.setString(1, "1");

                    File file=new File("src/1.txt");

                    FileReader reader=new FileReader(file);    //字符流

                    st. setCharacterStream(2, reader, (int)file.length());

                    int num=st.executeUpdate();         //executeUpdate() 的返回值类型

                if(num>0){

                    System.out.println("插入成功！！"+num);

                  }

            }catch (Exception e) {

                throw  new RuntimeException(e);

            }finally{

                JdbcUtils.release(conn, st, rs);

        }

    }

@Test

public void  readchar() throws SQLException, IOException{

        Connection conn=null;

        PreparedStatement st=null;

        ResultSet rs=null;

            try{

                conn=JdbcUtils.getconnection();

                String sql="select * from testclob";

                st=conn.prepareStatement(sql);

                rs=st.executeQuery();    

                while(rs.next()){    //字符读取模板代码 

                    Reader reader=rs.getCharacterStream("resume");

                    FileWriter writer=new FileWriter("c:\\1.txt",true);        //加true续写

                try {

                    int len=0;

                    char buffer[]=new char[1024];

                    while((len=reader.read(buffer))>0){

                    writer.write(buffer, 0, len);

                    }

                }finally{

                    if(reader!=null){

                        try {

                            reader.close();

                        } catch (Exception e) {

                            throw new RuntimeException(e);

                        }

                    }

                    if(writer!=null){

                        try {

                            writer.close();

                        } catch (Exception e) {

                            throw new RuntimeException(e);

                        }

                    }

            }

    }

}finally{

        JdbcUtils.release(conn, st, rs);

    }

}