File file = new File("e:\\ejb.txt");
Reader fileReader = new FileReader(file);
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:scott/127.0.0.1:1243:myInstance","user","pass");String sql = "insert into table1(obj_id,content) VALUES(?,?)";
PreparedStatement ps=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_UPDATABLE );
ps.setInt(1,2) ;
ps.setCharacterStream(2 ,fileReader,file.length()) ;//ntext max 450 !
ps.executeUpdate() ;sql = "select * from table1 where obj_id= 2";
ResultSet rs=ps.executeQuery(sql);
rs.next() ;
Clob clob= rs.getClob(2) ; String read = clob.getSubString( 1,(int)clob.length());
System.out.println(read) ;
具体的把读出的内容保存到文件很简单,自己写...
这是对于clob,对于blob也一样
Reader fileReader = new FileReader(file);
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:scott/127.0.0.1:1243:myInstance","user","pass");String sql = "insert into table1(obj_id,content) VALUES(?,?)";
PreparedStatement ps=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_UPDATABLE );
ps.setInt(1,2) ;
ps.setCharacterStream(2 ,fileReader,file.length()) ;//ntext max 450 !
ps.executeUpdate() ;sql = "select * from table1 where obj_id= 2";
ResultSet rs=ps.executeQuery(sql);
rs.next() ;
Clob clob= rs.getClob(2) ; String read = clob.getSubString( 1,(int)clob.length());
System.out.println(read) ;
具体的把读出的内容保存到文件很简单,自己写...
这是对于clob,对于blob也一样
解决方案 »
- axis2发布webservice 大小写问题
- 关于MYSql数据查询问题
- 麻烦大家进来帮我看段代码!
- 请教一个问题,查询1000万数据,然后把它写入csv文件。
- javaBean 连接 SQL SERVER 2000 出错,各位高手帮帮忙,顶者有分!!!
- 菜鸟问题,请各位大哥详细解答!谢谢
- James服务器启动问题
- JSP与BEAN--当JSP中出现复选框时
- doc,caj,txt文件下载问题
- freemarker做word导出模板,模板填充内容含html标签导出的word打开就没用了怎么解决??
- 用jdbc连sqlserver2000怎么弄啊?求救啊,加倍给分!!!
- java + mysql的汉字显示问题
oracle-->file
String fileName = "";
SmartUpload upload = new SmartUpload();
upload.initialize( this.getServletConfig(), request, response );
upload.upload();
Files files = upload.getFiles();
//here can get all files that have been selected.
if(files != null && files.getCount() != 0) {
com.jspsmart.upload.File file = files.getFile(0);
String name = file.getFileName();
fileName = name; file.saveAs( fileName, com.jspsmart.upload.File.SAVEAS_PHYSICAL);
}这是取得上传的文件并保存..
然后你在按上面那样保存到数据库...
也可以不保存直接传到数据库...
PreparedStatement ps=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_UPDATABLE );
ps.setInt(1,2) ;
ps.setCharacterStream(2 ,fileReader,file.length()) ;//这一句就是把文件存入数据库拉 !
ps.executeUpdate() ;
这不是吗????
当然表的名字换成你自己的,字段换成你自己的...