说说mybatis的流程

mybatsi是什么？

mybatis是半ORM的持久性框架，其实就是我们寻常web项目的JDBC的模块。

 

mybatis的开发步骤

1. 实体

2. 实体别名

3. 表

4. 创建DAO接口

5. 实现Mapper文件

6. 注册Mapper文件

7. MybatisAPI调用

 

mybatis的基本开发流程

1.定义实体类



package pojo;





/**

* @author xc

* @Classname User

* @Description TODO

* @Date 2020/7/21 8:44

*/

public class User {





    private String username;

    private String password;





    public void setUsername(String username) {

        this.username = username;

    }





    public void setPassword(String password) {

        this.password = password;

    }

}







2：配置mybatis-config.xml配置别名

<typeAliases>

    <package name="pojo"/>

    <!--<typeAlias type="pojo.User" alias="user"/>-->

</typeAliases> 



3 创建sql表

略



4创建dao接口

package dao;

import pojo.User;

/**

* @author xc

* @Classname SaveDao

* @Description TODO

* @Date 2020/7/21 8:45

*/

public interface UserDao {

    public void saveUser(User user);

}



6 实现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="dao.UserDao">

    <insert id="saveUser" parameterType="user">

        insert into user values(#{username},#{password});

    </insert>

</mapper>





7.mybatis-config注册mapper

<mappers>

    <mapper resource="mapper/UserMapper.xml"></mapper>

</mappers>



8 配置连接池 mybatis的api 相关

8-1 mybatis-config.xml 配置连接池相关

<environments default="mysql">

    <environment id="mysql">

        <transactionManager type="JDBC"></transactionManager>

        <dataSource type="POOLED">

            <property name="driver" value="com.mysql.jdbc.Driver"/>

            <property name="url" value="jdbc:mysql://localhost:3306/test721"/>

            <property name="username" value="root"/>

            <property name="password" value="123"/>

        </dataSource>

    </environment>

</environments>



8-2 编写mybatis测试类  

public void test() throws IOException {





        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        SqlSession sqlSession = sqlSessionFactory.openSession();

        UserDao userDao = sqlSession.getMapper(UserDao.class);

        User user = new User();

        user.setUsername("112");

        user.setPassword("123");

        userDao.saveUser(user);

        sqlSession.commit();





}

MyBatis进⾏持久开发过程存在⼤量的代码冗余，最后一步的代码感觉是不是相当的繁琐 ？

spring整合mybatis帮我们解决了这个问题  

如果我们把userDao对象注入容器中,让spring去管理我们的Dao对象，如果我们想要进行数库操作 直接对从容器中获取的dao对象进行操作不就行了吗？其实spring也是这样做的 

spring整合mybatis需要applicationContext.xml

applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd

    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd

    http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

    

    <!--首先我们要创建数据库连接池 -->

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">

    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>

    <property name="url" value="jdbc:mysql://localhost:3306/test721"></property>

    <property name="username" value="root"></property>

    <property name="password" value="123"></property>

</bean>

<!--创建SqlSessionFactoryBean   如果mybatis-config.xml配置了mapper文件位置，在SessionFactory继续创建会报错 -->

<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

    <property name="dataSource" ref="dataSource"></property>

    <property name="configLocation" value="mybatis-config.xml"></property>

    <property name="mapperLocations" value="mapper/UserMapper.xml"></property>

</bean>



<!--创建 Dao对象  通过MapperScannerConfigurer类 -->

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

    <property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>

    <property name="basePackage" value="dao"/>

</bean>

    

</beans>

 

spring整合mybatis vs  mybatis

spring整合mybatis测试 

public void test2()

{

    ApplicationContext application = new ClassPathXmlApplicationContext("applicationContext.xml");





    UserDao userDao = application.getBean("userDao", UserDao.class);





    User user = new User();

    user.setPassword("12323");

    user.setUsername("231312313123");

    userDao.saveUser(user);



}