配置

image.png

pom.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.   <modelVersion>4.0.0</modelVersion>
  7.   <groupId>com.atguigu.mp</groupId>
  8.   <artifactId>mp01</artifactId>
  9.   <version>1.0-SNAPSHOT</version>
  10.   <packaging>war</packaging>
  12.   <name>mp01 Maven Webapp</name>
  13.   <!-- FIXME change it to the project's website -->
  14.   <url>http://www.example.com</url>
  16.   <properties>
  17.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  18.     <maven.compiler.source>1.7</maven.compiler.source>
  19.     <maven.compiler.target>1.7</maven.compiler.target>
  20.   </properties>
  22.   <dependencies>
  23.     <dependency>
  24.       <groupId>junit</groupId>
  25.       <artifactId>junit</artifactId>
  26.       <version>4.11</version>
  27.       <scope>test</scope>
  28.     </dependency>
  30.     <dependency>
  31.     <groupId>com.baomidou</groupId>
  32.       <artifactId>mybatis-plus</artifactId>
  33.       <version>2.3</version>
  34.     </dependency>
  36.     <!-- log4j -->
  37.     <dependency>
  38.       <groupId>log4j</groupId>
  39.       <artifactId>log4j</artifactId>
  40.       <version>1.2.17</version>
  41.     </dependency>
  43.     <!-- c3p0 -->
  44.     <dependency>
  45.       <groupId>com.mchange</groupId>
  46.       <artifactId>c3p0</artifactId>
  47.       <version>0.9.5.2</version>
  48.     </dependency>
  50.     <!-- mysql -->
  51.     <dependency>
  52.       <groupId>mysql</groupId>
  53.       <artifactId>mysql-connector-java</artifactId>
  54.       <version>8.0.11</version>
  55.     </dependency>
  57.     <!-- spring -->
  58.     <dependency>
  59.       <groupId>org.springframework</groupId>
  60.       <artifactId>spring-context</artifactId>
  61.       <version>4.3.10.RELEASE</version>
  62.     </dependency>
  64.     <dependency>
  65.       <groupId>org.springframework</groupId>
  66.       <artifactId>spring-orm</artifactId>
  67.       <version>4.3.10.RELEASE</version>
  68.     </dependency>
  69.   </dependencies>
  71.   <build>
  72.     <finalName>mp01</finalName>
  73.     <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
  74.       <plugins>
  75.         <plugin>
  76.           <artifactId>maven-clean-plugin</artifactId>
  77.           <version>3.1.0</version>
  78.         </plugin>
  79.         <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
  80.         <plugin>
  81.           <artifactId>maven-resources-plugin</artifactId>
  82.           <version>3.0.2</version>
  83.         </plugin>
  84.         <plugin>
  85.           <artifactId>maven-compiler-plugin</artifactId>
  86.           <version>3.8.0</version>
  87.         </plugin>
  88.         <plugin>
  89.           <artifactId>maven-surefire-plugin</artifactId>
  90.           <version>2.22.1</version>
  91.         </plugin>
  92.         <plugin>
  93.           <artifactId>maven-war-plugin</artifactId>
  94.           <version>3.2.2</version>
  95.         </plugin>
  96.         <plugin>
  97.           <artifactId>maven-install-plugin</artifactId>
  98.           <version>2.5.2</version>
  99.         </plugin>
  100.         <plugin>
  101.           <artifactId>maven-deploy-plugin</artifactId>
  102.           <version>2.8.2</version>
  103.         </plugin>
  104.       </plugins>
  105.     </pluginManagement>
  106.   </build>
  107. </project>

applicationContext.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:tx="http://www.springframework.org/schema/tx"
       xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
       xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring
http://mybatis.org/schema/mybatis-spring-1.2.xsd 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-4.0.xsd http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
    <!-- 数据源 -->
    <context:property-placeholder location="classpath:db.properties"/>
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <!-- 事务管理器 -->
    <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!-- 基于注解的事务管理 -->
    <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>

    <!-- 配置 SqlSessionFactoryBean
     mybatis提供org.mybatis.spring.SqlSessionFactoryBean
     -->
    <bean id="sqlSessionFactoryBean" class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
      <!-- 数据源 -->
      <property name="dataSource" ref="dataSource"></property>
      <!-- 别名处理 -->
      <property name="typeAliasesPackage" value="com.atguigu.mp.beans"></property>
    </bean>
    <!--配置mybatis 扫描 mapper 接口的路径 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.atguigu.mp.mapper"></property>
    </bean>
</beans>

db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mp?useSSL=false
jdbc.username=root
jdbc.password=root

log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <param name="Encoding" value="UTF-8"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm :ss,SSS} %m (%F:%L) \n" />
        </layout>
    </appender>

    <logger name="java.sql">
        <level value="debug"/>
    </logger>

    <logger name="org.apache.ibatis">
        <level value="info"/>
    </logger>

    <root>
        <level value="debug"/>
        <appender-ref ref="STDOUT"/>
    </root>

</log4j:configuration>

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>

</configuration>

数据库的bean

package com.tguigu.mp.beans;

/**
 * @description:
 * @author: yuqiong
 * @createDate: 2020/1/18
 * @version: 1.0
 */
public class Employee {
    private Integer id;
    private String lastName;
    private String email;
    private Integer gender ;
    private Integer age ;

    @Override
    public String toString() {
        return "Employee{" +
                "id=" + id +
                ", lastName='" + lastName + '\'' +
                ", email='" + email + '\'' +
                ", gender=" + gender +
                ", age=" + age +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public Integer getGender() {
        return gender;
    }

    public void setGender(Integer gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

测试

package com.atguigu.mp.test;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import javax.sql.DataSource;
import java.sql.Connection;

/**
 * @description:
 * @author: yuqiong
 * @createDate: 2020/1/19
 * @version: 1.0
 */
public class Testmp {
    private ApplicationContext iocContext = new ClassPathXmlApplicationContext("applicationContext.xml");
    @Test
    public void testDataSource () throws Exception{
        DataSource ds = iocContext.getBean("dataSource",DataSource.class);
        Connection conn = ds.getConnection();
        System.out.println("---------------------------------------------------------------");
        System.out.println(conn);
    }
}