rolessqlmapdao.java

来自「一个实用的CMS管理」· Java 代码 · 共 41 行

package com.suncms.persistence.sqlmapdao; 

import java.util.List;
import com.suncms.domain.Uroles;
import com.suncms.persistence.iface.RolesDao;
 
public class RolesSqlMapDao extends BaseSqlMapDao implements RolesDao { 
  public RolesSqlMapDao() { 
   
  }

public List<Uroles> getAllRole() {
	return (List<Uroles>) smcTemplate.queryForList("getAllRoles",null);
}

public void insertRoles(Uroles uroles) {
	
		smcTemplate.update("insertUroles", uroles); 
		
	
}

public Uroles getRolesById(String RowId) {
	return (Uroles) smcTemplate.queryForObject("getRolesByID",RowId);
}

public List<Uroles> getRoleIsUser(String User_Id) {
	return (List<Uroles>) smcTemplate.queryForList("getRolesByIsUserID",User_Id);
}

public List<Uroles> getRoleNotIsUser(String User_Id) {
	return (List<Uroles>) smcTemplate.queryForList("getRolesByNotUserID",User_Id);
}

public List<Uroles> getRolesByName(String role_name) {
	return (List<Uroles>) smcTemplate.queryForList("getRolesByName",role_name);
}



}