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);
}
}
}
大对象ClobTest
最新推荐文章于 2022-02-25 23:02:56 发布