执行更新语句的例子
public void updateExamHourFromUser(){
String sql = " update exam_single s set s.finish_hours = (select sum(h.fill_hour) from exam_single_hour h where s.id = h.exam_single_id ) ";
ResultSet rs = null;
DBTransaction db = this.getDBTransaction();
PreparedStatement ps = db.createPreparedStatement(sql, 0);
try {
ps.execute();
db.commit();
ps.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
this.getExamSingleView2().executeQuery();
return ;
}
执行查询语句的例子:
public boolean isExamUserExistInProject(String projectId,String userId){
String querySQL = " select * from exam_single t where project_id = '"+projectId+"' and user_id = '"+userId+"' ";
ResultSet rs = null;
DBTransaction db = this.getDBTransaction();
boolean flag = false;
//
PreparedStatement ps = db.createPreparedStatement(querySQL, 0);
try {
rs = ps.executeQuery();
while (rs.next()) {
if( rs.getString("Id")!=null){
flag = true;
}
}
} catch (SQLException ex) {
ex.printStackTrace();
db.closeTransaction();
}
return flag;
}