@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));
}
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(),
});
}