Mybatis
Mybatis入门
创建maven项目导入依赖
创建对应的实体类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Integer id;
private String username;
private String password;
private String email;
private String tel;
}
编写UserDao
package com.mybatiss.dao;
import com.mybatiss.entity.User;
public interface UserDao {
User getUserById(Integer id);
int addUser(User user);
int updateUser(User user);
int delUser(Integer id);
User getUser(Integer id, String username);
}
MyBatis配置文件
<?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/bbb" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
<!--对应实体类的配置映射-->
<mappers>
<mapper resource="mapper/UserMapping.xml"></mapper>
</mappers>
</configuration>
创建映射文件
<?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="com.mybatiss.dao.UserDao">
<select id="getUserById" parameterType="int" resultType="com.mybatiss.entity.User">
select * from user where id=#{id}
</select>
<insert id="addUser">
insert into user values(#{id},#{username},#{password},#{email},#{tel})
</insert>
<update id="updateUser">
update user set username = #{username},password = #{password},email = #{email},tel = #{tel} where id = #{id}
</update>
<delete id="delUser">
delete from user where id = #{id}
</delete>
<select id="getUser" resultType="com.mybatiss.entity.User">
select * from user where id = #{param1} and username = #{param2}
</select>
</mapper>
创建测试
package com.mybatiss.test;
import com.mybatiss.dao.UserDao;
import com.mybatiss.entity.User;
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.Reader;
public class Test2 {
public static void main(String[] args) throws IOException {
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sqlSessionFactory.openSession();
UserDao userDao = session.getMapper(UserDao.class);
User user = userDao.getUserById(2);
System.out.println(user);
/*int i = userDao.addUser(new User(null, "xxzx", "12332", "23435@qq.com", "1293791374"));
session.commit();
System.out.println(i);*/
/* userDao.updateUser(new User(148, "xxzx", "12332", "23435@qq.com", "1293791374"));
session.commit();*/
/*int i = userDao.delUser(148);
session.commit();*/
/* User user22 = userDao.getUser(2, "李思思");
System.out.println(user22);*/
}
}
常见错误
数据库时区错误
解决方案:在数据库的url后加入时区
jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
mapper.xml配置错误
原因:上图原因是配置的问题,有两种情况,按需修改下图蓝线位置
解决方案:
情况1:主配置文件Mybatis-config.xml的mapper配置错误
情况2:UserMapper.xml resultType全路径写错
main方法测试报错
解决方案:推荐使用Junit测试单元,也有可能是maven和idea的版本不兼容问题,可以尝试降低版本
参数不对应错误
UserMapper.xml里面的参数与调用时不对应
解决方案1:UserDao中方法参数添加注解
User getUser(@Param("id") Integer id,@Param("username") String username);
解决方案2:UserMapper.xml中使用参数占位符
<select id="getUser" resultType="com.mybatiss.entity.User">
select * from user where id = #{param1} and username = #{param2}
</select>