driver=com.mysql.jdbc.Driver

#mytest为我本地的数据库名

url=jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf-8

username=root

#下面输入自己数据库的密码

password=***********

#定义初始连接数

initialSize=0

#定义最大连接数

maxActive=20

#定义最大空闲

maxIdle=20

#定义最小空闲

minIdle=1

#定义最长等待时间

maxWait=60000

<?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:beans="http://www.springframework.org/schema/beans"

       xmlns:mvc="http://www.springframework.org/schema/mvc"

       xsi:schemaLocation="http://www.springframework.org/schema/beans

         http://www.springframework.org/schema/beans/spring-beans-4.3.xsd

         http://www.springframework.org/schema/context

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

         http://www.springframework.org/schema/mvc

         http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd"  >

    <!-- ①：对com.springmvc包中的所有类进行扫描，以完成Bean创建和自动依赖注入的功能 -->

    <context:component-scan base-package="com.springmvc"/>

    <mvc:annotation-driven />

    <!-- 静态资源访问 -->

    <!--如果webapp下你新建了文件夹，想访问里面的静态资源，那么就要在这配置一下-->

    <mvc:resources location="/images/" mapping="/images/**"/>

    <mvc:resources location="/css/" mapping="/css/**"/>

    <mvc:resources location="/styles/" mapping="/styles/**"/>

    <mvc:resources location="/js/" mapping="/js/**"/>

    <!-- Configures the @Controller programming model

    <mvc:annotation-driven />-->

    <!-- ②：启动Spring MVC的注解功能，完成请求和注解POJO的映射 -->

    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">

        <property name="messageConverters">

            <list>

                <ref bean="mappingJacksonHttpMessageConverter"/>

            </list>

        </property>

    </bean>

    <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">

        <property name="supportedMediaTypes">

            <list>

                <value>application/json;charset=UTF-8</value>

            </list>

        </property>

    </bean>

    <!-- 配置视图解析器，把控制器的逻辑视频映射为真正的视图 -->

    <!-- /WEB-INF/jsp/start.jsp -->

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>

        <property name="prefix" value="/WEB-INF/views/" />

        <property name="suffix" value=".jsp" />

    </bean>

    <!-- 配置dbcp数据库连接池 -->

    <!-- <context:property-placeholder location="classpath:db.properties"/> -->

    <!--数据库配置 -->

    <bean id = "propertyConfigurer" class = "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

        <property name="locations">

            <list>

                <value>classpath:jdbc.properties</value>

            </list>

        </property>

    </bean>

    <!-- 数据库连接池 -->

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

        <property name="driverClassName" value="${driver}"/>

        <property name="url" value="${url}"/>

        <property name="username" value="${username}"/>

        <property name="password" value="${password}"/>

        <property name="initialSize" value="1"/>

        <property name="maxActive" value="100"/>

        <property name="maxIdle" value="5"/>

        <property name="maxWait" value="80000"/>

    </bean>

    <!-- 配置事务管理器 -->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

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

    </bean>

    <!-- 拦截器 -->

    <mvc:interceptors>

        <!-- 国际化操作拦截器 如果采用基于（请求/Session/Cookie）则必需配置 -->

        <bean class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor" />

    </mvc:interceptors>

    <!-- 定义无Controller的path<->view直接映射 -->

    <!-- <mvc:view-controller path="/" view-name="redirect:/" /> -->

</beans>

### set log levels ###

log4j.rootLogger = INFO,D

###输出到控制台###

log4j.logger.toConsole=debug,stdout

log4j.appender.stdout = org.apache.log4j.ConsoleAppender

log4j.appender.stdout.Target = System.out

log4j.appender.stdout.layout = org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern =%d{yyyy-MM-dd HH\:mm\:ss} [%5p] - %c -%F(%L) -%m%n

### 输出到日志文件 ###

##  其中File 可以采用绝对路径 亦可以采用相对路径 catalina.home 是tomcat目录  如果没有logs文件夹 将会报错  ##

##  更加倾向于将日志文件放在  tomcat的日志目录下${catalina.home}/logs/salesmanb2bError.log ##

##  绝对路径如：e:/salesmanb2bError.log ##

log4j.logger.daily=INFO,D

log4j.appender.D = org.apache.log4j.DailyRollingFileAppender

log4j.appender.D.File = ${catalina.home}/logs/helloworld/helloworld.log

log4j.appender.D.Append = true

log4j.appender.D.Threshold = INFO

log4j.appender.D.layout = org.apache.log4j.PatternLayout

log4j.appender.D.layout.ConversionPattern =%d{yyyy-MM-dd HH\:mm\:ss} [%5p] - %c -%F(%L) -%m%n

##log4j.logger.org.apache.ibatis=debug,stdout

