前言
今天要介绍信息的查询功能开发,包括用户信息的查询、教育信息的查询、工作经历信息的查询、技能信息的查询、特长信息的查询
一、实体类编写
增加一个实体类Information,用来存储查询的信息,类的内容如下:
@ApiModel(value = "用户信息实体类",description = "描述用户的所有信息")
@Data
@AllArgsConstructor
public class Information {
@ApiModelProperty(value = "用户基本信息")
private User user;
@ApiModelProperty(value = "用户教育信息")
private Education education;
@ApiModelProperty(value = "用户工作信息")
private Work work;
@ApiModelProperty(value = "用户技能信息")
private Skill skill;
@ApiModelProperty(value = "用户特长信息")
private Specialty specialty;
}
二、数据接口层编写
1.映射文件编写
在UserMapper映射文件中新增下列代码:
<select id="selectUser" parameterType="Integer" resultType="com.personal.homepage.bean.User">
select * from homepage_user where id=#{
userid}
</select>
在EducationMapper映射文件中新增下列代码:
<select id="selectEduction" parameterType="Integer" resultType="com.personal.homepage.bean.Education">
select * from homepage_edu where userid=#{
userid} order by start
</select>
在WorkMapper映射文件中新增下列代码:
<select id="selectWork" parameterType="Integer" resultType="com.personal.homepage.bean.Work">
select * from homepage_work where userid=#{
userid} order by start
</select>
在SkillMapper映射文件中新增下列代码:
<select id="selectSkill" parameterType="Integer" resultType="com.personal.homepage.bean.Skill">
select * from homepage_skill where userid=#{
userid}
</select>
在SpecialtyMapper映射文件中新增下列代码:
<select id="selectSpecialty" parameterType="Integer" resultType