采用SpringDAO自身的数据库处理类。
import javax.sql.DataSource;
@Service
@Transactional
public class AuditReportExecuteManagerImpl extends JdbcDaoSupport implements
AuditReportExecuteManager {
@Autowired
public void init(DataSource ds) {//spring容器会发现这里需要被注入,自动的把容器提供的类的实例(DataSource)注入到这里来。供程序使用。
setDataSource(ds);
}
@Autowired
private DbUserManager dbUserManager;
@Autowired
private ApplicationManager applicationManager;
@SuppressWarnings("unchecked")
public List<TypeReport4> getListForTypeRepor4(String sql) {
JdbcTemplate template = getJdbcTemplate();
List<TypeReport4> list = template.query(sql, new TypeRowMapper4());
return list;
}
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;
import com.hzmc.capaa.domain.persistence.report.TypeReport4;
public class TypeRowMapper4 implements RowMapper {
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
TypeReport4 report = new TypeReport4();
report.setDbId(rs.getBigDecimal("DBID"));
report.setCnt(rs.getInt("CNT"));
return report;
}
}