##log4j.logger.java.sql=debug,stdout

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">

  <display-name>helloworld</display-name>

  <!-- 配置编码方式-->

  <filter>

    <filter-name>encodingFilter</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>encodingFilter</filter-name>

    <url-pattern>/*</url-pattern>

  </filter-mapping>

  <!-- 配置springmvc的前端控制器 指向spring-mvc.xml 程序在启动的时候就加载springmvc 可以接受所有请求 load-on-startup：表示启动容器时初始化该Servlet； -->

  <servlet>

    <servlet-name>springServlet</servlet-name>

    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

    <!-- 可以自定义servlet.xml配置文件的位置和名称， 默认为WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，如spring-servlet.xml -->

    <init-param>

      <param-name>contextConfigLocation</param-name>

      <param-value> classpath:spring/applicationContext.xml</param-value>

    </init-param>

    <load-on-startup>1</load-on-startup>

  </servlet>

  <!-- 将前端URL请求和后台处理方法controller建立对应关系-->

  <servlet-mapping>

    <servlet-name>springServlet</servlet-name>

    <url-pattern>/</url-pattern>

  </servlet-mapping>

  <!-- Spring配置 -->

  <listener>

    <listener-class>

      org.springframework.web.context.ContextLoaderListener

    </listener-class>

  </listener>

  <!-- 取消对某一类文件的拦截-->

  <servlet-mapping>

    <servlet-name>default</servlet-name>

    <url-pattern>*.md</url-pattern>

  </servlet-mapping>

  <context-param>

    <param-name>contextConfigLocation</param-name>

    <param-value> classpath:spring/applicationContext.xml</param-value>

  </context-param>

  <!-- 欢迎页面-->

  <welcome-file-list>

    <welcome-file>/WEB-INF/index.jsp</welcome-file>

  </welcome-file-list>

  <!--404错误展示页面，可自行配置-->

  <!--<error-page>-->

  <!--<error-code>404</error-code>-->

  <!--<location>/WEB-INF/views/404.jsp</location>-->

  <!--</error-page>-->

  <!--设置session失效时间为30分钟 -->

  <session-config>

    <session-timeout>600</session-timeout>

  </session-config>

</web-app>

<!-- 配置会话工厂SqlSessionFactory -->

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

        <!-- 数据源 -->

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

        <property name="mapperLocations" value="classpath:sqlmap/*Mapper.xml"/>

        <property name="typeAliasesPackage" value="com.springmvc.entity" />

    </bean>

    <!-- 在spring容器中配置mapper的扫描器产生的动态代理对象在spring的容器中自动注册，bean的id就是mapper类名（首字母小写）-->

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

        <!-- 指定扫描包的路径，就是mapper接口的路径，多个包中间以 半角逗号隔开   -->

        <property name="basePackage" value="com.springmvc.dao"/>

        <!-- 配置sqlSessionFactoryBeanName -->

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

    </bean>

<?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>

    <!--导入属性配置 -->

    <properties resource="generator.properties"/>

    <classPathEntry

            location="D:\server\maven\repository\mysql\mysql-connector-java\5.1.29\mysql-connector-java-5.1.29.jar" />

    <context id="context1">

        <!-- 注释 -->

        <commentGenerator>

            <property name="suppressAllComments" value="true" /><!-- 是否取消注释 -->

            <property name="suppressDate" value="true" /> <!-- 是否生成注释代时间戳 -->

        </commentGenerator>

        <jdbcConnection driverClass="${driver}"

                        connectionURL="${url}"

                        userId="${username}"

                        password="${password}" />

        <!-- 类型转换 -->

        <javaTypeResolver>

            <!-- 是否使用bigDecimal， false可自动转化以下类型（Long, Integer, Short, etc.） -->

            <property name="forceBigDecimals" value="false" />

        </javaTypeResolver>

        <javaModelGenerator targetPackage="${modelPackage}"

                            targetProject="${modelProject}" />

        <sqlMapGenerator targetPackage="${sqlPackage}" targetProject="${sqlProject}" />

        <javaClientGenerator targetPackage="${mapperPackage}"

                             targetProject="${mapperProject}" type="XMLMAPPER" />

        <!-- 如果需要通配所有表 直接用sql的通配符    %即可 -->

        <table schema="" tableName="${table}" enableCountByExample="false"

               enableUpdateByExample="false" enableDeleteByExample="false"

               enableSelectByExample="false" selectByExampleQueryId="false"/>

    </context>

</generatorConfiguration>

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf-8

username=root

password=*********

#entity 包名和 java目录

modelPackage=com.springmvc.entity

modelProject=src/main/java

#sqlmap包名 和resources目录

sqlPackage=sqlmap

sqlProject=src/main/resources

#mapper包名和 java目录

mapperPackage=com.springmvc.dao

mapperProject=src/main/java

table=message

use mytest;

CREATE TABLE `message` (

    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

    `command` varchar(30) NOT NULL,

    `description` varchar(30) NOT NULL,

    `content` varchar(30) NOT NULL,

    PRIMARY KEY (`id`)

)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

select * from message;

package com.springmvc.dao;

import com.springmvc.entity.Message;

import org.junit.After;

import org.junit.Before;

import org.junit.Test;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import static org.junit.Assert.*;

/**

 * Created by toutou on 2018/5/10.

 */

public class MessageMapperTest {

    private ApplicationContext applicationContext;

    @Autowired

    private MessageMapper mapper;

    @Before

    public void setUp() throws Exception {

        // 加载spring配置文件

        applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");

        // 导入需要测试的

        mapper = applicationContext.getBean(MessageMapper.class);

    }

    @After

    public void tearDown() throws Exception {

    }

    @Test

    public void insert() throws Exception {

        Message message = new Message();

        message.setCommand("吃饭");

        message.setContent("睡觉");

        message.setDescription("打豆豆");

        int result = mapper.insert(message);

        System.out.println(result);

        assert (result == 1);

    }

}