2 、第一个Mybatis程序
思路:环境–>导入Mybatis–>编写代码–>测试
2.1 搭建环境
数据库建表
create database `mybatis`;
Use `mybatis`;
create table `user`(
`id` Int(20) not null,
`name` varchar(30) not null,
`pwd` Varchar(30) default null,
primary key (`id`)
)engine=INNODB default charset=utf8 ;
Insert into `user` (`id`,`name`,`pwd`) values
(1,'张三','12345'),
(2,'李四','12345')
新建项目(Maven)
- 新建一个普通的Maven项目
- 修改为自己的Maven
- 删除src
- 导入依赖(mysql,Mybatis,junit)
2.2创建一个模块
-
编写mybatis的核心配置文件
-
新建一个文件
-
从mybatis文档中复制下来,删掉mapper那一段(在2.4再次提到),然后添加自己的mysql数据库信息
<?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"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="12345"/> </dataSource> </environment> </environments> </configuration>
-
-
编写Mybatis工具类
package com.ex.utils; 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 java.io.IOException; import java.io.InputStream; //sqlSessionFactory -->sqlSession public class MybatisUtils { private static SqlSessionFactory sqlSessionFactory; static { try { //第一步:获取sqlSessionFactory对象 String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { e.printStackTrace(); } } //有了Factory,就可以从中获取sqlSession的实例了 public static SqlSession getSqlSession(){ return sqlSessionFactory.openSession(); } }
2.3 编写代码
-
实体类(这里记得写上toStirng方法)
package com.ex.pojo; //实体类 public class User { private int id; private String name; private String pwd; public User() { } public User(int id, String name, String pwd) { this.id = id; this.name = name; this.pwd = pwd; } public void setId(int id) { this.id = id; } public void setName(String name) { this.name = name; } public void setPwd(String pwd) { this.pwd = pwd; } public int getId() { return id; } public String getName() { return name; } public String getPwd() { return pwd; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", pwd='" + pwd + '\'' + '}'; } }
-
Dao接口
package com.ex.dao; import com.ex.pojo.User; import java.util.List; public interface UserDao { List<User> getUserList(); }
-
接口实现类,由原来的UserDaoImp转变为一个Mapper配置文件
<?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"> <!--namespace 命名空间,绑定一个对应的Dao/Mapper接口--> <mapper namespace="com.ex.dao.UserDao"> <!-- select查询语句 --> <!-- 这个id就相当于重写的方法名,resultType就是返回的结果,如果是resultMap,返回结果集--> <select id="getUserList" resultType="com.ex.pojo.User"> select * from mybatis.user </select> </mapper>
2.4 测试
Junit测试:
在Test文件下,建立一样的包,然后测试;
package com.ex.dao;
import com.ex.pojo.User;
import com.ex.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserDaoTest {
@Test
public void test(){
//第一步,获得SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//执行SQL,方式1:getMapper
UserDao userDao = sqlSession.getMapper(UserDao.class);
List<User> userList = userDao.getUserList();
for (User user : userList) {
System.out.println(user);
}
//关闭sqlSession
sqlSession.close();
}
}
- 注意,直接测试会报错:org.apache.ibatis.binding.BindingException: Type interface com.ex.dao.UserDao is not known to the MapperRegistry.
解决:在mybatis核心配置文件下面配置
- 第二个错:java.io.IOException: Could not find resource com/ex/dao/UserMapper.xml
原因:Maven的约定大于配置,
解决方法:在pom.xml 中加一个build中配置(配完了要更新pom.xml)
<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>true</filtering>
</resource>
</resources>
</build>
-
第三个错:写了第二个错的解决办法还是错的,是因为字符编码的原因
解决方法:在pom.xml里面的properties下配置这个
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>