예제 #1
0
 @SuppressWarnings({"unchecked", "rawtypes"})
 public static List<DoctorReport> findDoctorReportByDoctrorReportId(
     DoctorReport clazz, String status, JdbcTemplate jdbc) throws DataAccessException {
   if (status == null) {
     status = "ACTIVE";
   }
   String sql = "select * from DoctorReportwhere 0= ? and doctror_report_id = ?";
   return jdbc.query(
       sql,
       new Object[] {status, clazz.getDoctrorReportId()},
       new DocBeanPropertyMapper(DoctorReport.class));
 }
예제 #2
0
 public static int insertDoctorReport(DoctorReport clazz, JdbcTemplate jdbc)
     throws DataAccessException {
   String sql =
       "insert into DoctorReport(total_search ,total_success ,total_booking ,"
           + "date ,createddate ,modifiddate ,"
           + ") values (?,?,?,?,?,?)";
   return jdbc.update(
       sql,
       new Object[] {
         clazz.getTotalSearch(),
         clazz.getTotalSuccess(),
         clazz.getTotalBooking(),
         clazz.getDate(),
         clazz.getCreateddate(),
         clazz.getModifiddate(),
       });
 }