1.第一个Mybatis程序
思路:搭建环境–>导入Mybatis–>编写代码–>测试
1.1搭建环境
1.搭建数据库:
create DATABASE mybatis_test;
use mybatis_test;
create table m_user(
id int PRIMARY key,
`name` VARCHAR(30) not null,
pwd VARCHAR(30) not null
)ENGINE=INNODB DEFAULT CHARSET=utf8;
insert into m_user VALUES(1,'admin','123456'),
(2,'张三','111111'),
(3,'李四','222222')
2.搭建项目:
-
创建Mybatis的maven项目
-
(父项目要把src删掉) 父pom.xml导包 和 子maven项目不用导包
-
<!--依赖如下--> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> </dependencies>
3.创建子模块写HelloWord
- 根据
编写resources资源文件里的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"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis_test?userSSL=false&useUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <mappers> <mapper resource="org/mybatis/example/BlogMapper.xml"/> </mappers> </configuration>
4.编写Mybatis工具类
package edu.xalead.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.InputStream;
//工具类(工厂模式)
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static{
try {
//获取sqlSessionFactory --> sqlSession
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (Exception e) {
e.printStackTrace();
}
}
//获取sqlSession 完全包含了面向数据库执行sql命令所需的所有方法。
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
}
5.编写代码
-
实体类
package edu.xalead.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 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 getPwd() { return pwd; } public void setPwd(String pwd) { this.pwd = pwd; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", pwd='" + pwd + '\'' + '}'; } }
-
实现类(以前JDBC)
-
Dao接口
package edu.xalead.dao; import edu.xalead.pojo.User; import java.util.List; public interface UserDao { List<User> getUserList(); }
-
接口实现类(由原来的UserDaoImpl转为一个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"> <!--namespacce = 绑定一个对应的Dao/Mapper接口 对应之前的实现接口--> <mapper namespace="edu.xalead.dao.UserDao"> <!--id 对应之前重写的方法名--> <!--resultType/resultMap 相当于之前的结果集Result--> <select id="getUserList" resultType="edu.xalead.pojo.User"> select * from mybatis_test.m_user </select> </mapper>
-
6.测试
package edu.xalead.dao;
import edu.xalead.pojo.User;
import edu.xalead.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserDaoTest {
@Test
public void test1(){
//1.获得执行sql的sqlSession
SqlSession session = MybatisUtils.getSqlSession();
//2.执行
UserDao userDao = session.getMapper(UserDao.class);
List<User> userList = userDao.getUserList();
for (User user : userList){
System.out.println(user.toString());
}
//关闭sqlSession
session.close();
}
}
注意点:
-
错误一:配置文件没有注册
org.apache.ibatis.binding.BindingException: Type interface com.it.Dao.UserMapper is not known to the MapperRegistry:核心配置文件中注册mappers
<!–每一个Mapper.xml都需要在mybatis-config.xml核心配置文件中注册–>**
** -
错误二:Maven导出资源问题
The error may exist in org/mybatis/example/BlogMapper.xml
Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
Cause: java.io.IOException: Could not find resource org/mybatis/example/BlogMapper.xml
<!-- 所有的maven项目都需要加进去这个文件,在父,子pom.xml里都需要加入一下代码 --> <!--在build中配置resources,来防止我们资源导出失败的问题--> <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>
-
错误三: 配置文件中有中文注释
nested exception is com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: 3 字节的 UTF-8 序列的字节 3无效。
- 配置文件设置的是<?xml version="1.0" encoding="UTF-8" ?>,但是其中有中文注释
<properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties>
-
错误4:时区设置。
- 进入命令窗口(Win + R),连接数据库 mysql -hlocalhost -uroot -p,回车,输入密码,回车
- 继续输入 show variables like’%time_zone’;,显示 SYSTEM 就是没有设置时区啦。
- 输入set global time_zone = ‘+8:00’;
2.Mybatis-CRUD
1.namespace
- namespace中的包名要和UserMapper.xml的接口包名一致
2.Select
选择,查询语句
-
id:就是对应(namesapce)接口中的方法名
-
resultType:Sql执行的返回值
-
parameterType:参数类型
-
此时表格映射(pojo),工具类(utiles),resources-mybatis-config.xml(配置文件)都已经建立好了。只需要改接口和接口实现.xml和测试类就可以了。
-
带参数的查询:根据id查询用户
1.接口(UserMapper):
User getUserById(int id);
2.接口实现.xml(UserMapper.xml):
id:接口里的方法名;resultType:返回值类型是User,要写权限路径;parameterType:要传入的参数的类型;where id = #{id}:要传入的参数,书写格式
<select id="getUserById" resultType="com.it.pojo.User" parameterType="int"> select * from mybatis.user where id = #{id} </select>
3.测试:
第一步和最后一步不变,只改中间即可
@Test public void getUserById(){ // 第一步获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); User user = mapper.getUserById(1); System.out.println(user); //最后一步关闭sqlSession sqlSession.close();
注意:
增删改must提交事务
3.Insert
-
接口:
-
// insert一个用户 int addUser(User user);
-
接口实现.xml(UserMapper.xml):
-
<!-- 对象中的属性可以直接取出来 --> <insert id="addUser" parameterType="com.it.pojo.User"> insert into mybatis.user(id,name,pwd) values (#{id},#{name},#{pwd}) </insert>
-
测试:
-
@Test public void addUser(){ // 第一步获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int user = mapper.addUser(new User(4, "wc", "444")); if (user>0){ System.out.println("insert success !"); } //增删改都需要提交事务 !!! sqlSession.commit(); // 最后一步关闭sqlSession sqlSession.close(); }
4.Update
-
接口:
-
// 修改用户 int updateUser(User user);
-
接口实现.xml(UserMapper.xml):
-
<update id="updateUser" parameterType="com.it.pojo.User"> update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id} ; </update>
-
测试:
-
@Test public void updateUser(){ // 第一步获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int user = mapper.updateUser(new User(4, "haha", "123123")); if (user>0){ System.out.println("insert success !"); } //增删改都需要提交事务 !!! sqlSession.commit(); // 最后一步关闭sqlSession sqlSession.close(); }
5.Delete
-
接口:
-
// 删除用户 void deleteUser(int id);
-
接口实现.xml(UserMapper.xml):
-
<delete id="deleteUser"> delete from mybatis.user where id = #{id} </delete>
-
测试:
-
@Test public void deleteUser(){ // 第一步获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int user = mapper.deleteUser(4); if (user>0){ System.out.println("insert success !"); } //增删改都需要提交事务 !!! sqlSession.commit(); // 最后一步关闭sqlSession sqlSession.close(); }
6.万能的Map
-
例子:使用select,查询id =1 并且 name=admin
-
接口:
// 万能的Map,当数据或者属性很多的时候,可以选择性的单独改变密码或者用户名等等。 User getUserByIdAndName(Map<String,Object> map);
-
接口实现.xml(UserMapper.xml):
<select id="getUserByIdAndName" resultType="edu.xalead.pojo.User" parameterType="map"> select * from mybatis_test.m_user where id=#{id} and `name`=#{name} </select>
-
测试:
@Test public void getUserByIdAndName(){ SqlSession session = MybatisUtils.getSqlSession(); UserMapper userMapper = session.getMapper(UserMapper.class); Map map = new HashMap<String, Object>(); map.put("id",1); map.put("name","admin"); User user = userMapper.getUserByIdAndName(map); System.out.println(user.toString()); session.close(); }
7.模糊查询
-
例子:使用List 模糊查询
-
接口:
//模糊查询 List<User> getUserLike(String value);
-
接口实现.xml(UserMapper.xml):
<select id="getUserLike" resultType="edu.xalead.pojo.User"> select * from mybatis_test.m_user where name like #{value} </select>
-
测试:
@Test public void getUserLike(){ SqlSession session = MybatisUtils.getSqlSession(); UserMapper mapper = session.getMapper(UserMapper.class); List<User> userList = mapper.getUserLike("%a%"); for (User user : userList){ System.out.println(user.toString()); } session.close(); }
欢迎访问我的个人博客:http://www.ayjup.cn