java dao public <t> t execute_nutz Dao 查询映射实体类赋值问题。

package com.elvish.oda.busin.pojo;

import java.util.Date;

import org.nutz.dao.entity.annotation.Column;

import org.nutz.dao.entity.annotation.Id;

import org.nutz.dao.entity.annotation.Table;

import org.nutz.json.Json;

@Table("t_user")

public class User {

@Id

private Integer id;

@Column

private String username;

@Column

private String password;

@Column

private String name;

@Column("login_time")

private Date loginTime;

@Column

private Integer delflag;

@Column

private Integer status;

@Column

private String remark;

@Column("create_time")

private Date createTime;

@Column("update_time")

private Date updateTime;

@Column("create_user")

private Date createUser;

@Column("update_user")

private Date updateUser;

private String roleName;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Date getLoginTime() {

return loginTime;

}

public void setLoginTime(Date loginTime) {

this.loginTime = loginTime;

}

public Integer getDelflag() {

return delflag;

}

public void setDelflag(Integer delflag) {

this.delflag = delflag;

}

public Integer getStatus() {

return status;

}

public void setStatus(Integer status) {

this.status = status;

}

public String getRemark() {

return remark;

}

public void setRemark(String remark) {

this.remark = remark;

}

public Date getCreateTime() {

return createTime;

}

public void setCreateTime(Date createTime) {

this.createTime = createTime;

}

public Date getUpdateTime() {

return updateTime;

}

public void setUpdateTime(Date updateTime) {

this.updateTime = updateTime;

}

public Date getCreateUser() {

return createUser;

}

public void setCreateUser(Date createUser) {

this.createUser = createUser;

}

public Date getUpdateUser() {

return updateUser;

}

public void setUpdateUser(Date updateUser) {

this.updateUser = updateUser;

}

public String getRoleName() {

return roleName;

}

public void setRoleName(String roleName) {

this.roleName = roleName;

}

@Override

public String toString() {

return Json.toJson(this);

}

}

public List findAllUserRole() {

String querySql = "SELECT t1.*, t2.role_name roleName FROM t_user_role t0 LEFT JOIN t_user t1 ON t0.user_id = t1.id LEFT JOIN t_role t2 ON t0.role_id = t2.id";

Sql sql = Sqls.fetchString(querySql);

return NutzSqlUtil.getEntities(sql, dao, User.class);

}

public static List getEntities(Sql sql, Dao dao, Class clz) {

sql.setCallback(Sqls.callback.entities());

sql.setEntity(dao.getEntity(clz));

dao.execute(sql);

return sql.getList(clz);

}

sql

SELECT

t1.*, t2.role_name roleName

FROM

t_user_role t0

LEFT JOIN t_user t1 ON t0.user_id = t1.id

LEFT JOIN t_role t2 ON t0.role_id = t2.id

进行数据库查询,想带出非User表中的roleName信息。

我在User实体中定义了roleName属性,settter/getter。

问题

执行dao操作后,User中roleName不能被赋值? why??

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值