roledaoimpl.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.rowmapper.user.UserRoleRowMapper;
import com.srit.gcz.bean.user.UserRightRel;
import com.srit.gcz.bean.user.UserRole;
import com.srit.gcz.dao.user.RoleDao;
import com.srit.gcz.util.SysConstant;

public class RoleDaoImpl implements RoleDao {
	//增加角色
	private static final String INSERT_ROLE = "INSERT INTO" + SysConstant.TABLE_USER_ROLE +"(ID,NAME,REMARK) VALUES (?,?,?)";
	//更新角色
	private static final String UPDATE_SOLE = "UPDATE" + SysConstant.TABLE_USER_ROLE + "SET NAME=?,REMARK=?";
	//删除角色
	private static final String DELETE_SOLE = "DELETE FROM" + SysConstant.TABLE_USER_ROLE + "WHERE ID=?";
	//查询某角色
	private static final String QUERY_SOLE = "SELECT * FROM " + SysConstant.TABLE_USER_USERROLE + "WHERE ID+?";
	//查询所有的角色
	private static final String QUERY_ALL_SOLE = "SELECT * FROM" + SysConstant.TABLE_USER_USERROLE;
	//新增角色权限的关系
	private static final String INSERT_REL_ROLE = "INSERT INTO" + SysConstant.TABLE_USER_ROLERIGHT + "(ROLEID,RIGHTID,REMARK) VALUES (?,?,?)";
	//删除角色权限的关系
	private static final String DELETE_REL_ROLE = "DELETE FROM" + SysConstant.TABLE_USER_ROLERIGHT + "WHERE ROLEID= ?";
	
	// Spring注入
	private JdbcTemplate jdbcTemplate;

	/**
	 * 保存角色
	 * @param userRole
	 * @return
	 */
	public boolean save(UserRole userRole){
		int operMark = jdbcTemplate.update(INSERT_ROLE, new Object[]{userRole.getId(),userRole.getName(),userRole.getRemark()});
		return (operMark>0) ? true:false;
	}
	/**
	 * 新增角色权限的关系
	 * @param userRightRel
	 * @return
	 */
	public boolean saveRel(UserRightRel userRightRel){
		int operMark = jdbcTemplate.update(INSERT_REL_ROLE,new Object[]{userRightRel.getRoleId(),userRightRel.getRightId(),userRightRel.getRemark()} );
		return (operMark>0) ? true : false; 
	}
	/**
	 * 修改角色
	 * @param userRole
	 * @return
	 */
	public boolean update(UserRole userRole){
		int operMark = jdbcTemplate.update(UPDATE_SOLE, new Object[]{userRole.getName(),userRole.getRemark()});
		return (operMark>0) ? true:false;
	}
	/**
	 * 删除角色
	 * @param userRole
	 * @return
	 */
	public boolean delete(UserRole userRole){
		int operMark = jdbcTemplate.update(DELETE_SOLE, new Object[]{userRole.getId()});
		return (operMark>0) ? true : false; 
	}
	/**
	 * 删除角色权限的关系
	 * @param userRightRel
	 * @return
	 */
	
	public boolean deleteRel(UserRightRel userRightRel){
		int operMark = jdbcTemplate.update(DELETE_REL_ROLE, new Object[]{userRightRel.getRoleId()});
		return (operMark>0) ? true : false;
	}
	/**
	 * 获得角色
	 * @param ID
	 * @return
	 */
	public UserRole getUserByRole(int ID){
		UserRole userRole = (UserRole)jdbcTemplate.queryForObject(QUERY_SOLE, new Object[]{ID}, new UserRoleRowMapper());
		return userRole;
	}
	/**
	 * 根据条件获取所有的角色
	 * @param 
	 * @return
	 */
	public List getUserAllRole(){
		Object obj = jdbcTemplate.query(QUERY_ALL_SOLE,
				new RowMapperResultSetExtractor(new UserRoleRowMapper()));
		return (List<UserRole>) obj;
	}


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