以下是部分代码: sql="insert into drug (title,keyword,category,picture,pic_memo,content,station,grid,inputdate) values('"+title+"','"+keyword+"','"+arry+"','"+picture+"','"+pic_memo+"',empty_clob(),'"+station+"','"+grid+"',sysdate+"+hours+")";
try { conn=ConnectionManagerFactory.getConnectionManager().getConnection("jdbc:oracle:thin:@localhost:1521:oracle1"); conn.setAutoCommit(false); stmt=conn.createStatement(); stmt.executeUpdate(sql); //取出最大的ID,既刚刚插入记录的ID sql="select max(id) as maxid from drug"; rs=stmt.executeQuery(sql); while (rs.next()) { maxid=rs.getString("maxid"); } rs.close(); //将CLOB字段类型的数据插入到数据库中 sql="select content from drug where id='"+maxid+"' for update "; rs=stmt.executeQuery(sql); oracle.sql.CLOB clobtt=null; while(rs.next()) { clobtt = (oracle.sql.CLOB)rs.getClob(1); } java.io.Writer wr = clobtt.getCharacterOutputStream(); wr.write(content); wr.flush(); wr.close(); rs.close(); conn.commit();
sql="insert into drug (title,keyword,category,picture,pic_memo,content,station,grid,inputdate) values('"+title+"','"+keyword+"','"+arry+"','"+picture+"','"+pic_memo+"',empty_clob(),'"+station+"','"+grid+"',sysdate+"+hours+")";
try
{ conn=ConnectionManagerFactory.getConnectionManager().getConnection("jdbc:oracle:thin:@localhost:1521:oracle1");
conn.setAutoCommit(false);
stmt=conn.createStatement();
stmt.executeUpdate(sql);
//取出最大的ID,既刚刚插入记录的ID
sql="select max(id) as maxid from drug";
rs=stmt.executeQuery(sql);
while (rs.next())
{
maxid=rs.getString("maxid");
}
rs.close();
//将CLOB字段类型的数据插入到数据库中
sql="select content from drug where id='"+maxid+"' for update ";
rs=stmt.executeQuery(sql);
oracle.sql.CLOB clobtt=null;
while(rs.next())
{
clobtt = (oracle.sql.CLOB)rs.getClob(1);
}
java.io.Writer wr = clobtt.getCharacterOutputStream();
wr.write(content);
wr.flush();
wr.close();
rs.close();
conn.commit();