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