namespace IBatis
{
public class User
{
public int UserId { get; set; }
public string UserName { get; set; }
}
public class UserRight
{
public int UserRightId { get; set; }
public int UserId { get; set; }
public int RightId { get; set; }
public string RightName { get; set; }
}
public class UserRightJoin
{
public int UserId { get; set; }
public string UserName { get; set; }
public IList UserRights { get; set; }
}
}
在Mapper的UserRight.xml中
在 sqlmap.config
然后是 DAO
public class BaseDao
{
public static ISqlMapper _sqlMap = null;
static BaseDao()
{
_sqlMap = Mapper.Instance();
}
}
public class UserDao : BaseDao
{
public IList GetList()
{
ISqlMapper mapper = _sqlMap;
IList ListPerson = mapper.QueryForList("selectAllUserRight", null); //这个"selectAllUserRight"就是xml映射文件的Id
return ListPerson;
}
}
最后是调用
static void Main(string[] args)
{
UserDao ud=new UserDao();
var lst= ud.GetList();
}
