步骤:
1.导入相关jar包
· junit
· mybatis
· mysql数据库
· spring相关的
· aop织入
· mybatis-spring【new】
2.编写配置文件
3.测试
mybatis是基于JDBC的框架,简单来说就是别人把JDBC封装好,你直接导入这个mybatis依赖就可以不用JDBC那一套操作而是换成mybatis规定的操作来操作数据库
1、在父pom中导入mybatis依赖
<!--mybatis依赖-->
<dependencies>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency><!--(mysql连接类)jdbc依赖,mybatis仍然需要用到jdbc,只是不需要我们手动配置jdbc-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
2、在resource目录下建立一个核心配置文件,例如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>
<properties resource="my.properties"></properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments><!--注册mapper(映射器)-->
<mappers>
<mapper resource="config/Studentconfig.xml"/>
</mappers></configuration>
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8
username=root
password=root
3、有了这个核心类就可以去得到sql语句的执行对象
生成一个类用于生成执行sql的对象
package com.z.MybatisUtils;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
public class GetSqlsession {
private static InputStream inputStream;
//这个方法生成一个生产sqlsession的工厂,即SqlSessionFactory
public static SqlSessionFactory createfactory(){
{
try {
inputStream = Resources.getResourceAsStream("mybatis-config.xml");
}catch (IOException e){
e.printStackTrace();
}
}
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
//通过把这个工厂return出来,以便后续通过这个工厂获得SqlSession对象
return sqlSessionFactory;
}
public static SqlSession getsqlsession(){
return createfactory().openSession();
}
}
到这里我们的SqlSession对象获取完毕,后面所有的操作都使用到SqlSession
4、创建一个实体类User
package com.z.pojo;
public class User {
private int id;
private String name;
private String sex;
private String addr;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddr() {
return addr;
}
public void setAddr(String addr) {
this.addr = addr;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", sex='" + sex + '\'' +
", addr='" + addr + '\'' +
'}';
}
}
建这个实体类是为了我们等下在写接口的方法的时候,返回类型就是这个实体类
5、然后写接口UserMapper
package com.z.mapper;
import com.z.pojo.User;
import java.util.List;
public interface UserMapper {
List<User> selectUser();
}
接口中只要定义简单的方法和返回值类型
6、定义好接口之后要写接口对应的.xml文件,即UserMapper.xml,mybatis就是通过mapper调用接口中的方法
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.z.mapper.UserMapper">
<!-- <insert id="insertUser" parameterType="com.z.pojo.User">-->
<!-- insert into mybatis values (3,"小李","女","潍坊");-->
<!-- </insert>-->
<select id="selectUser" resultType="com.z.pojo.User">
select * from mybatis
</select>
</mapper>
mapper标签中,namespace需要对应你的接口名
增删改查标签就在这里面使用
select中的id对应所绑定接口的方法
resultType表示返回类型,即先前定义的实体类User
如果你在接口中定义的方法需要传参数的话,select标签中还需要定义一个
parameterType,即参数类型
7、接下来要将刚才写的这个mapper注册到mybatis的核心配置文件中
即在mybatis-config.xml中进行注册
<mappers> <mapper resource="com/z/mapper/UserMapper.xml"/> </mappers>
8、在父pom中配置一下build标签
<!--使打包时能一起打包配置文件-->
<build>
<resources>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource><resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource></resources>
</build>
9、开始测试
import com.z.MybatisUtils.GetSqlsession;
import com.z.mapper.UserMapper;
import com.z.pojo.User;
import org.apache.ibatis.session.SqlSession;
import java.util.List;
import java.util.logging.Logger;
public class MyTest {
public static void main(String[] args) {
test();
}
private static void test(){
SqlSession sqlSession= GetSqlsession.getsqlsession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
List<User> users=userMapper.selectUser();
for (User user : users) {
System.out.println(user);
}
sqlSession.close();
}
}