sql = new StringBuffer();
sql.append(" INSERT INTO a(");
sql.append(" ID, Detail");
sql.append(" ) VALUES (");
sql.append(" '" + ID + "',");
sql.append(" EMPTY_CLOB()");
sql.append(" )");
database.executeUpdate(new String(sql)); sql = new StringBuffer();
sql.append(" SELECT DETAIL FROM a");
sql.append(" WHERE ID = '" + ID + "'");
rs = database.executeQuery(new String(sql));
if(rs.next()){
clob_Detail = (CLOB)rs.getClob("Detail");
Writer writer = clob_Detail.getCharacterOutputStream();
writer.write(Detail);
writer.flush();
writer.close();
}
sql.append(" INSERT INTO a(");
sql.append(" ID, Detail");
sql.append(" ) VALUES (");
sql.append(" '" + ID + "',");
sql.append(" EMPTY_CLOB()");
sql.append(" )");
database.executeUpdate(new String(sql)); sql = new StringBuffer();
sql.append(" SELECT DETAIL FROM a");
sql.append(" WHERE ID = '" + ID + "'");
rs = database.executeQuery(new String(sql));
if(rs.next()){
clob_Detail = (CLOB)rs.getClob("Detail");
Writer writer = clob_Detail.getCharacterOutputStream();
writer.write(Detail);
writer.flush();
writer.close();
}
老大,我很菜啊,不要这样啊我只想知道图形界面下可以管理CLOB吗?
还有怎么向CLOB里插长数据
那我插不了长数据是为什么呢?
我用的是EL和JSTL的JSP语法