Spring DAO的一个小例子

采用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;
	}

}