Oracle处理CLOB超过4000入库问题（2）

最新推荐文章于 2023-03-31 12:53:03 发布

小江_xiaojiang

最新推荐文章于 2023-03-31 12:53:03 发布

阅读量4k

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/jiangsanfeng1111/article/details/51833117

版权

接上一篇转载的Oracle处理CLOB超过4000入库问题，同事用我的写的代码，说仍出现问题，后面写了另一种方法，在这里做一个记录，以便以后学习。

先把需求简要提出来：

public String toInsertSql(){
		String sql="insert into TB_NEWS ("+
		"title,"+
		"publictime,"+
		"source,"+
		"abstract,"+
		"content,"+
		"url,"+
		"infodate,"+
		"author,"+
		"hits,"+
		"expand,"+
		"createtime,"+
		"modifytime"+
		") "+
		"values (";
		if(this.getTitle() == null){
			sql += "'',";
		}else{
			sql += "'"+this.getTitle().replaceAll("'", "")+"'"+",";
		}
		if(this.getPublictime() == null){
			sql += "'',";
		}else{
			sql += "'"+this.getPublictime().replaceAll("'", "")+"'"+",";
		}
		if(this.getSource() == null){
			sql += "'',";
		}else{
			sql += "'"+this.getSour