rolessqlmapdao.java.svn-base

来自「一个实用的CMS管理」· SVN-BASE 代码 · 共 43 行

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) {
	try{
		smcTemplate.update("insertUroles", uroles); 
		}catch(Exception e){
			e.printStackTrace();
		}
	
}

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);
}



}