创建Mybatis前的准备工作
1.新建一个maven项目
2.下下一步
3.完毕,我们创建好了如下一些文件,最重要的是pom.xml文件,这是我们的主配置文件
4.接下来我们需要导入几个jar包,登陆https://mvnrepository.com/
分别是:mysql-connector-java;org.mybatis,一个是数据库驱动包,一个是mybatis框架包
只要在maven仓库中把查到的依赖代码复制粘贴到pom.xml里即可
5.创建xml文件模板
6.在resource文件下新建mybatis-cfg.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="test">
<environment id="test">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/db?serverTimezone=Asia/Shanghai&useSSL=false"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/njdf/mapper/User.xml"></mapper>
</mappers>
</configuration>
其中db是我的数据库,root和123456是我的连接账户和密码,因人而异
7.创建User数据表的映射![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/02babb90518c929a2b03ec142fcf3398.png)
package mybatis2.pojo;
import lombok.Data;
@Data
public class User {
int user_id;
String username;
public User() {
}
public User(int userId, String username) {
this.user_id = userId;
this.username = username;
}
}
其中@Data是lombok插件中提供的注解,可以省去所有变量的set和get方法,以及toString ,hashCode,equals方法,详情可查询lombok的用法
8.在根目录下创建mapper文件夹,再在mapper下创建User.xml
<?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="mybatis2.mapper.User">
<select id="find" resultType="mybatis2.pojo.User">
select user_id,username from user;
</select>
</mapper>
9.把写好的mapper配置到mybatis-cfg.xml中
10.在pom.xml中,把xml文件加入编译
否则会报错
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
11.写Test类
public class App {
public static void main( String[] args ) throws IOException {
InputStream inputStream = Resources.getResourceAsStream("mybatis-cfg.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = factory.openSession();
List<User> objects = sqlSession.selectList("mybatis2.mapper.User.find");
System.out.println(objects);
sqlSession.close();
}
}