【SSM框架集成】jdbc.properties数据库log4j.properties日志 applicationContext.xml配置applicationContext-mvc.xml pom

jdbc.properties配置连接数据库四大金刚

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

log4j.propertiesas日志文件配置

# ERROR错误的日志 WARN:警告 INFO:普通信息  DEBUG:调试日志  TRACE:日志
log4j.rootLogger=ERROR, stdout
#log4j.rootLogger=NONE
#把左边包名改成你自己的包名
log4j.logger.cn.itsource=TRACE
# 日志打印到控制台中
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
# 日志打印的一种格式（可以灵活地指定布局模式）
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
# 日志打印的格式是什么样子的  %d:日期 %p:优先级 %c:类的全名  %m:输出的结果 %n:换行
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

myBatis-config.xml文件配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!-- configuration:配置(xml的一个根)-->
<configuration>
    <properties resource="jdbc.properties" />
    <!--<typeAliases>
        <package name="cn.itsource.domain" />
        <package name="cn.itsource.query" />
    </typeAliases>-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--引入(找到)写SQL的XML-->
        <!--<mapper resource="cn/itsource/dao/ProductMapper.xml"/>-->
        <!--<mapper resource="cn/itsource/_01_mapper/mapper/EmployeeMapper.xml"/>-->
        <!--<mapper resource="cn/itsource/_02_many2one_result/ProductMapper.xml"/>-->
        <mapper resource="cn/itsource/_03_many2one_search/ProductMapper.xml"/>
    </mappers>
</configuration>

写SQL的xml

<?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的命名空间和接口的全限定名一致-->
<mapper namespace="cn.itsource._01_mapper.mapper.EmployeeMapper">

    <!--准备一个代码块-->
    <sql id="whereSql">
        <where>
            <if test="name!=null and name!=''">
                and name like concat("%",#{name},"%")
            </if>
            <if test="minAge!=null">
                and age >= #{minAge}
            </if>
            <if test="maxAge!=null">
                <![CDATA[
                   and age <= #{maxAge}
                 ]]>
            </if>
        </where>
    </sql>

    <!--查询一共多少条数据-->
    <select id="getCount" resultType="long" parameterType="cn.itsource._01_mapper.query.EmployeeQuery">
      select count(*) from employee
      <include refid="whereSql" />
    </select>
    <!--
        条件查询的语句
            CDATA:区中的数据不会被识别为语法
     -->
    <select id="queryAll" parameterType="cn.itsource._01_mapper.query.EmployeeQuery"
            resultType="cn.itsource._01_mapper.domain.Employee">
        select * from employee
        <include refid="whereSql" />
    </select>

    <!--  这里的id必需和方法名对应 -->
    <select id="findOne" parameterType="long" resultType="cn.itsource._01_mapper.domain.Employee">
        select * from employee where id= #{id}
    </select>

    <!--查询所有-->
    <select id="findAll" resultType="cn.itsource._01_mapper.domain.Employee">
        select * from employee
    </select>
</mapper>

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.springframew