Example #1
0
 public static PreparedStatement prepareLoadByID(Connection cxn) throws SQLException {
   return cxn.prepareStatement(
       "select id, mapping, name1, genome1, name2, genome2 from orth_pair " + "where id=?");
 }
Example #2
0
 public static PreparedStatement prepareLoadBySecondNameGenomeWithMapping(Connection cxn)
     throws SQLException {
   return cxn.prepareStatement(
       "select id, mapping, name1, genome1, name2, genome2 from orth_pair "
           + "where name2=? and genome2=? and mapping=?");
 }
Example #3
0
 public static PreparedStatement prepareInsertStatement(Connection cxn) throws SQLException {
   return cxn.prepareStatement(
       "insert into orth_pair (id, mapping, name1, genome1, name2, genome2) values "
           + "(?, ?, ?, ?, ?, ?)");
 }
Example #4
0
 public static PreparedStatement prepareDeleteStatement(Connection cxn) throws SQLException {
   return cxn.prepareStatement("delete from orth_pair where id=?");
 }
Example #5
0
 public static PreparedStatement createReadByVersion(Connection cxn) throws SQLException {
   return cxn.prepareStatement(
       "select fa.object, fa.category from func_assignment fa, "
           + "func_category fc where fa.category=fc.id and fc.version=?");
 }
Example #6
0
 public static PreparedStatement createReadByCategory(Connection cxn) throws SQLException {
   return cxn.prepareStatement(
       "select object, category from func_assignment " + "where category=?");
 }
Example #7
0
 public static PreparedStatement prepareInsert(Connection cxn) throws SQLException {
   return cxn.prepareStatement(
       "insert into func_assignment (object, category) " + "values (?, ?)");
 }