DButils实现clob和blob存储

来源：互联网发布：js下载文件到本地编辑：程序博客网时间：2024/06/08 15:30

//使用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); }

转自网络，原作者佚名

0 0