MyBatis高级及其SSM框架搭建

代码生成器

首先meaven项目中导入支持包

 <dependencies>
     <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
     <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
         <version>5.1.46</version>
     </dependency>

     <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
     <dependency>
         <groupId>org.mybatis</groupId>
         <artifactId>mybatis</artifactId>
         <version>3.2.1</version>
     </dependency>
     <dependency>
         <groupId>org.slf4j</groupId>
         <artifactId>slf4j-api</artifactId>
         <version>1.6.1</version>
     </dependency>
     <dependency>
         <groupId>org.slf4j</groupId>
         <artifactId>slf4j-log4j12</artifactId>
         <version>1.6.1</version>
         <scope>runtime</scope>
     </dependency>
     <dependency>
         <groupId>log4j</groupId>
         <artifactId>log4j</artifactId>
         <version>1.2.14</version>
     </dependency>

     <!-- https://mvnrepository.com/artifact/junit/junit -->
     <dependency>
         <groupId>junit</groupId>
         <artifactId>junit</artifactId>
         <version>4.12</version>
         <!--<scope>test</scope>-->
     </dependency>
 </dependencies>

 <build>
     <plugins>
         <plugin>
             <groupId>org.apache.maven.plugins</groupId>
             <artifactId>maven-compiler-plugin</artifactId>
             <configuration>
                 <source>1.8</source>
                 <target>1.8</target>
             </configuration>
         </plugin>
     </plugins>
 </build>

准备代码生成器插件

pom.xml

 build>
     <plugins>
         <!--代码生成器插件-->
         <plugin>
             <groupId>org.mybatis.generator</groupId>
             <artifactId>mybatis-generator-maven-plugin</artifactId>
             <version>1.3.2</version>
             <configuration>
                 <!--自定义代码生成器的路径-->
                 <!--<configurationFile>yourLocation/mybatis-generator-config.xml</configurationFile>-->
                 <verbose>true</verbose>
                 <overwrite>true</overwrite>
             </configuration>
         </plugin>
     </plugins>
 </build>

generatorConfig.xml

这个xml在resource中名字必须要是这个，否者会报错。

 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE generatorConfiguration
         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
 <!-- 自动生成器的配置(根目录，不做过多介绍)-->
 <generatorConfiguration>
     <!--
         classPathEntry：可以配置多个，也不配置
         数据库驱动:这里找到相应的驱动jar包就可以了(注:不同数据库的jar不一样)
             location:里面的是路径(也可以直接写绝对路径 -> 如:E:\mybatis\mysql-connector-java-5.1.26-bin.jar)
     -->
     <classPathEntry   location="G:\openSource\mysql-connector-java-5.1.26-bin.jar"/>
     <!--
         context：用于生成一组对象的环境(至少配置1个，可以配置多个)
         id:表达唯一的名称
         targetRuntime：用于指定生成的代码的运行环境(MyBatis3/MyBatis3Simple)
             MyBatis3:默认值【生成更完整的功能】
             MyBatis3Simple：不会生成与Example(案例)相关的方法
     -->
     <context id="DB2Tables"   targetRuntime="MyBatis3Simple" >
         <!--
             用于配置如果生成注释信息(最多可以配置一下)
             suppressAllComments:阻止生成注释 ，默认为false
             suppressDate:阻止生成的注释 时间戳，默认为false
             addRemarkComments：注释是否添加数据库表的备注信息，默认为false
          -->
         <commentGenerator>
             <property name="suppressDate" value="true"/>
             <property name="suppressAllComments" value="true"/>
         </commentGenerator>
         <!--
             这个应该比较清楚，配置连接数据库的基本信息
         -->
         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                         connectionURL="jdbc:mysql:///mybatis"
                         userId="root" password="admin">
         </jdbcConnection>
         <!--
             用于指定JDBC类型和Java类型如何转换，最多可以配置一个
             forceBigDecimals:控制是否强制将DECIMAL和NUMERIC类型的JDBC字段转换成Java类型的 BigDecimal
                              默认为false,一般不需要配置
         -->
         <javaTypeResolver>
             <property name="forceBigDecimals" value="false"/>
         </javaTypeResolver>

         <!--
             javaModelGenerator:用来控制生成的实体类
                 targetPackage：生成Model类存放位置(包名)
                 targetProject：指定目标项目路径(根目录)
                 对应的子属性:
                     trimStrings：判断是否对数据库查询结果进行trim操作(默认false)
         -->
         <javaModelGenerator targetPackage="cn.itsource._02_generator.domain" targetProject="src/main/java">
             <property name="trimStrings" value="true"/>
         </javaModelGenerator>
         <!--
             sqlMapGenerator：生成映射文件存放位置(Mapper.xml文件)
                 targetPackage:生成SQL映射文件(XML文件)在哪个包中
                 targetProject:指定目标项目路径(根目录)
         -->
         <sqlMapGenerator targetPackage="cn.itsource._02_generator.mapper" targetProject="src/main/resources">
         </sqlMapGenerator>

         <!--
             javaClientGenerator：Java客户端生成器(生成Dao/Mapper的接口)
                                 该 标签可选(最多配置一个)，如果不配置，就不会生成Mapper接口
                 type:选择客户端代码生成器
                     MyBatis3
                         ANNOTATEDMAPPER：基于注解的Mapper接口，不会有对应的XML映射文件
                         MIXEDMAPPER:XML和注解混合形式
                         XMLMAPPER：所有方法都在XML中(接口调用依赖XML)
                     MyBatis3Simple
                         ANNOTATEDMAPPER：基于注解的Mapper接口，不会有对应的XML映射文件
                         XMLMAPPER：所有方法都在XML中(接口调用依赖XML)
                 targetPackage：生成Mapper接口存放的包名
                 targetProject：指定目标项目路径
         -->
         <javaClientGenerator type="XMLMAPPER" targetPackage="cn.itsource._02_generator.mapper" targetProject="src/main/java">
             <property name="enableSubPackages" value="true"/>
         </javaClientGenerator>
         <!--
             table：生成对应表及类名
                 tableName：对应表名(注:%代表所有)
                 domainObjectName:对应的类名
                 generatedKey：主键自增的id字段(针对当前 数据库配置MySQL)
         -->
         <table tableName="employee" domainObjectName="Employee">
             <generatedKey column="id" sqlStatement="MySql" />
         </table>

        <!--
         <table tableName="%" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
                enableSelectByExample="false" selectByExampleQueryId="false" >
         </table>
         -->
     </context>
 </generatorConfiguration>

