- <%@ page import="java.io.*"%>
- <%@ page import="oracle.sql.CLOB"%>
- <%
- try
- {
- Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
- int imgId=23;
- String url="jdbc:oracle:thin:@localhost:1521:ORCL";
- Connection conn=DriverManager.getConnection(url,"system","oracle");
- conn.setAutoCommit(false);
- Statement st = conn.createStatement();
- /* 查询CLOB对象 */
- ResultSet rs = st.executeQuery("SELECT filestr FROM hr.psn WHERE ID="+imgId+"");
- conn.commit();
- if(rs.next())
- {
- /* 获取CLOB对象 */
- oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob("filestr");
- /* 以字符形式输出 */
- BufferedReader in = new BufferedReader(clob.getCharacterStream());
- BufferedWriter outt = new BufferedWriter(new FileWriter("d://2.mht"));//文件下载位置
- int c;
- while ((c=in.read())!=-1)
- {
- outt.write(c);
- }
- outt.close();
- in.close();
- }
- conn.commit();
- conn.close();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- %>
JSP Oralcle CLOB 文件读取
最新推荐文章于 2021-04-11 06:15:40 发布