oracle+jsp中blob类型存储大文本问题解决方法 oracle 存储大文本一直是一个棘手的问题。 一、存数据库: <%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% //定义变量 java.sql.Connection conn; //数据库连接对象 String sql; long id; ResultSet rs; Statement stmt,stmt1;
java.sql.DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); //装载JDBC驱动程序 conn = java.sql.DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.2:1521:lqxm","lqxm","lqxm"); //连接数据库
request.setCharacterEncoding("GBK"); String title = request.getParameter("title"); String content = request.getParameter("content"); String sort = request.getParameter("sort"); String type = request.getParameter("type"); String rq = request.getParameter("rq"); String qy = request.getParameter("qy"); //插入数据,此时blob字段中插入的是空值 sql="insert into t_flfg (xlh,title,content,rq,sort,type,qy) "; sql=sql+"Values(FLFG_SEQ.NEXTVAL,''''" + title + "'''',empty_clob(),''''" + rq + "'''',''''" + sort + "'''',''''" + type + "'''',''''" + qy + "'''')"; stmt=conn.createStatement(); stmt.executeUpdate(sql); conn.commit();
conn.setAutoCommit(false); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //取得刚才插入的ID sql="select max(xlh) as xlh from t_flfg "; rs=stmt.executeQuery(sql); if(rs.next()) { id=rs.getInt("xlh"); } rs.close();
sql = "select content from t_flfg where xlh="+id+" for update"; rs = stmt.executeQuery(sql); if (rs.next()) { oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob(1); clob.putString(1, content); sql = "update t_flfg set content=? where xlh=" + id + ""; //将大文本更新进去,呵呵 PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setClob(1, clob); pstmt.executeUpdate(); }
conn.commit(); stmt.close(); conn.close(); %>
二、检索显示数据: <% ResultSet rs = flfgSave.searchOneInfo(request.getParameter("xlh")); //查询数据库获取记录集 rs.next();
int y; String content = ""; oracle.sql.CLOB clob1; char ac[] = new char[299];
String title = rs.getString("title");
clob1 = (oracle.sql.CLOB)rs.getObject("content"); Reader reader = clob1.getCharacterStream(); while((y = reader.read(ac, 0, 299)) != -1) content += new String(ac, 0, y); //这就是取出来的大文本 %>
[Web开发]JSP入门学习经验总结 [Web开发]JSP 2.0下的动态内容缓存分析讲解 [Web开发][JSP] 循序渐进教程 [Web开发]纯 jsp 操作服务器上的文本文件 [Web开发]JSP: 调用servlet 显示图片 [Web开发]Jsp + JavaBean循序渐进教程(二) [Web开发]Jsp + JavaBean循序渐进教程(三) [Web开发]Jsp + JavaBean循序渐进教程(四)上 [Web开发]Jsp + JavaBean循序渐进教程(四)下 [Web开发]Jsp + JavaBean循序渐进教程(一)
|