MyBatis拦截器

 //配置查询拦截
 @Intercepts(
         @Signature(
                 type = Executor.class,
                 method = "query",
                 args = {MappedStatement.class,Object.class, RowBounds.class, ResultHandler.class}

         )
 )
 public class myinterceptor implements Interceptor {

     @Override
     public Object intercept(Invocation invocation) throws Throwable {
         System.out.println("这里是拦截器");
         return invocation.proceed();
     }

     @Override
     public Object plugin(Object o) {
         return Plugin.wrap(o,this);
     }

     @Override
     public void setProperties(Properties properties) {

     }
 }

拦截器的配置

在mybatis-config.xml中进行配置

<!--插件配置(拦截器配置)-->
<plugins>
    <plugin interceptor="cn.itsource._02_generator.interceptor.HelloInterceptor">
        <property name="dbType" value="mySql" />
    </plugin>
</plugins>

分页插件

引入这个插件

 <!-- 分页插件 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.0.0</version>
</dependency>

插件配置

在mybatis-config.xml中进行配置

<plugins>
    <!--配置分页插件-->
    <plugin interceptor="com.github.pagehelper.PageInterceptor" />
</plugins>

使用分页插件

 @Test
 public void testPage() throws Exception{
     //分页 pageNum:第几页  pageSize:每页条数
     PageHelper.startPage(1, 10);

     SqlSession session = MyBatisUtil.openSession();
     EmployeeMapper mapper = session.getMapper(EmployeeMapper.class);
     List<Employee> employees = mapper.selectAll();
     Page page = (Page) employees;
     System.out.println("第几页:"+page.getPageNum()); //第几页
     System.out.println("总页数:"+page.getPages()); //总页数
     System.out.println("总条数:"+page.getTotal()); //总页数
     System.out.println("结果:"+page.getResult());

     page.getResult().forEach(e -> System.out.println(e));
 }

SSM集成

首先是jdbc.properites

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///mybatis
jdbc.username=root
jdbc.password=admin

然后配置applicationContext.xm

 <?xml version="1.0" encoding="UTF-8"?>
 <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        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.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
 ">

     <!--扫描Service层-->
     <context:component-scan base-package="cn.newsoft.service" />

     <!--引入jdbc.properties-->
     <context:property-placeholder location="classpath:jdbc.properties" />
     <!--创建数据源(dataSource)-->
     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
         <property name="driverClassName" value="${jdbc.driverClassName}" />
         <property name="url" value="${jdbc.url}" />
         <property name="username" value="${jdbc.username}" />
         <property name="password" value="${jdbc.password}" />
     </bean>

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
         <property name="dataSource" ref="dataSource" />
         <!--XML的映射-->
         <property name="mapperLocations" value="classpath:cn/newsoft/mapper/*.xml" />
         <!--为所有相应的包中的类取别名-->
         <property name="typeAliasesPackage" value="cn.newsoft.domain" />
     </bean>

    <!--创建映射器-->
     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
         <property name="basePackage" value="cn.newsoft.mapper" />
     </bean>

     <!--配置事务管理器-->
     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
         <property name="dataSource" ref="dataSource" />
     </bean>
     <!--配置标签支持事务-->
     <tx:annotation-driven transaction-manager="transactionManager" />
 </beans>

l这样就完成了mybatis和sping的集成了，需要注意的是，在mapper.xml在resource中的位置需要与在src中mapper的位置对应上才行

，

Spring与SpringMVC

applicationContext-mvc.xml

 <?xml version="1.0" encoding="UTF-8"?>
 <beans xmlns="http://www.springframework.org/schema/beans"

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
                     http://www.springframework.org/schema/beans/spring-beans.xsd
                     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                    http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
 ">
     <!--配置包扫描-->
     <context:component-scan base-package="cn.newsoft.controller"></context:component-scan>
     <!--注解支持-->
     <mvc:annotation-driven></mvc:annotation-driven>

         <!--静态资源访问-->
     <mvc:default-servlet-handler />
         <!--视图解析器-->
     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
         <property name="prefix" value="/WEB-INF/views"></property>
         <property name="suffix" value=".jsp"></property>
     </bean>
     <!--上传文件-->
     <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
         <!-- 设置上传文件的最大尺寸为1MB -->
         <property name="maxUploadSize">
             <value>1048576</value>
         </property>
     </bean>

 </beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
          http://java.sun.com/xml/ns/javaee/web-app_4_0.xsd"
           version="3.0">
        <!--解决乱码问题-->
    <filter>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--读取sping配置文件-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!--读取mvc文件-->
    <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:applicationContext-mvc.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>