本文共 3814 字,大约阅读时间需要 12 分钟。
select p.id, p.create_time, p.update_time, p.create_user, p.update_user, p.project_name, p.test_user, p.dev_user, p.simple_desc, p.other_desc, p.project_code, p.belong_env_id, p.status_id,u.status_name,u.description from projectinfo_temp p LEFT JOIN usestatus u on p.status_id = u.id
@ToStringpublic class ProjectinfoTemp { private Integer id; private Date createTime; private Date updateTime; private String createUser; private String updateUser; private String projectName; private String testUser; private String devUser; private String simpleDesc; private String otherDesc; private String projectCode; private Integer belongEnvId; private Integer statusId; /** * 关联状态表 激活状态 */ private Usestatus usestatus;
/** * * @author liwen406 * @date 2019-04-21 09:12 */@ToStringpublic class Usestatus { private Integer id; private String statusName; private String description;
模仿写法
<sql id="WithBase_Column_List" >p.id, p.create_time, p.update_time, p.create_user, p.update_user, p.project_name, p.test_user,p.dev_user, p.simple_desc, p.other_desc, p.project_code, p.belong_env_id, p.status_id,u.status_name,u.description</sql>
坚持就是胜利
转载于:https://blog.51cto.com/357712148/2382122