向oracle資料庫中插入xml資料

//插入圖層中繼資料
 public  static  boolean  insertLayerMetadata(DataSource ds,String xml,String id)throws SQLException,ClassNotFoundException{
  boolean flag=false;
  String metadataTableName=DBUtil.getLayerMetadataTableName(ds);
  StringBuffer sql = new StringBuffer("INSERT INTO ");
  sql.append(metadataTableName).append("(RECORDID, DATACOL) values(?, ?)");
  try{
     Connection con=DBUtil.getConnection(ds);  
     logger.info("excute sql:"+sql.toString());
     PreparedStatement prest = con.prepareStatement(sql.toString());
     XMLType poXML = XMLType.createXML(con, xml);
     prest.setString(1, id);
     prest.setObject(2, poXML);
     prest.execute();
     flag=true;
  }
  catch(SQLException e){
   flag=false;
   logger.info(e);
   throw new SQLException(e);
  }catch(ClassNotFoundException e){
   flag=false;
   logger.info(e);
         throw new ClassNotFoundException(e.getMessage());
  }
  return flag;
 };

轉載請註明出處，歡迎交流！http://www.cnblogs.com/likehua