rightdaoimpl.java

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

package com.srit.gcz.dao.impl.user;

import java.util.List;

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

import com.srit.gcz.bean.IndexDim;
import com.srit.gcz.bean.rowmapper.IndexDimRowMapper;
import com.srit.gcz.bean.rowmapper.user.UserRightRowMapper;
import com.srit.gcz.bean.user.UserRight;
import com.srit.gcz.dao.user.RightDao;
import com.srit.gcz.util.SysConstant;

public class RightDaoImpl implements RightDao {
	//增加权限
	private static final String INSERT_RIGHT = "INSERT INTO" + SysConstant.TABLE_USER_RIGHT +"(ID,NAME,REMARK) VALUES(?,?,?)";
	//更新权限
	private static final String UPDATE_RIGHT = "UPDATE" + SysConstant.TABLE_USER_RIGHT + "SET ID=?,NAME=?,REMARK=?";
	//删除权限
	private static final String DELETE_RIGHT = "DELETE FROM" + SysConstant.TABLE_USER_RIGHT + "WHERE ID=?";
	//查询某权限
	private static final String QUERY_RIGHT = "SELECT * FROM " + SysConstant.TABLE_USER_RIGHT + "WHERE ID=?";
	//查询所有的用户
	private static final String QUERY_ALL_RIGHT = "SELECT * FROM " +SysConstant.TABLE_USER_RIGHT;
	// Spring注入
	private JdbcTemplate jdbcTemplate;
	
	/**
	 * 保存用户权限
	 * @param userRight
	 * @return
	 */
	public boolean save(UserRight userRight){
		
		int operMark = jdbcTemplate.update(INSERT_RIGHT, new Object[]{userRight.getId(),userRight.getName(),userRight.getRemark()});
		return (operMark>0) ? true:false; 
		
	}
	
	
	/**
	 * 修改用户权限
	 * @param userRight
	 * @return
	 */
	public boolean update(UserRight userRight){
		int operMark = jdbcTemplate.update(UPDATE_RIGHT, new Object[]{userRight.getId(),userRight.getName(),userRight.getRemark()});
		return (operMark>0) ? true : false;
	}
	
	/**
	 * 删除用户权限
	 * @param userRight
	 * @return
	 */
	public boolean delete(UserRight userRight){
		int operMark = jdbcTemplate.update(DELETE_RIGHT, new Object[]{userRight.getId()});
		return (operMark>0) ? true:false;
	}
	
	/**
	 * 根据条件获取的权限
	 * @param ID
	 * @return
	 */
	
	public UserRight getUserByRight(int ID){
		UserRight userRight =(UserRight)jdbcTemplate.queryForObject(QUERY_RIGHT, new Object[]{ID},new UserRightRowMapper() );
		return userRight;
	}
	/**
	 * 根据条件获取所有的权限
	 * @return 
	 */
	
	public List getUserAllRight(){
		Object obj = jdbcTemplate.query(QUERY_ALL_RIGHT,
				new RowMapperResultSetExtractor(new UserRightRowMapper()));
		return (List<UserRight>) obj;
	}
	

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
}