赞
踩
- <?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="edu.gyc"/>
- <mvc:annotation-driven/>
- <!--解决静态资源js css访问的问题-->
- <mvc:default-servlet-handler/>
- <!-- 配置视图解析器 -->
- <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
- <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
- <property name="prefix" value="/WEB-INF/jsp/"/>
- <property name="suffix" value=".jsp"/>
- </bean>
- </beans>
- <?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:aop="http://www.springframework.org/schema/aop"
- 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
- http://www.springframework.org/schema/aop
- http://www.springframework.org/schema/aop/spring-aop.xsd">
-
- <context:component-scan base-package="edu.gyc">
-
- </context:component-scan>
- <!-- 读取java配置文件,替换占位符数据 -->
- <context:property-placeholder location="classpath:jdbc.properties"/>
-
- <!-- 配置数据源 -->
- <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
- init-method="init" destroy-method="close">
- <!-- 数据库基本信息配置 -->
- <property name="url" value="${druid.url}" />
- <property name="username" value="${druid.username}" />
- <property name="password" value="${druid.password}" />
- <property name = "driverClassName" value = "com.mysql.cj.jdbc.Driver" />
-
- <!-- 初始化连接数量 -->
- <property name="initialSize" value="${druid.initialSize}" />
- <!-- 最小空闲连接数 -->
- <property name="minIdle" value="${druid.minIdle}" />
- <!-- 最大并发连接数 -->
- <property name="maxActive" value="${druid.maxActive}" />
- <!-- 配置获取连接等待超时的时间 -->
- <property name="maxWait" value="${druid.maxWait}" />
-
-
- </bean>
-
- <!-- 配置SqlSessionFactory -->
- <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
- <!-- 注入dataSource -->
- <property name="dataSource" ref="dataSource"/>
- <property name="mapperLocations" value="classpath:mapper/*.xml"/>
-
- </bean>
-
- <!-- 配置Mapper代理对象方式一:MapperFactoryBean(了解) -->
- <!-- 通过MapperFactoryBean生成的代理对象,一次只能针对一个接口进行生成 -->
- <!--<bean id="accountMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
- <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
- <property name="mapperInterface" value="top.alanshelby.mapper.AccountMapper"></property>
- </bean>-->
-
- <!-- 配置Mapper代理对象方式二:MapperScannerConfigurer -->
- <!-- 批量代理对象的生成 -->
- <!-- 注意事项:mapper接口类和mapper映射文件同包同名 -->
- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
- <!-- 指定需要生成代理的接口所在的包名 -->
- <property name="basePackage" value="edu.gyc.dao"/>
- <!-- 注意事项:千万不要配置SqlSessionFactory,要配置sqlSessionFactoryBeanName -->
- <!-- <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> -->
- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
- </bean>
- <!-- 配置平台事务管理器 -->
- <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
- <property name="dataSource" ref="dataSource"></property>
- </bean>
-
- <!-- 事务通知 -->
- <tx:advice id="txAdvice" transaction-manager="transactionManager">
- <tx:attributes>
- <tx:method name="transfer*" propagation="REQUIRED" isolation="DEFAULT"/>
- </tx:attributes>
- </tx:advice>
-
- <!-- 实现注解的声明式事务 -->
- <tx:annotation-driven transaction-manager="transactionManager" mode="proxy"/>
- </beans>
在这个文件中就已经配置了sqlSessionFactory、MapperScannerConfigurer 。
一个用来与数据库进行交互的,一个用来扫描包的。
项目结构:
- druid.driverClassName=com.mysql.cj.jdbc.Driver
- druid.url=jdbc:mysql://127.0.0.1:3306/cyl?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
- druid.username=root
- druid.password=123456
- druid.initialSize=10
- druid.minIdle=6
- druid.maxActive=50
- druid.maxWait=60000
- <dependencies>
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.12</version>
- <scope>test</scope>
- </dependency>
-
- <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
- <dependency>
- <groupId>org.mybatis.generator</groupId>
- <artifactId>mybatis-generator-core</artifactId>
- <version>1.3.7</version>
- </dependency>
- <!-- mybatis依赖 -->
- <dependency>
- <groupId>org.mybatis</groupId>
- <artifactId>mybatis</artifactId>
- <version>3.4.6</version>
- </dependency>
- <dependency>
- <groupId>org.slf4j</groupId>
- <artifactId>slf4j-log4j12</artifactId>
- <version>1.7.21</version>
- </dependency>
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>8.0.27</version>
- </dependency>
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.12</version>
-
- </dependency>
-
- <!-- 持久层依赖 begin -->
- <!-- spring ioc组件需要的依赖包 -->
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-beans</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-core</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-context</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-expression</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <!-- spring 事务管理和JDBC依赖包 -->
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-tx</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-jdbc</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <!-- mysql数据库驱动包 -->
- <dependency>
- <groupId>mysql</groupId>
- <artifactId>mysql-connector-java</artifactId>
- <version>8.0.27</version>
- </dependency>
- <!-- druid连接池的依赖包 -->
- <dependency>
- <groupId>com.alibaba</groupId>
- <artifactId>druid</artifactId>
- <version>1.0.29</version>
- </dependency>
-
- <!-- mybatis依赖 -->
- <dependency>
- <groupId>org.mybatis</groupId>
- <artifactId>mybatis</artifactId>
- <version>3.4.6</version>
- </dependency>
- <!-- mybatis和spring的整合依赖 -->
- <dependency>
- <groupId>org.mybatis</groupId>
- <artifactId>mybatis-spring</artifactId>
- <version>1.3.2</version>
- </dependency>
- <!-- 持久层依赖 end -->
-
- <!-- 业务层依赖 begin -->
- <!-- 基于AspectJ的aop依赖 -->
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-aspects</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>aopalliance</groupId>
- <artifactId>aopalliance</artifactId>
- <version>1.0</version>
- </dependency>
- <!-- 业务层依赖 end -->
-
- <!-- 表现层依赖 begin -->
- <!-- SpringMVC 相关包 -->
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-webmvc</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-web</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <dependency>
- <groupId>javax.servlet</groupId>
- <artifactId>javax.servlet-api</artifactId>
- <version>3.1.0</version>
- </dependency>
- <dependency>
- <groupId>javax.servlet.jsp</groupId>
- <artifactId>jsp-api</artifactId>
- <version>2.2</version>
- </dependency>
- <dependency>
- <groupId>javax.servlet</groupId>
- <artifactId>jstl</artifactId>
- <version>1.2</version>
- </dependency>
- <!-- 表现层依赖 end -->
-
- <!-- 单元测试依赖 begin -->
- <!-- spring 单元测试组件包 -->
- <dependency>
- <groupId>org.springframework</groupId>
- <artifactId>spring-test</artifactId>
- <version>4.3.13.RELEASE</version>
- </dependency>
- <!-- 单元测试Junit -->
- <dependency>
- <groupId>junit</groupId>
- <artifactId>junit</artifactId>
- <version>4.12</version>
- </dependency>
- <!-- 单元测试依赖 end -->
-
- <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
- <dependency>
- <groupId>org.mybatis.generator</groupId>
- <artifactId>mybatis-generator-core</artifactId>
- <version>1.3.7</version>
- </dependency>
-
- <dependency>
- <groupId>org.slf4j</groupId>
- <artifactId>slf4j-log4j12</artifactId>
- <version>1.7.21</version>
- </dependency>
-
- <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
- <dependency>
- <groupId>com.fasterxml.jackson.core</groupId>
- <artifactId>jackson-databind</artifactId>
- <version>2.8.9</version>
- </dependency>
- <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
- <dependency>
- <groupId>com.fasterxml.jackson.core</groupId>
- <artifactId>jackson-databind</artifactId>
- <version>2.8.9</version>
- </dependency>
- <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->
- <dependency>
- <groupId>com.fasterxml.jackson.core</groupId>
- <artifactId>jackson-core</artifactId>
- <version>2.8.9</version>
- </dependency>
-
- <!--fastJson是一个JSON的处理工具包,由阿里巴巴公司研发推出。
- 我们使用它将List或者Map转换成JSON对象-->
- <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
- <dependency>
- <groupId>com.alibaba</groupId>
- <artifactId>fastjson</artifactId>
- <version>1.2.34</version>
- </dependency>
- </dependencies>
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。