Mybatis_D2相关配置

最新推荐文章于 2024-08-13 14:08:28 发布

是夏天小仙女啊

最新推荐文章于 2024-08-13 14:08:28 发布

阅读量48

点赞数

文章标签： spring java mysql

本文链接：https://blog.csdn.net/weixin_40631386/article/details/109378146

版权

日志文件
log4j的作用在控制台能够看到mybatis所执行的sql语句

`# Global logging configuration log4j的全局配置
log4j.rootLogger=ERROR, stdout log4j和mybatis的相关配置  跟踪的是.java文件夹的项目
log4j.logger.mapper=TRACE
# 控制台输出配置 Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n`

mybatis事务管理：原子性-要不同时提交，要不都不提交
注意：
延迟加载–减少性能开销要什么表，查什么表

在配置中添加一个settings
在这里插入图片描述

<!--延迟加载配置-->
<settings>
    <!--打开延迟加载的开关-->
    <setting name="lazyLoadingEnabled" value="true"/>
    <!--要将积极加载改为消极加载-->
    <setting name="aggressiveLazyLoading" value="false"/>
</settings>`

配置加载后：只查询分类表–不会获取相关联的表
在这里插入图片描述

mybatis分页
测试结果：

package test;

import mapper.CategoryMapper;
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 pojo.Category;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class testFenye {
    public static void main(String[] args) throws IOException {
//    注解方式分页测试
        String resource = "mybatis_config.xml";
        //        根据我们的mybatis-config.xml文件得到对应的SqlSessionFactory
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //        根据我们的sqlSessionFactory得到session
        SqlSession session = sqlSessionFactory.openSession();
        CategoryMapper mapper = session.getMapper(CategoryMapper.class);//根据反射获取
        List<Category> cs=mapper.listByPage(0,5);
        for (Category c:cs
             ) {
            System.out.println(c);
        }
    }
}

 使用pageHelper插件方式
 pom.xml导包：
```java
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.2-beta</version>
</dependency>

<dependency>
  <groupId>com.github.jsqlparser</groupId>
  <artifactId>jsqlparser</artifactId>
  <version>1.0</version>
</dependency>

核心文件加入插件：告诉idel我要用这个插件
在这里插入图片描述测试pageHepler插件:

package test;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import mapper.CategoryMapper;
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 pojo.Category;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class testFenye {
    public static void main(String[] args) throws IOException {
//    注解方式分页测试
        String resource = "mybatis_config.xml";
        //        根据我们的mybatis-config.xml文件得到对应的SqlSessionFactory
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //        根据我们的sqlSessionFactory得到session
        SqlSession session = sqlSessionFactory.openSession();
        CategoryMapper mapper = session.getMapper(CategoryMapper.class);//根据反射获取
      /*  普通分页
      List<Category> cs=mapper.listByPage(0,5);
        for (Category c:cs
             ) {
            System.out.println(c);
        }*/

//        使用pageHelper进分页显示
        PageHelper.offsetPage(0,5);
        List<Category> cs=mapper.listByPage();
   /*     for (Category c:cs
             ) {
            System.out.println(c.getName());
        }*/
        PageInfo pageInfo=new PageInfo<>(cs);
        System.out.println("分类表总数："+pageInfo.getTotal());
        System.out.println(pageInfo);
        session.commit();
        session.close();
    }
}

一级缓存
log文件不出现解决方案：
如果使用的不是同一个session对象缓存读取的时候就会读取不到必须从库中获取
所以出现了两次sql语句查询一级缓存失效
一级缓存失效的情况
1.sqlsession不同会导致（没有使用到同一级缓存还是要向数据库发送请求）
2.sqlsession相同但是查询条件不同
3.sqlsession相同但是两次查询之间进行了增改删查操作
4.sqlsession相同，手动清除了缓存 session.clearCache();
二级缓存
1.第一步

2.第二步
3.第三步
测试结果：
druid连接池
mybatisGenerate
mybatis

SSM整合

Spring IOC DI 创建对象
SpringMVC Controller 控制器
Mybatis Model 模型

