Spring-注解开发（Spring+Mybatis）

喜欢ヅ旅行 2023-01-22 07:00 6阅读 0赞

1.配置pom.xml文件

2.jdbc.properties配置文件

3.application-ann.xml配置文件

4.AOP开发

5.测试

t1()

t2()

--------------------

# Spring-注解开发（Spring+Mybatis） #

## 1.配置pom.xml文件 ##

<?xml version="1.0" encoding="UTF-8"?>
    <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>org.example</groupId>
        <artifactId>Spring-02</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <packaging>war</packaging>
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.1.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>5.1.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>5.1.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.1.6.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.3.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.5</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.25</version>
                <scope>runtime</scope>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.12</version>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
        </dependencies>
    
    
        <build>
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
            </resources>
        </build>
    </project>

## 2.jdbc.properties配置文件 ##

#jdbc.properties
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/xsh?useUnicode=true&characterEncpding=utf8
    jdbc.username=root
    jdbc.password=123

## 3.application-ann.xml配置文件 ##

<?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:aop="http://www.springframework.org/schema/aop"
           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/tx
           http://www.springframework.org/schema/tx/spring-tx.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context.xsd
           ">
        
        
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
        <context:component-scan base-package="com.qf"/>
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <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"></property>
            
            <property name="mapperLocations" value="classpath*:com/qf/mapper/*.xml"/>
            
            <property name="typeAliasesPackage" value="com.qf.entity"></property>
        </bean>
        
        
        
        <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="com.qf.dao"></property>
        </bean>
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
        
        <aop:aspectj-autoproxy/>
    </beans>

## 4.AOP开发 ##

package com.qf;
    import org.aspectj.lang.JoinPoint;
    import org.aspectj.lang.ProceedingJoinPoint;
    import org.aspectj.lang.annotation.AfterReturning;
    import org.aspectj.lang.annotation.AfterThrowing;
    import org.aspectj.lang.annotation.Around;
    import org.aspectj.lang.annotation.Aspect;
    import org.aspectj.lang.annotation.Before;
    import org.aspectj.lang.annotation.Pointcut;
    import org.springframework.stereotype.Component;
    
    import java.util.Arrays;
    /**
     * @author: qiuyongqi
     * @time: 16:49 2021/5/18
     * @description:
     *          @Aspect   此标志为aop增强类
     */
    @Component
    @Aspect
    public class MyAdvice {
    
        /**
         * @author: qiuyongqi
         * @time: 16:50 2021/5/18
         * @description:   使用空方法设置切点表达式，后面其他增强可以使用方法名来找到我们设置的切点表达式
         */
        @Pointcut("execution(* com.qf.Services..*.*(..))")
        public void pointCut(){}
    
    
        /**
         * @author: qiuyongqi
         * @time: 17:05 2021/5/18
         * @description:  前置增强，应用pointCut()方法设置的切点表达式
         */
        @Before("pointCut()")
        public void before(JoinPoint jp){
            System.out.println("前置增强");
            System.out.println("方法名："+jp.getSignature().getName());
            System.out.println("方法参数列表："+ Arrays.toString(jp.getArgs()));
        }
    
        /**
         * @author: qiuyongqi
         * @time: 17:11 2021/5/18
         * @description: 后置增强 returning="ret" 代表后置增强的方法返回值是ret
         */
        @AfterReturning(value = "pointCut()",returning = "ret")
        public void after(JoinPoint jp,Object ret){
            System.out.println("后置增强");
            System.out.println("方法名："+jp.getSignature().getName());
            System.out.println("方法采纳数列表:"+Arrays.toString(jp.getArgs()));
            System.out.println("返回值："+ret);
        }
    
        /**
         * @author: qiuyongqi
         * @time: 17:14 2021/5/18
         * @description: 环绕增强
         */
        @Around("pointCut()")
        public Object interceptor(ProceedingJoinPoint pjp) throws Throwable {
            System.out.println("环绕前置----------------------");
            System.out.println();
            Object proceed=pjp.proceed();
            System.out.println();
            System.out.println("环绕后置----------------------");
            return proceed;
        }
    
        @AfterThrowing(value = "pointCut()",throwing = "ex")
        public void ThrowExec(JoinPoint jp,Exception ex){
            System.out.println("异常增强");
            System.out.println("方法名："+jp.getSignature().getName());
            System.out.println("方法参数列表:"+ Arrays.toString(jp.getArgs()));
            System.out.println("异常信息是"+ex.getMessage());
    
    
        }
    
    
    }

## 5.测试 ##

import com.qf.Services.EmpService;
    import com.qf.entity.Emp;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    import java.sql.Date;
    import java.util.List;
    
    /**
     * @author: qiuyongqi
     * @time: 17:30 2021/5/18
     * @description:
     */
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath:application-ann.xml")
    public class text2 {
        @Autowired
        private EmpService empService;
    
        @Test
        public void t1(){
            List<Emp> list = empService.selectAll();
            for (Emp emp : list) {
                System.out.println(emp);
            }
    
        }
    
        @Test
        public void t2(){
            Emp emp1 = new Emp("张三12", "男", 20000, "132456", 102, new Date(1));
            System.out.println(empService.addEmp(emp1));
        }
        @Test
        public void t3(){
             System.out.println(empService.delEmp(1078));
        }
    
        @Test
        public void t4(){
            Emp emp1 = new Emp(1079,"张三12", "男", 20000, "132456", 102, new Date(1));
    
            System.out.println(empService.updateEmp(emp1));
        }
    }

### t1()  ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70][]

### t2() ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70]: /images/20221020/b080d01c0c7440df8abb4e9b8ff1e26f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1]: /images/20221020/8a1c77ad20b24da090a25e8b4d015ea7.png