[cob-editor] COBEditor/src/edu/iastate/ato/po DB2OWL.java,1.1,1.2

[Jie B. <ba...@us...>]

Update of /cvsroot/cob/COBEditor/src/edu/iastate/ato/po
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv21525/src/edu/iastate/ato/po

Modified Files:
	DB2OWL.java 
Log Message:


Index: DB2OWL.java
===================================================================
RCS file: /cvsroot/cob/COBEditor/src/edu/iastate/ato/po/DB2OWL.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** DB2OWL.java	13 Jun 2006 21:55:24 -0000	1.1
--- DB2OWL.java	16 Aug 2007 03:50:20 -0000	1.2
***************
*** 157,160 ****
--- 157,161 ----
                      String is_obsolete = resultSet.getString("is_obsolete") ;
  
+                     id = id.replace(" ", "_");
                      out.write("<Term rdf:ID=\"" + id + "\">\n") ;
  
***************
*** 190,205 ****
                          out.write(str) ;
                      }
! 
!                     // SELECT DISTINCT relation, term.id AS parent FROM relation
!                     // WHERE id = '59056' AND relation.pid = term.oid
                      sql =
!                         "SELECT DISTINCT relation, term.id AS parent FROM relation " +
!                         "WHERE id = '" + oid + "' AND relation.pid = term.oid" ;
                      Statement stmt2 = db.createStatement() ;
                      ResultSet resultSet2 = stmt2.executeQuery(sql) ;
                      while(resultSet2.next())
                      {
!                         String relation = resultSet2.getString("relation") ;
                          String parent = resultSet2.getString("parent") ;
  
                          str = makeTerm_Relation(relation, parent) ;
--- 191,210 ----
                          out.write(str) ;
                      }
!                     
!                     // write parents
!                     //SELECT DISTINCT relation, term.id AS parent FROM relation,term 
!                     //WHERE relation.id = '27291' AND relation.pid = term.oid
!                     
                      sql =
!                         "SELECT DISTINCT relation, term.id AS parent FROM relation,term " +
!                         "WHERE relation.id = '" + oid + "' AND relation.pid = term.oid" ;
                      Statement stmt2 = db.createStatement() ;
                      ResultSet resultSet2 = stmt2.executeQuery(sql) ;
                      while(resultSet2.next())
                      {
!                         String relation = resultSet2.getString("relation");
                          String parent = resultSet2.getString("parent") ;
+                         parent = parent.replace(" ", "_");
+                         
  
                          str = makeTerm_Relation(relation, parent) ;