AMImpl 中 执行sql语句的例子

执行更新语句的例子

  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;  }