问题遇到的现象和发生背景
员工类还有部门对象,在更新时sql语句该如何填写呢,传入的参数为员工对象,即关联的修改语句该怎么写呢
用代码块功能插入代码,请勿粘贴截图
public class Department {//这是部门类
private Integer id;
private String departmentName;
}
public class Employee {//员工类
private Integer id;
private String lastName;
private String email;
private Integer gender;
private Department department;
private Integer did;//did对应部门的id
private Date birth;
}
public interface EmployeeMapper {//mapper接口
public void save(Employee employee);}
```xml
<update id="save" parameterType="Employee">
update employee
set lastName=#{lastName},email=#{email},gender=#{gender},birth=#{birth},
did=#{did},department.departmentName=#{department.departmentName}
where id=#{id}
</update>
运行结果及报错内容
结果报错,应该是在xml文件传不了javabean,
我的解答思路和尝试过的方法
我在网上找的大多是多表的查询sql语句怎么写,但这多表更新语句又该怎么写呢