一、概念
1.Mybatis是优秀的持久层框架,对jdbc操作数据库的过程进行了封装,使开发者只需要关注sql本身;程序员只需要通过配置来进行设置
二、JDBC存在的问题
1.数据库连接创建,释放频繁造成资源浪费
2.sql语句在代码中硬编码
3.使用preparedStatement占位符号参数存在硬编码
4.结果集存在硬编码
三、Mybatis结构
四、使用步骤
1.导包
(1)Mybatis核心包
(2)Mybais依赖包
(3)数据库驱动包
(4)创建核心配置文件SqlMapConfig.xml
(5)创建Mapper.xml文件
具体代码如下:
//加载核心配置文件
InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
//创建一个SqlSessionFactory工厂
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//创建SqlSession
SqlSession sqlSession = sessionFactory.openSession();
//执行sql语句
创建SqlMapConfig.xml文件:
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
<?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:命名空间,用于隔离sql,还有一个很重要的作用,后面会讲 --> <mapper namespace="test"> <!--通过id查询一个用户 mybatis里面#{}代表占位符 --> <select id="findUserById" parameterType="Integer" resultType="com.sgr.bean.User"> select * from user where id = #{v} </select> <!--#{}表示的是占位符 ,变量名任意 ${}表示字符串拼接,两边不需要单引号,变量名字只能是value --> <select id="findUserByName" parameterType="String" resultType="com.sgr.bean.User"> select * from user where username like '%${value}%' </select> <insert id="insertUser" parameterType="com.sgr.bean.User"> <selectKey keyProperty="id" resultType="Integer" order="AFTER"> select LAST_INSERT_ID() </selectKey> insert into user (username,birthday,address,sex) values (#{username},#{birthday},#{address},#{sex}) </insert> <update id="updateUserById" parameterType="com.sgr.bean.User"> update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id} </update> <delete id="deleteUserById" parameterType="Integer"> delete from user where id=#{id} </delete> </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:命名空间,用于隔离sql,还有一个很重要的作用,后面会讲 --> <mapper namespace="test"> <!--通过id查询一个用户 mybatis里面#{}代表占位符 --> <select id="findUserById" parameterType="Integer" resultType="com.sgr.bean.User"> select * from user where id = #{v} </select> <!--#{}表示的是占位符 ,变量名任意 ${}表示字符串拼接,两边不需要单引号,变量名字只能是value --> <select id="findUserByName" parameterType="String" resultType="com.sgr.bean.User"> select * from user where username like '%${value}%' </select> <insert id="insertUser" parameterType="com.sgr.bean.User"> <selectKey keyProperty="id" resultType="Integer" order="AFTER"> select LAST_INSERT_ID() </selectKey> insert into user (username,birthday,address,sex) values (#{username},#{birthday},#{address},#{sex}) </insert> <update id="updateUserById" parameterType="com.sgr.bean.User"> update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id} </update> <delete id="deleteUserById" parameterType="Integer"> delete from user where id=#{id} </delete> </mapper>