indexdimmemberdaoimpl.java.svn-base

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

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.IndexDimMember;
import com.srit.gcz.bean.rowmapper.IndexDimMemberRowMapper;
import com.srit.gcz.dao.IndexDimMemberDao;
import com.srit.gcz.util.SysConstant;

/**
 * 维度成员
 * @Company 国研科技
 * @author 陈鹏昊
 * @date 2009-3-24
 * @version 1.0
 * @since 1.0
 */
public class IndexDimMemberDaoImpl implements IndexDimMemberDao{
	// 查询某成员
	private static final String QUERY_DIMMEMBER = "SELECT * FROM "+SysConstant.TABLE_INDEX_DIMMEMBER+" WHERE ID = ?";
	// 查询某维度所有成员
	private static final String QUERY_REL_DIMMEMBER  = "SELECT b.* FROM "+SysConstant.TABLE_INDEX_DIM+" A,"+SysConstant.TABLE_INDEX_DIMMEMBER+" B WHERE A.ID = B.DIMID AND B.DIMID = ?";
	// 新增维度成员
	private static final String INSERT_DIMMEMBER = "INSERT INTO "+SysConstant.TABLE_INDEX_DIMMEMBER+"(ID, DIMID, PARENTID, MEMBERCODE, MEMBERNAME, STATE) VALUES(?, ?, ?, ?, ?, ?)";
	// 更新维度成员
	private static final String UPDATE_DIMMEMBER = "UPDATE "+SysConstant.TABLE_INDEX_DIMMEMBER+" SET MEMBERCODE = ?, MEMBERNAME = ?, STATE = ? WHERE ID = ?";
	// 更新维度成员状态
	private static final String UPDATE_STATE_DIMMEMBER = "UPDATE "+SysConstant.TABLE_INDEX_DIMMEMBER+" SET STATE = ? WHERE ID = ?";
	// 删除维度成员
	private static final String DELETE_DIMMEMBER = "DELETE FROM "+SysConstant.TABLE_INDEX_DIMMEMBER+" WHERE ID = ?";
	// Srping注入
	private JdbcTemplate jdbcTemplate;

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

	public IndexDimMember getIndexDimMemberByID(int ID) {
		IndexDimMember bean = (IndexDimMember) jdbcTemplate.queryForObject(QUERY_DIMMEMBER, new Object[] { ID },
				new IndexDimMemberRowMapper());
		return bean;
	}

	@SuppressWarnings("unchecked")
	public List<IndexDimMember> getIndexDimMembersByDimID(int ID) {
		Object obj = jdbcTemplate.query(QUERY_REL_DIMMEMBER, new Object[] { ID }, new RowMapperResultSetExtractor(new IndexDimMemberRowMapper()));
		return (List<IndexDimMember>)obj;
	}

	public boolean save(IndexDimMember bean) {
		int operMark = jdbcTemplate.update(INSERT_DIMMEMBER,
				new Object[] {bean.getId(), bean.getDimId(), bean.getParentId(), bean.getMemberCode(), bean.getMemberName(), bean.getState()});
		return (operMark > 0) ? true : false;
	}

	public boolean update(IndexDimMember bean) {
		int operMark = jdbcTemplate.update(UPDATE_DIMMEMBER,
				new Object[] {bean.getMemberCode(), bean.getMemberName(), bean.getId()});
		return (operMark > 0) ? true : false;
	}
	
	public boolean updateState(IndexDimMember bean) {
		int operMark = jdbcTemplate.update(UPDATE_STATE_DIMMEMBER,
				new Object[] {bean.getState(), bean.getId()});
		return (operMark > 0) ? true : false;
	}
	
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}