救命呀!jsp 弄好了,传给一现在的大片!金刚,千里走单骑 好几部任你选!(100分)

Z

zxf_1

Unregistered / Unconfirmed
GUEST, unregistred user!
/**查询CLOB类型值*/
public String QueryCLOB(String table, String wherestr, String clobfield)
{
String out = "";
try
{
String sqlCommand = "select "
+ clobfield + "
from "
+ table;
if(!wherestr.equals(""))
{
sqlCommand += "
where "
+ wherestr;
}
pstm = conn.prepareStatement(sqlCommand);
rs = pstm.executeQuery();
if(rs.next())
{
oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob(clobfield);
if(clob != null)
{
Reader is = clob.getCharacterStream();
BufferedReader br = new BufferedReader(is);
String s = br.readLine();
while(s != null)
{
out += s;
s = br.readLine();
}
}
}
rs.close();
pstm.close();
//out = (new DealString()).Replace(out,"/"","/"/"");
}
catch(SQLException sqle)
{
System.out.println("调用MyDataBase.QueryCLOB()函数错误:/r/n"
+ sqle);
}
catch(IOException iosql)
{
System.out.println("调用MyDataBase.QueryCLOB()函数错误:/r/n"
+ iosql);
}
return out;
}
这是报错结果
张小峰工作QQ(267456602) (2006-01-24 11:12:16)
Note: sun.tools.javac.Main has been deprecated.
E:/jsp/WEB-INF/classes/com/ideas/bean/DataBase.java:712: Class oracle.sql.CLOB
not found.

这段如何改成MYSQL的!
 
金刚,千里走单骑。。。。
 
以下是全部的,是飞思书上代码,奶奶的,说是MYSQL,结果这儿是ORCAL,谁要把全部改成MYSQL,定送好礼!
 
自己搞定!
 
帮顶!
http://www.source520.com
站长开发推广同盟 站长朋友的终极驿站
同时拥有海量源码电子经典书籍下载
http://www.source520.com/search/search.asp
"编程.站长"论坛搜索引擎-----为中国站长注入动力!
 
MySQL支持大对象?你自己慢慢研究
 
多人接受答案了。
 
顶部