Exemplo n.º 1
0
 public static void setTotal() {
   try {
     String sql =
         "select count(*) count from "
             + "(SELECT ra.fileId, ra.reviewId, ra.reviewType from "
             + "ReviewFeatureAnalysis ra group by ra.fileId, ra.reviewId)  r "
             + "where r.reviewType = 1 or r.reviewType = 2";
     System.out.println(sql);
     intTotal = Database.getInteger(sql);
   } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }
 }