缺点是配置文件过多–springboot可以简化

使用MAVEN创建SSM：
1.在浏览器中输入url listCategory
tomcat 接收到url的时候根据web.xml配置把请求交给DispatcherServlet进行处理
DispatcherServlet做拦截会根据springMVC中去找对应的Categorycontroller
所以需要实例化 spring的注解@Autowired会自动装配需要实例化一个Service对象又要实例化mapper对象
后台生成的xml

在这里插入图片描述
2.3.pom.xml更新依赖–搭ssm环境

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.syx</groupId>
  <artifactId>ssm_D1030</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>

  <properties>
    <spring.version>4.1.3.RELEASE</spring.version>
    <pagehelper.version>5.1.2-beta</pagehelper.version>
    <mysql.version>5.1.6</mysql.version>
    <mybatis.spring.version>1.2.3</mybatis.spring.version>
    <mybatis.version>3.1.1</mybatis.version>
    <junit.version>4.12</junit.version>
    <jstl.version>1.2</jstl.version>
    <jsqlparser.version>1.0</jsqlparser.version>
    <jackson.version>1.2.7</jackson.version>
    <servlet-api.version>3.1.0</servlet-api.version>
    <druid.version>1.0.18</druid.version>
    <log4j.version>1.2.12</log4j.version>
    <commons-logging.version>1.2</commons-logging.version>
    <commons-fileupload.version>1.2.1</commons-fileupload.version>
    <commons-io.version>1.3.2</commons-io.version>
    <commons-lang.version>2.6</commons-lang.version>
    <aopalliance.version>1.0</aopalliance.version>
    <mybatis-generator.version>1.3.5</mybatis-generator.version>
    <lombok.version>1.18.12</lombok.version>
  </properties>

  <dependencies>


    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>${junit.version}</version>
    </dependency>
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>${lombok.version}</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybatis.spring.version}</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>${druid.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- JSP相关 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>${jstl.version}</version>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>${servlet-api.version}</version>
      <scope>provided</scope>
    </dependency>

    <!-- pageHelper -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>${pagehelper.version}</version>
    </dependency>

    <!--jsqlparser-->
    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>${jsqlparser.version}</version>
    </dependency>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>${commons-logging.version}</version>
    </dependency>

    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>${commons-fileupload.version}</version>
    </dependency>

    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>${commons-io.version}</version>
    </dependency>

    <dependency>
      <groupId>commons-lang</groupId>
      <artifactId>commons-lang</artifactId>
      <version>${commons-lang.version}</version>
    </dependency>

    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>${aopalliance.version}</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>${mybatis-generator.version}</version>
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.36</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.9.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.9.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.9.0</version>
    </dependency>


  </dependencies>

  <build>
    <finalName>${project.artifactId}</finalName>
    <plugins>
      <!-- 资源文件拷贝插件 -->
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-resources-plugin</artifactId>
        <version>2.4</version>
        <configuration>
          <encoding>UTF-8</encoding>
        </configuration>
      </plugin>
      <!-- java编译插件 -->
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.2</version>
        <configuration>
          <source>1.8</source>
          <target>1.8</target>
          <encoding>UTF-8</encoding>
        </configuration>
      </plugin>
    </plugins>


    <resources>
      <resource>
        <directory>src/main/resources</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
          <include>**/*.tld</include>
        </includes>
        <filtering>false</filtering>
      </resource>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>

  </build>

</project>

4.resource文件夹下配置文件

在这里插入图片描述
ssm项目出现的问题：
解决：
2.
结果：

是夏天小仙女啊

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Mybatis_D2相关配置

日志文件log4j的作用在控制台能够看到mybatis所执行的sql语句`# Global logging configuration log4j的全局配置log4j.rootLogger=ERROR, stdout log4j和mybatis的相关配置跟踪的是.java文件夹的项目log4j.logger.mapper=TRACE# 控制台输出配置 Console output...log4j.appender.stdout=org.apache.log4j.ConsoleApp.
复制链接

扫一扫