indexunitdaoimpl.java

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

package com.srit.gcz.dao.impl;

import java.util.List;

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

import com.srit.gcz.bean.IndexUnit;
import com.srit.gcz.bean.rowmapper.IndexUnitRowMapper;
import com.srit.gcz.dao.IndexUnitDao;
import com.srit.gcz.util.SysConstant;

/**
 * 计量单位
 * @Company 国研科技
 * @author 陈鹏昊
 * @date 2009-3-24
 * @version 1.0
 * @since 1.0
 */
public class IndexUnitDaoImpl implements IndexUnitDao{
	// 查询计量单位
	private static final String QUERY_INDEXUNIT = "SELECT * FROM "+SysConstant.TABLE_INDEX_UNIT+" WHERE ID = ?";
	// 查询计量单位名称
	private static final String QUERY_NAME_INDEXUNIT = "SELECT NAME FROM "+SysConstant.TABLE_INDEX_UNIT+" WHERE ID = ?";
	// 查询所有计量单位
	private static final String QUERY_ALL_INDEXUNIT = "SELECT * FROM "+SysConstant.TABLE_INDEX_UNIT;
	// 新增计量单位
	private static final String INSERT_INDEXUNIT = "INSERT INTO "+SysConstant.TABLE_INDEX_UNIT+"(ID, NAME) VALUES(?, ?)";
	// 更新计量单位
	private static final String UPDATE_INDEXUNIT = "UPDATE "+SysConstant.TABLE_INDEX_UNIT+" SET NAME = ? WHERE ID = ?";
	// 删除计量单位
	private static final String DELETE_INDEXUNIT= "DELETE FROM "+SysConstant.TABLE_INDEX_UNIT+" WHERE ID = ?";
	// Srping注入
	private JdbcTemplate jdbcTemplate;
	
	public boolean delete(IndexUnit bean) {
		int operMark = jdbcTemplate.update(DELETE_INDEXUNIT,
				new Object[] {bean.getId()});
		return (operMark > 0) ? true : false;
	}

	public IndexUnit getIndexUnitByID(int ID) {
		IndexUnit bean = (IndexUnit) jdbcTemplate.queryForObject(QUERY_INDEXUNIT, new Object[] { ID },
				new IndexUnitRowMapper());
		return bean;
	}

	@SuppressWarnings("unchecked")
	public List<IndexUnit> getIndexUnits() {
		Object obj = jdbcTemplate.query(QUERY_ALL_INDEXUNIT, new RowMapperResultSetExtractor(new IndexUnitRowMapper()));
		return (List<IndexUnit>)obj;
	}

	public boolean save(IndexUnit bean) {
		int operMark = jdbcTemplate.update(INSERT_INDEXUNIT,
				new Object[] {bean.getId(), bean.getName()});
		return (operMark > 0) ? true : false;
	}

	public boolean update(IndexUnit bean) {
		int operMark = jdbcTemplate.update(UPDATE_INDEXUNIT,
				new Object[] {bean.getName(), bean.getId()});
		return (operMark > 0) ? true : false;
	}
	
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

	public String getIndexUnitNameById(int ID) {
		try{
			return (String)jdbcTemplate.queryForObject(QUERY_NAME_INDEXUNIT, new Object[] {ID}, String.class);
		}catch(Exception e){
			return "";
		}
	}
}