环境准备
1.数据库表tb_brand
2.实体类
public class Brand {
private Integer id;
private String brandName;
private String companyName;
private Integer ordered;
private String description;
private Integer status;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getBrandName() {
return brandName;
}
public void setBrandName(String brandName) {
this.brandName = brandName;
}
public String getCompanyName() {
return companyName;
}
public void setCompanyName(String companyName) {
this.companyName = companyName;
}
public Integer getOrdered() {
return ordered;
}
public void setOrdered(Integer ordered) {
this.ordered = ordered;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
@Override
public String toString() {
return "Brand{" +
"id=" + id +
", brandName='" + brandName + '\'' +
", companyName='" + companyName + '\'' +
", ordered=" + ordered +
", description='" + description + '\'' +
", status=" + status +
'}';
}
}
3.测试用例
在test-java目录下创建测试类
public class MyBatisTest { }
4.安装MyBatisX插件
MyBatisX是一款基于IDEA的快速开发插件,为效率而生
主要功能:
1 XML和接口方法相互跳转
2 根据接口方法生成statement
安装步骤:
查询-查询所有-结果映射
1.编写接口方法:Mapper接口;
参数:无
结果:List<Brand>
public interface BrandMapper {
/**
* 查询所有
*/
public List<Brand> selectAll();
}
2.编写sql语句:SQL映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.itheima.mapper.BrandMapper">
<!--
数据库表的字段名称和实体类的属性名称不一样,则不能自动封装数据
*对sql语句的字段查询名称 起别名:
-->
<!-- <select id="selectAll" resultType="brand">-->
<!-- select *-->
<!-- from tb_brand;-->
<!-- </select>-->
<select id="selectAll" resultType="brand">
select id,brand_name as brandName,company_name as companyName,ordered,description,status
from tb_brand;
</select>
</mapper>
方式一:sql片段可以解决起别名的繁琐
<sql id="brand_column">
id,brand_name as brandName,company_name as companyName,ordered,description,status;
</sql>
<select id="selectAll" resultType="brand">
select
<include refid="brand_column"/&