public static PreparedStatement prepareLoadByID(Connection cxn) throws SQLException {
return cxn.prepareStatement(
"select id, mapping, name1, genome1, name2, genome2 from orth_pair " + "where id=?");
}
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=?");
}
public static PreparedStatement prepareInsertStatement(Connection cxn) throws SQLException {
return cxn.prepareStatement(
"insert into orth_pair (id, mapping, name1, genome1, name2, genome2) values "
+ "(?, ?, ?, ?, ?, ?)");
}
public static PreparedStatement prepareDeleteStatement(Connection cxn) throws SQLException {
return cxn.prepareStatement("delete from orth_pair where id=?");
}
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=?");
}
public static PreparedStatement createReadByCategory(Connection cxn) throws SQLException {
return cxn.prepareStatement(
"select object, category from func_assignment " + "where category=?");
}
public static PreparedStatement prepareInsert(Connection cxn) throws SQLException {
return cxn.prepareStatement(
"insert into func_assignment (object, category) " + "values (?, ?)");
}