以上一篇MyBatis为基础,只需要编写接口,编写对应的UserMapper.xml文件,然后进行测试
编写UserMapper接口
import java.util.List;
public interface UserMapper {
//获取全部的用户
List<User> selectUser();
//通过id查找用户
User selectUserById(int id);
//增加用户
int insertUser(User user);
//根据id删除用户
int deleteUserById(int id);
//修改用户
int updateUser(User user);
}
编写对应的UserMapper.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对应Mapper接口的类-->
<mapper namespace="com.muzili.dao.UserMapper">
<!--select标签的id对应映射接口的方法名字 resultType:返回结果的类型 中间就编写sql语句-->
<select id="selectUser" resultType="com.muzili.pojo.User">
select * from user
</select>
<select id="selectUserById" resultType="com.muzili.pojo.User">
select * from user where id=#{id}
</select>
<insert id="insertUser" parameterType="com.muzili.pojo.User">
insert into user(id,name,pwd) value (#{id},#{name},#{pwd})
</insert>
<delete id="deleteUserById" parameterType="com.muzili.pojo.User">
delete from user where id=#{id}
</delete>
<update id="updateUser" parameterType="com.muzili.pojo.User">
update user set name=#{name},pwd=#{pwd} where id=#{id}
</update>
</mapper>
编写测试类:
package com.muzili.dao;
import com.muzili.dao.UserMapper;
import com.muzili.pojo.User;
import com.muzili.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;
import java.util.List;
public class UserMapperTest {
@Test
public void selectUser(){
//1.拿到sqlSessionFactory对象
SqlSessionFactory sqlSessionFactory = MyBatisUtils.getSqlSessionFactory();
//2.通过sqlSessionFactory对象openSession()创建一个sqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
//3.通过sqlSession获得mapper对象,参数为映射文件对应的接口类的class对象
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//4.通过mapper对象来执行操作
List<User> users = mapper.selectUser();
for (User user : users) {
System.out.println(user);
}
}
@Test
public void selectUserById(){
SqlSession sqlSession = MyBatisUtils.getSqlSessionFactory().openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.selectUserById(1);
System.out.println(user);
}
@Test
public void insertUser(){
User user=new User(5,"刘德华","123456");
SqlSession sqlSession = MyBatisUtils.getSqlSessionFactory().openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.insertUser(user);
sqlSession.commit();
if (i>0){
System.out.println("插入成功!");
}
sqlSession.close();
}
@Test
public void deleteUserById(){
SqlSession sqlSession = MyBatisUtils.getSqlSessionFactory().openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.deleteUserById(4);
sqlSession.commit();
if (i>0){
System.out.println("删除成功!");
}
sqlSession.close();
}
@Test
public void updateUser(){
SqlSession sqlSession = MyBatisUtils.getSqlSessionFactory().openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = new User(3,"胡歌","987654");
mapper.updateUser(user);
sqlSession.commit();
sqlSession.close();
}
}
**注意:
- 增、改、删需要提交事务
- 乱码问题解决:现在sql中进行测试,sql没问题,就检查配置文件中的以下代码有无问题**
jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8"
- 如果参数是基本数据类型,可以省略,但建议写上;引用类型必须写指定的包名+类名
配置文件mybaits-config解析
<?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 配置文件
settings mybatis设置
typeAliases 为Java类起别名
typeHandlers 类处理器
objectFactory 对象工厂
plugins 插件
environments 环境
transactionManager : 事务管理
dataSource : 数据源
mappers 映射器
优化配置文件(增加代码的灵活性)
创建一个database.properries
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8
username = root
password = 123456
在mybatis核心配置文件中引入properties配置文件,并用${}表达式引入其中的值
<configuration>
<!--配置文件修改-->
<properties resource="database.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>
<mappers>
<mapper resource="com/kuang/dao/userMapper.xml"/>
</mappers>
</configuration>
优化别名
<!--配置别名-->
<typeAliases>
<!--配置指定类的别名-->
<typeAlias type="com.kuang.pojo.User" alias="User"/>
<!--
可以为一个包的所有类指定别名,这个别名为类名
com.kuang.pojo.User - > User
com.kuang.pojo.Student - > Student
-->
<package name="com.kuang.pojo"/>
</typeAliases>
优化完毕后就可以在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">
<!--mapper标签的namespace对应Mapper接口的类,包名+类名-->
<mapper namespace="com.kuang.dao.UserDao">
<!--select标签的id对应映射接口的方法名字 resultType:返回结果的类型 中间就编写sql语句-->
<select id="selectUser" resultType="User">
select * from user
</select>
<select id="selectUserById" resultType="User">
select * from user where id = #{id}
</select>
<!--
我们需要接受一个自定义的对象(引用对象),需要设置parameterType,为参数类型
接受这个对象的值,直接使用 #{对象字段名}
-->
<insert id="addUser" parameterType="User">
insert into user(id ,name, pwd) values (#{id},#{name},#{pwd})
</insert>
<delete id="deleteUserByID" parameterType="int">
delete from user where id = #{id}
</delete>
<update id="updateUser" parameterType="User">
update user set name =#{name},pwd = #{pwd} where id = #{id}
</update>
</mapper>
映射器
- resource(推荐使用)
- url
- class
- packge
例如:
<!-- 使用相对于类路径的资源引用 -->
<mappers>
<mapper resource="org/mybatis/builder/AuthorMapper.xml"/>
<mapper resource="org/mybatis/builder/BlogMapper.xml"/>
<mapper resource="org/mybatis/builder/PostMapper.xml"/>
</mappers>
字段名和属性名不一致解决方案
例如:
字段名:数据库 id name pwd (数据库中)
属性名:实体类 id name password (方法定义中)
解决方案1:给sql语句取别名
<select id = "selectUser" resultType="User">
select id,name,pwd as password from user
</select>
使用场景:字段少的时候推荐使用
解决方案2:结果集映射ResultMap
<!--设置结果的映射类型-->
<resultMap id="UserMap" type="User">
<!--
一般通过id标签来映射主键
column = 数据库的列名
property = 结果集对应的数据库列名的映射名
-->
<id column="id" property="id"/>
<result column="name" property="name"/>
<result column="pwd" property="password"/>
</resultMap>
<select id="selectUser" resultMap="UserMap">
select * from user
</select>
使用场景:任何场景,这是最推荐的方式