在nutz dao中,添加两个@one,并且这两个属性都是同一个类型,会报错,可能是因为sql别名相同报错吧,@one可以自己设置sql别名吗?
@Column("main_leader_sid")
private String mainLeaderSid;
/**
*
*/
@Column("sub_leader_sid")
private String subLeaderSid;
/**
* field为java字段名 使用one时,字段要加上 Column
*/
@One(field="mainLeaderSid")
@Column
private SysUser mainLeader;
@One(field="subLeaderSid")
@Column
private SysUser subLeader;
org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT ec_new_activity.sid as sid,ec_new_activity.new_act_code as new_act_code,ec_new_activity.new_act_name as new_act_name,ec_new_activity.arrange_time as arrange_time,ec_new_activity.new_act_start_time as new_act_start_time,ec_new_activity.new_act_end_time as new_act_end_time,ec_new_activity.act_type as act_type,ec_new_activity.flag_status as flag_status,ec_new_activity.date_create as date_create,ec_new_activity.date_modify as date_modify,ec_new_activity.user_create as user_create,ec_new_activity.user_modify as user_modify,ec_new_activity.act_province as act_province,ec_new_activity.act_city as act_city,ec_new_activity.act_county as act_county,ec_new_activity.act_town as act_town,ec_new_activity.act_desc as act_desc,ec_new_activity.remark as remark,ec_new_activity.main_leader_sid as main_leader_sid,ec_new_activity.sub_leader_sid as sub_leader_sid , sys_user.sid as sys_user_z_sid,sys_user.organization_id as sys_user_z_organization_id,sys_user.openid as sys_user_z_openid,sys_user.user_name as sys_user_z_user_name,sys_user.user_pwd as sys_user_z_user_pwd,sys_user.nickname as sys_user_z_nickname,sys_user.user_real_name as sys_user_z_user_real_name,sys_user.user_phone as sys_user_z_user_phone,sys_user.user_email as sys_user_z_user_email,sys_user.user_type as sys_user_z_user_type,sys_user.role_id as sys_user_z_role_id,sys_user.job_number as sys_user_z_job_number,sys_user.icon as sys_user_z_icon,sys_user.flag_status as sys_user_z_flag_status,sys_user.date_create as sys_user_z_date_create,sys_user.date_modify as sys_user_z_date_modify,sys_user.user_create as sys_user_z_user_create,sys_user.user_modify as sys_user_z_user_modify,sys_user.remark as sys_user_z_remark , sys_user.sid as sys_user_z_sid,sys_user.organization_id as sys_user_z_organization_id,sys_user.openid as sys_user_z_openid,sys_user.user_name as sys_user_z_user_name,sys_user.user_pwd as sys_user_z_user_pwd,sys_user.nickname as sys_user_z_nickname,sys_user.user_real_name as sys_user_z_user_real_name,sys_user.user_phone as sys_user_z_user_phone,sys_user.user_email as sys_user_z_user_email,sys_user.user_type as sys_user_z_user_type,sys_user.role_id as sys_user_z_role_id,sys_user.job_number as sys_user_z_job_number,sys_user.icon as sys_user_z_icon,sys_user.flag_status as sys_user_z_flag_status,sys_user.date_create as sys_user_z_date_create,sys_user.date_modify as sys_user_z_date_modify,sys_user.user_create as sys_user_z_user_create,sys_user.user_modify as sys_user_z_user_modify,sys_user.remark as sys_user_z_remark FROM ec_new_activity LEFT JOIN sys_user ON ec_new_activity.main_leader_sid = sys_user.sid LEFT JOIN sys_user ON ec_new_activity.sub_leader_sid = sys_user.sid WHERE ec_new_activity.sid='{
"status" : "1"
}' LIMIT 0, 1 '
PreparedStatement:
'SELECT ec_new_activity.sid as sid,ec_new_activity.new_act_code as new_act_code,ec_new_activity.new_act_name as new_act_name,ec_new_activity.arrange_time as arrange_time,ec_new_activity.new_act_start_time as new_act_start_time,ec_new_activity.new_act_end_time as new_act_end_time,ec_new_activity.act_type as act_type,ec_new_activity.flag_status as flag_status,ec_new_activity.date_create as date_create,ec_new_activity.date_modify as date_modify,ec_new_activity.user_create as user_create,ec_new_activity.user_modify as user_modify,ec_new_activity.act_province as act_province,ec_new_activity.act_city as act_city,ec_new_activity.act_county as act_county,ec_new_activity.act_town as act_town,ec_new_activity.act_desc as act_desc,ec_new_activity.remark as remark,ec_new_activity.main_leader_sid as main_leader_sid,ec_new_activity.sub_leader_sid as sub_leader_sid , sys_user.sid as sys_user_z_sid,sys_user.organization_id as sys_user_z_organization_id,sys_user.openid as sys_user_z_openid,sys_user.user_name as sys_user_z_user_name,sys_user.user_pwd as sys_user_z_user_pwd,sys_user.nickname as sys_user_z_nickname,sys_user.user_real_name as sys_user_z_user_real_name,sys_user.user_phone as sys_user_z_user_phone,sys_user.user_email as sys_user_z_user_email,sys_user.user_type as sys_user_z_user_type,sys_user.role_id as sys_user_z_role_id,sys_user.job_number as sys_user_z_job_number,sys_user.icon as sys_user_z_icon,sys_user.flag_status as sys_user_z_flag_status,sys_user.date_create as sys_user_z_date_create,sys_user.date_modify as sys_user_z_date_modify,sys_user.user_create as sys_user_z_user_create,sys_user.user_modify as sys_user_z_user_modify,sys_user.remark as sys_user_z_remark , sys_user.sid as sys_user_z_sid,sys_user.organization_id as sys_user_z_organization_id,sys_user.openid as sys_user_z_openid,sys_user.user_name as sys_user_z_user_name,sys_user.user_pwd as sys_user_z_user_pwd,sys_user.nickname as sys_user_z_nickname,sys_user.user_real_name as sys_user_z_user_real_name,sys_user.user_phone as sys_user_z_user_phone,sys_user.user_email as sys_user_z_user_email,sys_user.user_type as sys_user_z_user_type,sys_user.role_id as sys_user_z_role_id,sys_user.job_number as sys_user_z_job_number,sys_user.icon as sys_user_z_icon,sys_user.flag_status as sys_user_z_flag_status,sys_user.date_create as sys_user_z_date_create,sys_user.date_modify as sys_user_z_date_modify,sys_user.user_create as sys_user_z_user_create,sys_user.user_modify as sys_user_z_user_modify,sys_user.remark as sys_user_z_remark FROM ec_new_activity LEFT JOIN sys_user ON ec_new_activity.main_leader_sid = sys_user.sid LEFT JOIN sys_user ON ec_new_activity.sub_leader_sid = sys_user.sid WHERE ec_new_activity.sid=? LIMIT 0, 1 '
CaseMessage=Not unique table/alias: 'sys_user'