大对象ClobTest

package com.jdbctest.clobtest;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import java.sql.*;

import com.jdbctest.Util.JDBCUtil;

public class ClobTest {
		public static void main(String args[]){
			Connection conn = null;
			Statement stmt = null;
			PreparedStatement ps = null;
			ResultSet rs = null;
			
			//获取数据库对象
			conn = JDBCUtil.getConnection();
			//表存在则删除它
			String sql = "DROP TABLE IF EXISTS clobtest";
			
			try {
				stmt = conn.createStatement();
				System.out.println(sql);
				stmt.executeUpdate(sql);
				//创建表
				sql = "CREATE TABLE clobtest(" + 
				"c_id INT NOT NULL AUTO_INCREMENT,"+
				"c_title VARCHAR(50),"+
				"c_text TEXT,"+
				"PRIMARY KEY(c_id)"+
				")";
			System.out.println(sql);
			stmt.executeUpdate(sql);
			System.out.println("创建数据表成功!");
			//插入记录
			sql = "INSERT INTO clobtest(c_title,c_text) VALUES(?,?)";
			ps = conn.prepareStatement(sql);
			File file = new File("D:\\wuyu\\JDBCUtil.java");
			InputStream inputStream = new FileInputStream(file);
			ps.setString(1, file.getName());
			//设置clob参数
			ps.setAsciiStream(2, inputStream,file.length());
			ps.executeUpdate();
			System.out.println("插入数据成功！");
			
			//读取数据
			sql ="SELECT c_title,c_text FROM clobtest";
			
			ps =conn.prepareStatement(sql);
			rs = ps.executeQuery();
			if(rs.next()){
				System.out.println("文件名: "+rs.getString("c_title"));
				Clob clob = rs.getClob("c_text");//(int)clob.length())
				System.out.println("文件内容: \n"+clob.getSubString(1,1000));
			}
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (FileNotFoundException e) {
				e.printStackTrace();
			}finally{
				JDBCUtil.close(rs, stmt, conn);
			}
			
		}

}