indexdatadaoimpl.java

用户模块和指标模块等等,还有其它的模块吧

package com.srit.gcz.dao.impl;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapperResultSetExtractor;

import com.srit.gcz.bean.IndexData;
import com.srit.gcz.bean.rowmapper.IndexDataRowMapper;
import com.srit.gcz.dao.IndexDataDao;
import com.srit.gcz.util.SysConstant;

/**
 * 指标数据
 * @Company 国研科技
 * @author 陈鹏昊
 * @date 2009-3-24
 * @version 1.0
 * @since 1.0
 */
public class IndexDataDaoImpl implements IndexDataDao{
	// 查询某指标数据
	private static final String QUERY_INDEXDATA = "SELECT * FROM "+SysConstant.TABLE_INDEX_DATA+" WHERE ID = ?";
	// 查询某些指标数据
	private static final String QUERY_SOME_INDEXDATE = "SELECT * FROM "+SysConstant.TABLE_INDEX_DATA+" WHERE INDEXID = ? AND FREQUENCYID = ? AND AREAID = ? AND STATID = ? AND YEAR BETWEEN ? AND ?";
	// 新增指标数据
	private static final String INSERT_INDEXDATA = "INSERT INTO "+SysConstant.TABLE_INDEX_DATA+"(ID, INDEXID, FREQUENCYID, STATID, YEAR, FREQUENCYATT, AREAID, INDEXVALUE, STARDATE, ENDDATE) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
	// 更新指标数据
	private static final String UPDATE_INDEXDATA = "UPDATE "+SysConstant.TABLE_INDEX_DATA+" SET INDEXVALUE = ? WHERE ID = ?";
	// 删除指标数据
	private static final String DELETE_INDEXDATA = "DELETE FROM "+SysConstant.TABLE_INDEX_DATA+" WHERE ID = ?";
	// Srping注入
	private JdbcTemplate jdbcTemplate;
	
	public boolean delete(IndexData bean) {
		int operMark = jdbcTemplate.update(DELETE_INDEXDATA,
				new Object[] {bean.getId()});
		return (operMark > 0) ? true : false;
	}

	public IndexData getIndexDataByID(int ID) {
		IndexData bean = (IndexData) jdbcTemplate.queryForObject(QUERY_INDEXDATA, new Object[] { ID },
				new IndexDataRowMapper());
		return bean;
	}

	@SuppressWarnings("unchecked")
	public List<IndexData> getIndexDatas(String sql, Object[] param) {
		Object obj = jdbcTemplate.query(sql, param, new RowMapperResultSetExtractor(new IndexDataRowMapper()));
		return (List<IndexData>)obj;
	}

	public boolean save(IndexData bean) {
		int operMark = jdbcTemplate.update(INSERT_INDEXDATA,
				new Object[] {bean.getId(), bean.getIndexId(), bean.getFrequencyId(), bean.getStatId(), bean.getYear(), bean.getFrequencyAtt(), bean.getAreAid(), bean.getIndexValue(), bean.getStarDate(), bean.getEndDate()});
		return (operMark > 0) ? true : false;
	}

	public boolean update(IndexData bean) {
		int operMark = jdbcTemplate.update(UPDATE_INDEXDATA,
				new Object[] {bean.getIndexValue(), bean.getId()});
		return (operMark > 0) ? true : false;
	}

	@SuppressWarnings("unchecked")
	public List<IndexData> getIndexDatas(int IID, int FID, int DID, int SID,
			String sDate, String eDate) {
		Object obj = jdbcTemplate.query(QUERY_SOME_INDEXDATE, new Object[]{IID, FID, DID, SID, sDate, eDate}, new RowMapperResultSetExtractor(new IndexDataRowMapper()));
		return (List<IndexData>)obj;
	}
	
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}