1. Mybatis所需jar包:
mybatis:3.5.6
mysql:对应自己电脑上的mysql版本
lombok:实体类包(本人的《lombok使用》有讲怎么用)
log4j:日志包
2. 创建实体类和dao:
Dao
package com.aaa.dao;
import com.aaa.entity.Claeee;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface ClaeeDao {
//定义方法,在映射文件中实现方法
Claeee getClaeeById(@Param("cid")int id);
}
实体类
- 班级
package com.aaa.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.List;
@NoArgsConstructor
@AllArgsConstructor
@Data
public class Claeee {
private int cId;
private String cname;
private int teacherid;
//和老师,多对一
private Teacher teacher;
//和学生 一对多
private List<Student> students;
}
- 老师
package com.aaa.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Teacher {
private int tid;
private String tname;
}
- 学生
package com.aaa.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
private int sid;
private String sname;
private int classid;
}
2. 创建映射文件-----写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="要对应的dao的全类名">
<!-- 查-->
<select id ="调用时的方法名">
<!-- sql语句 -->
</select>
<!-- 增删改-->
<insert >增
<delect >删
<update >改
</mapper>
多表联查
返回类型要自定
<resultMap id="getClaeeById" type="com.aaa.entity.Claeee">
<!--应对数据库字段名和实体类不一致-->
<id column="c_id" property="cId"></id>
<result column="c_name" property="cname" />
<result column="teacher_id" property="teacherid"/>
<!-- 一对多-- association标签 返回java类>
<association property="teacher" javaType="com.aaa.entity.Teacher">
<id column="t_id" property="tid"/>
<result column="t_name" property="tname"/>
</association>
<!-- 多对一-- collection 标签 返回ofType列表>
<collection property="students" ofType="com.aaa.entity.Student">
<id column="s_id" property="sid"/>
<result column="s_name" property="sname"/>
<result column="class_id" property="classid"/>
</collection>
</resultMap>
<select id="getClaeeById" resultMap="getClaeeById">
select * from class c , teacher t ,student s where c.teacher_id = t.t_id and s.class_id = c.c_id and c.c_id=#{cid}
</select>
提示:
1、namespace属性一定要对应要操作的dao接口
此时这个映射文件就代表接口的实现
2、 方法名对应
也就是这个id的名称 id ="调用时的方法名"
3.创建一个mybatis的配置文件:
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
**<!-- 加载mysql驱动的-->**
<property name="driver" value="com.mysql.jdbc.Driver" />
<!-- ?serverTimezon=Asia/Shanghai解决时区问题-->
<property name="url" value="jdbc:mysql://localhost:3306/**数据库名**?serverTimezon=Asia/Shanghai" />
<!-- 用户名和密码-->
<property name="username" value="root" />
<property name="password" value="" />
</dataSource>
</environment>
</environments>
<!-- //加载映射文件-->
<mappers>
<mapper resource="映射·的全路径和全名"></mapper>
</mappers>
</configuration>
提示:
1、数据库名,用户名和密码要改
2、 一定要加载映射文件
测试
@Test
public void sse() throws Exception{
//1.加载文件
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
//2.创建sql工厂
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
//3.打开
SqlSession session = factory.openSession();
//4.执行
CLaeeDao dao = session.getMapper(CLaeeDao.class);
List<Claee> allClaee = dao.getAllClaee();
System.out.println(allClaee);
}