处理Clob数据

事先在MySQL中准备好表：

CREATE TABLE userclob(
    id      INT            AUTO_INCREMENT    PRIMARY KEY,
    name    VARCHAR(30)    NOT NULL,
    note    LONGTEXT  
);

一、写入Clob数据

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class ClobDemo01{
	//MySQL数据库驱动
	public static final String DBDRIVER="com.mysql.cj.jdbc.Driver";
	//MySQL数据库的连接地址
	public static final String DBURL="jdbc:mysql://localhost:3306/mldn?useSSL=false&serverTimezone=UTC";
	//MySQL数据库的连接用户名
	public static final String DBUSER="root";
	//MySQL数据库的连接密码
	public static final String DBPASS="root";

	public static void main(String[] args) throws Exception{
		//1.加载数据库驱动
		Class.forName(DBDRIVER);
		//2.获取数据库连接
		Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
		//3.实例化PreparedStatement对象，并且设置参数
		String sql="INSERT INTO userclob(name,note) VALUES(?,?)";
		PreparedStatement pstmt=conn.prepareStatement(sql);
		pstmt.setString(1,"张三");
		File f=new File("e:"+File.separator+"demo.txt");
		InputStream input=new