//使用dbutils实现大文本对象的存储.
@Test
public void testClob() throws Exception{
String sql="insert into article (content)values(?)";
File file=new File("bin/stylesheet.css");
char[] c=new char[(int)file.length()];
FileReader reader=new FileReader(file);
reader.read(c);
SerialClob clob=new SerialClob(c);
QueryRunner runner=new QueryRunner(JDBCUtils.getDataSource());
runner.update(sql, clob);
}
//使用dbutils实现二进制对象的存储.
@Test
public void testBlob() throws Exception{
String sql="insert into image (content)values(?)";
File file=new File("bin/bg.jpg");
byte[] b=new byte[(int)file.length()];
InputStream in=new FileInputStream(file);
in.read(b);
SerialBlob blob=new SerialBlob(b);
QueryRunner runner=new QueryRunner(JDBCUtils.getDataSource());
runner.update(sql,blob);
}
转自网络,原作者佚名