Oracle的Clob字段一般的数据库系统没有。它的读方法也有些不同。下面是一段读的代码包括了JavaBean的数据库连接和Clob的实现方法:
1 db.java连接数据库的JavaBean:
package user;
import java.sql.*;
public class db {
public db() {
}
Connection conn = null ;
//设置你的数据库用户名和密码:
String user="system";
String password="manager";
public java.sql.Connection getConn(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@sun:1521:OIL";
conn= DriverManager.getConnection(url,user,password);
}
catch(Exception e){
e.printStackTrace();
}
return this.conn ;
}
}
2 clob.jsp部分代码:
Connection conn = user.getConn() ;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ;
String sql="select * from clobtest where clob_id='"+clob_id+"' and dates='"+dates+"'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob("fieldone");
if (! (null==clob || clob.length() == 0))
{
clobText = clob.getSubString((long)1,(int)clob.length());
xValue=clobText;
}
oracle.sql.CLOB clob1 = (oracle.sql.CLOB)rs.getClob("fieldtwo");
if (! (null==clob1 || clob1.length() == 0))
{
clobText1 = clob1.getSubString((long)1,(int)clob1.length());
yValue=clobText1;
}
}