前言https://blog.csdn.net/cui163007/article/details/83689299
这篇博客内容是根据自己做的ssm框架整合的过程总结的,内容比较简单.
1. 使用的环境和软件:(暂时只列出下边这些,具体见pom.xml文件)
eclipse neon
maven 3.3.9
spring springmvc 4.3.6
mybatis 3.2.8
druid 1.0.12
jdk 1.8
2. 过程
2.1 创建maven的wabapp项目 具体过程请自行查找.
2.2 修改项目的pom.xml文件 我是先创建了一个父项目对其他项目进行统一的版本控制,然后在子项目里列出需要的依赖.具体如下:
父项目的pom.xml文件(通过父项目进行版本控制,父项目里写上具体的依赖版本,子项目只用写需要的依赖)
<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>com.ssm.cyf</groupId> <artifactId>parentUnit</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>pom</packaging> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <spring.version>4.3.6.RELEASE</spring.version> <httpclient.version>4.5.3</httpclient.version> <javax.servlet-api.version>3.0.1</javax.servlet-api.version> <quartz.version>2.2.2</quartz.version> <sigar.version>1.6</sigar.version> <slf4j-log4j12.version>1.7.2</slf4j-log4j12.version> <mina-core.version>2.0.9</mina-core.version> <junit.version>4.12</junit.version> <jedis.version>2.8.0</jedis.version> <commons-lang.version>2.6</commons-lang.version> <c3p0.version>0.9.5.2</c3p0.version> <json-lib.version>2.4</json-lib.version> <jsontools-core.version>1.7</jsontools-core.version> <gson.version>2.5</gson.version> <dom4j.version>1.6.1</dom4j.version> <jaxen.version>1.1.6</jaxen.version> <fastjson.version>1.2.47</fastjson.version> <mysql-connector-java.version>5.1.37</mysql-connector-java.version> <gmbal-api-only.version>3.2.0-b002</gmbal-api-only.version> <ecloud-tools.version>1.0.0</ecloud-tools.version> <management-api.version>3.2.1-b002</management-api.version> <streambuffer.version>1.5.3</streambuffer.version> <policy.version>2.4</policy.version> <jaxws-tools.version>2.2.10</jaxws-tools.version> <jaxws-rt.version>2.2.10</jaxws-rt.version> <jaxb-impl.version>2.2.10-b140310.1920</jaxb-impl.version> <jaxb-core.version>2.2.10</jaxb-core.version> <jaxws-api.version>2.2.10</jaxws-api.version> <javax.xml.soap-api.version>1.3.7</javax.xml.soap-api.version> <javax.annotation-api.version>1.2</javax.annotation-api.version> <sqljdbc4-chs.version>4.0.2206.100</sqljdbc4-chs.version> <ha-api.version>3.1.8</ha-api.version> <stax-ex.version>1.7.6</stax-ex.version> <stax2-api.version>3.1.4</stax2-api.version> <slf4j-api.version>1.7.15</slf4j-api.version> <log4j.version>1.2.16</log4j.version> <commons-dbcp2.version>2.1.1</commons-dbcp2.version> <libthrift.version>0.9.1</libthrift.version> <logback-classic.version>1.1.6</logback-classic.version> <logback-core.version>1.1.6</logback-core.version> <commons-logging.version>1.2</commons-logging.version> <reflectasm.version>1.11.0</reflectasm.version> <spring-data-redis.version>1.7.1.RELEASE</spring-data-redis.version> <jstl.version>1.2</jstl.version> <druid.version>1.0.12</druid.version> <mybatis.version>3.2.8</mybatis.version> <mybatis-spring.version>1.2.2</mybatis-spring.version> <aspectjweaver.version>1.6.8_2</aspectjweaver.version> </properties> <modules> <module>../ssm5</module> <module>../tools</module> <!-- <module>../redistool</module> --> <module>../redisTools</module> </modules> <dependencyManagement> <dependencies> <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpclient</artifactId> <version>${httpclient.version}</version> </dependency> <!-- servlet 3 --> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>${javax.servlet-api.version}</version> </dependency> <!-- Spring dependencies --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-expression</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version> ${spring.version}</version> </dependency> <dependency> <groupId>org.quartz-scheduler</groupId> <artifactId>quartz</artifactId> <version>${quartz.version}</version> </dependency> <dependency> <groupId>org.hyperic</groupId> <artifactId>sigar</artifactId> <version>${sigar.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>${slf4j-log4j12.version}</version> </dependency> <!-- mina start --> <dependency> <groupId>org.apache.mina</groupId> <artifactId>mina-core</artifactId> <version>${mina-core.version}</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>${junit.version}</version> <scope>test</scope> </dependency> <dependency> <groupId>redis.clients</groupId> <artifactId>jedis</artifactId> <version>${jedis.version}</version> </dependency> <dependency> <groupId>commons-lang</groupId> <artifactId>commons-lang</artifactId> <version>${commons-lang.version}</version> </dependency> <dependency> <groupId>net.sf.json-lib</groupId> <artifactId>json-lib</artifactId> <version>${json-lib.version}</version> <classifier>jdk15</classifier> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>${c3p0.version}</version> </dependency> <dependency> <groupId>com.sdicons.jsontools</groupId> <artifactId>jsontools-core</artifactId> <version>${jsontools-core.version}</version> </dependency> <dependency> <groupId>com.google.code.gson</groupId> <artifactId>gson</artifactId> <version>${gson.version}</version> </dependency> <dependency> <groupId>dom4j</groupId> <artifactId>dom4j</artifactId> <version>${dom4j.version}</version> <exclusions> <exclusion> <groupId>jaxen</groupId> <artifactId>jaxen</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>jaxen</groupId> <artifactId>jaxen</artifactId> <version>${jaxen.version}</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>${fastjson.version}</version> </dependency> <!-- mysql --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql-connector-java.version}</version> </dependency> <dependency> <groupId>org.glassfish.gmbal</groupId> <artifactId>gmbal-api-only</artifactId> <version>${gmbal-api-only.version}</version> </dependency> <dependency> <groupId>ecloud-tools</groupId> <artifactId>ecloud-tools</artifactId> <version>${ecloud-tools.version}</version> </dependency> <dependency> <groupId>org.glassfish.external</groupId> <artifactId>management-api</artifactId> <version>${management-api.version}</version> </dependency> <dependency> <groupId>com.sun.xml.stream.buffer</groupId> <artifactId>streambuffer</artifactId> <version>${streambuffer.version}</version> </dependency> <dependency> <groupId>com.sun.xml.ws</groupId> <artifactId>policy</artifactId> <version>${policy.version}</version> </dependency> <dependency> <groupId>com.sun.xml.ws</groupId> <artifactId>jaxws-tools</artifactId> <version>${jaxws-tools.version}</version> </dependency> <dependency> <groupId>com.sun.xml.ws</groupId> <artifactId>jaxws-rt</artifactId> <version>${jaxws-rt.version}</version> <exclusions> <exclusion> <groupId>com.sun.istack</groupId> <artifactId>istack-commons-runtime</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>com.sun.xml.bind</groupId> <artifactId>jaxb-impl</artifactId> <version>${jaxb-impl.version}</version> </dependency> <dependency> <groupId>com.sun.xml.bind</groupId> <artifactId>jaxb-core</artifactId> <version>${jaxb-core.version}</version> </dependency> <dependency> <groupId>javax.xml.ws</groupId> <artifactId>jaxws-api</artifactId> <version>${jaxws-api.version}</version> </dependency> <dependency> <groupId>javax.xml.soap</groupId> <artifactId>javax.xml.soap-api</artifactId> <version>${javax.xml.soap-api.version}</version> </dependency> <dependency> <groupId>javax.annotation</groupId> <artifactId>javax.annotation-api</artifactId> <version>${javax.annotation-api.version}</version> </dependency> <dependency> <groupId>com.hynnet</groupId> <artifactId>sqljdbc4-chs</artifactId> <version>${sqljdbc4-chs.version}</version> </dependency> <dependency> <groupId>org.glassfish.ha</groupId> <artifactId>ha-api</artifactId> <version>${ha-api.version}</version> </dependency> <dependency> <groupId>org.jvnet.staxex</groupId> <artifactId>stax-ex</artifactId> <version>${stax-ex.version}</version> </dependency> <dependency> <groupId>org.codehaus.woodstox</groupId> <artifactId>stax2-api</artifactId> <version>${stax2-api.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j-api.version}</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>${log4j.version}</version> </dependency> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-dbcp2</artifactId> <version>${commons-dbcp2.version}</version> </dependency> <dependency> <groupId>org.apache.thrift</groupId> <artifactId>libthrift</artifactId> <version>${libthrift.version}</version> <exclusions> <exclusion> <artifactId>org.slf4j</artifactId> <groupId>slf4j-api:jar</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>${logback-classic.version}</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>${logback-core.version}</version> </dependency> <dependency> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> <version>${commons-logging.version}</version> </dependency> <dependency> <groupId>com.esotericsoftware</groupId> <artifactId>reflectasm</artifactId> <version>${reflectasm.version}</version> </dependency> <!--spring redis--> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-redis</artifactId> <version>${spring-data-redis.version}</version> <exclusions> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>${jstl.version}</version> </dependency> <!-- 数据源druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>${druid.version}</version> </dependency> <!-- 连接数据库 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <!-- 事务 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.apache.geronimo.bundles</groupId> <artifactId>aspectjweaver</artifactId> <version>${aspectjweaver.version}</version> </dependency> <!-- mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <!-- mybatis-spring的集成包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>${mybatis-spring.version}</version> </dependency> </dependencies> </dependencyManagement> <build> <plugins> <plugin> <!-- 编译插件 --> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.8</source> <target>1.8</target> <encoding>${project.build.sourceEncoding}</encoding> </configuration> </plugin> <plugin> <!-- 发布插件 --> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-deploy-plugin</artifactId> <version>2.5</version> </plugin> <plugin> <!-- 打包插件 --> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-jar-plugin</artifactId> <version>2.3.1</version> </plugin> <plugin> <!-- 安装插件 --> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-install-plugin</artifactId> <version>2.3.1</version> </plugin> <plugin> <!-- 单元测试插件 --> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-surefire-plugin</artifactId> <version>2.7.2</version> <configuration> <skip>true</skip> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-resources-plugin</artifactId> <version>2.4.3</version> <configuration> <encoding>${project.build.sourceEncoding}</encoding> </configuration> </plugin> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>tomcat-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.mortbay.jetty</groupId> <artifactId>maven-jetty-plugin</artifactId> <version>6.1.6</version> </plugin> </plugins> </build> </project> |
子项目的pom.xml:
<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/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>com.ssm.cyf</groupId> <artifactId>parentUnit</artifactId> <version>0.0.1-SNAPSHOT</version> <relativePath>../parentUnit/pom.xml</relativePath> </parent> <artifactId>ssm5</artifactId> <packaging>war</packaging> <name>ssm5</name> <description>ssm5</description> <dependencies> <!-- 导入其他项目 --> <dependency> <groupId>com.ssm.cyf</groupId> <artifactId>tools</artifactId> <version>0.0.1-SNAPSHOT</version> </dependency> <!-- <dependency> <groupId>com.ssm.cyf</groupId> <artifactId>redistool</artifactId> <version>0.0.1-SNAPSHOT</version> </dependency> --> <dependency> <groupId>com.ssm.cyf</groupId> <artifactId>redisTools</artifactId> <version>0.0.1-SNAPSHOT</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </dependency> <!--spring redis--> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-redis</artifactId> <exclusions> <exclusion> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>redis.clients</groupId> <artifactId>jedis</artifactId> </dependency> <!-- spring mybatis --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> </dependency> <!-- 连接数据库 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> </dependency> <!-- 事务 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> </dependency> <dependency> <groupId>org.apache.geronimo.bundles</groupId> <artifactId>aspectjweaver</artifactId> </dependency> <!-- mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> </dependency> <!-- mybatis-spring的集成包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> </dependency> <!-- 数据库驱动包 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!-- 数据源druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> </dependency> <!-- 日志log4j --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> </dependency> <!-- j2ee 依赖包 --> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>3.0-alpha-1</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> </dependency> </dependencies> <build> <finalName>ssm5</finalName> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build> </project> |
2.3 创建项目目录
总目录:
目录详细:
2.4 ssm整合:
2.4.1 在src/main/resources目录下创建spring.xml,用于添加spring的配置,,,,创建springmvc.xml用于添加springmvc的配置,,具体内容如下:
spring.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd "> <!-- 扫描这个包下的所有类 用于自动注入该包下的对象--> <context:component-scan base-package="com.ssm.cyf"/> <!--加载Spring-MyBatis配置文件--> <import resource="mybatis/spring-mybatis.xml"/> </beans> |
springmvc.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd "> <!--开启Spring注解--> <context:annotation-config/> <!--开启Spring MVC注解--> <mvc:annotation-driven/> <!--开启自动扫描装配--> <context:component-scan base-package="com.ssm.cyf"/> <!-- 配置视图解析器 --> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="contentType" value="charset=utf-8"/> <property name="prefix" value="/" /> <property name="suffix" value=".jsp" /> </bean> </beans> |
下边进行mybatis的整合
在src/main/resources目录下创建mybatis文件夹,,,在此文件夹里创建durid.properties,用于配置数据库连接的各个参数,创建mybatis-config.xml用于mybatis的配置,创建spring-mybatis.xml用于数据源,事务等的配置,,,具体内容如下:
durid.properties:
druid.driverClassName=com.mysql.jdbc.Driver druid.url=jdbc:mysql://127.0.0.1:3306/user?useUnicode=true&characterEncoding=UTF-8 druid.username=root druid.password=123 druid.initialSize=10 druid.minIdle=6 druid.maxActive=50 druid.maxWait=60000 druid.timeBetweenEvictionRunsMillis=60000 druid.minEvictableIdleTimeMillis=300000 druid.validationQuery=SELECT 'x' druid.testWhileIdle=true druid.testOnBorrow=false druid.testOnReturn=false druid.poolPreparedStatements=false druid.maxPoolPreparedStatementPerConnectionSize=20 druid.filters=wall,stat |
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-config.dtd"> <configuration> <settings> <setting name="cacheEnabled" value="false"/> <setting name="lazyLoadingEnabled" value="false"/> <setting name="aggressiveLazyLoading" value="true"/> <setting name="logImpl" value="STDOUT_LOGGING"/> <!--指定日志实现方式是log4j--> <setting name="logImpl" value="LOG4J"/> </settings> </configuration> |
spring-mybatis.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd "> <!-- 通过属性文件定位器(property-placeholder)读取数据库连接资源文件 配置数据源(dataSource)进行数据库连接 通过会话工厂bean(sqlSessionFactoryBean)配置XML映射文件路径 通过映射扫描配置(MapperScannerConfigurer)配置数据访问层(Dao)路径 通过事务控制(DataSourceTransactionManager)配置Spring事务控制。 通过tx:annotation-driven开启声明式的事务注解 --> <context:component-scan base-package="com.ssm.cyf" /> <!-- 读取数据库连接属性文件 --> <context:property-placeholder location="classpath:mybatis/durid.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 = "${druid.driverClassName}" /> <!-- 初始化连接数量 --> <property name="initialSize" value="${druid.initialSize}" /> <!-- 最小空闲连接数 --> <property name="minIdle" value="${druid.minIdle}" /> <!-- 最大并发连接数 --> <property name="maxActive" value="${druid.maxActive}" /> <!--配置获取连接等待超时的时间 --> <property name="maxWait" value="${druid.maxWait}" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}" /> <!--配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}" /> <property name="validationQuery" value="${druid.validationQuery}" /> <property name="testWhileIdle" value="${druid.testWhileIdle}" /> <property name="testOnBorrow" value="${druid.testOnBorrow}" /> <property name="testOnReturn" value="${druid.testOnReturn}" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false。 --> <property name="poolPreparedStatements" value="${druid.poolPreparedStatements}" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="${druid.maxPoolPreparedStatementPerConnectionSize}" /> <!-- 配置监控统计拦截的filters --> <property name="filters" value="${druid.filters}" /> </bean> <!--配置会话工厂bean:SqlSessionFactory--> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!--配置数据源,类似于MyBatis配置文件的environment中的DataSource标签--> <property name="dataSource" ref="dataSource" /> <!--配置MyBatis配置文件--> <property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/> <!--配置映射文件地址,于MyBatis配置文件的mapper--> <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml" /> <!--配置类型别名,类似于MyBatis配置文件的typeAliases--> <property name="typeAliasesPackage" value="com.ssm.cyf.pojo" /> </bean> <!-- 配置mybatis mapper接口 配置映射扫描配置:MapperScannerConfigurer--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> <property name="basePackage" value="com.ssm.cyf.dao" /> </bean> <!-- 事务配置 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 使用annotation注解方式配置事务 --> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- 拦截器方式配置事物 --> <tx:advice id="transactionAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED" /> <tx:method name="append*" propagation="REQUIRED" /> <tx:method name="insert*" propagation="REQUIRED" /> <tx:method name="save*" propagation="REQUIRED" /> <tx:method name="update*" propagation="REQUIRED" /> <tx:method name="modify*" propagation="REQUIRED" /> <tx:method name="edit*" propagation="REQUIRED" /> <tx:method name="delete*" propagation="REQUIRED" /> <tx:method name="remove*" propagation="REQUIRED" /> <tx:method name="repair" propagation="REQUIRED" /> <tx:method name="delAndRepair" propagation="REQUIRED" /> <tx:method name="get*" propagation="SUPPORTS" /> <tx:method name="find*" propagation="SUPPORTS" /> <tx:method name="load*" propagation="SUPPORTS" /> <tx:method name="search*" propagation="SUPPORTS" /> <tx:method name="datagrid*" propagation="SUPPORTS" /> <tx:method name="*" propagation="SUPPORTS" /> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="transactionPointcut" expression="execution(* com.ssm.cyf.service.impl.*.*(..))" /> <aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" /> </aop:config> </beans> |
配置mapper文件(文件名与dao层接口的接口名称一样)
src/main/resources/mybatis目录里创建mapper文件夹,然后创建mapper文件TopicDao.xml,文件里是dao层接口里的方法对应的sql语句.具体内容如下:
<?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是dao层的包路径 --> <mapper namespace="com.ssm.cyf.dao.TopicDao"> <!-- id是dao层接口里的方法名称 resultType是这个方法的返回值的类型 --> <select id="selectByPrimaryKey" resultType="com.ssm.cyf.pojo.User"> select * from user where id=#{id} </select> <select id="selectAll" resultType="com.ssm.cyf.pojo.User"> select * from user </select> <update id="updateByPrimaryKey"> update user set username=#{username},password=#{password} where id = #{id} </update> <insert id="insert"> insert into user(username,password) values(#{username},#{password}) <!-- 插入数据时主键自增长的固定写法 --> <selectKey resultType="java.lang.String" keyProperty="id"> select @@identity as id </selectKey> </insert> <delete id="deleteByPrimaryKey" parameterType="java.lang.String"> delete from user where id = #{id,jdbcType=VARCHAR} </delete> </mapper> |
最后修改src/main/webapp/WEB-INF目录下的web.xml文件,,内容如下(红色内容必须填)
<?xml version="1.0" encoding="utf-8" ?> <web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"> <!--spring 监听器 --> <context-param> <param-name>contextConfigLocation</param-name> <!-- classpath是spring相关配置文件的路径 根据自己建的目录确定--> <param-value>classpath:spring.xml</param-value> </context-param> <!--Spring 上下文环境监听器--> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!--防止Spring内存溢出监听器--> <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <!-- springMvc --> <servlet> <servlet-name>springmvc</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <!-- classpath是springmvc相关配置文件的路径 --> <param-value>classpath:springmvc.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>springmvc</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!--编码过滤器:解决post请求参数乱码问题--> <filter> <filter-name>characterEncodingFilter</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> </filter> <filter-mapping> <filter-name>characterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> </web-app> |
|
以上是项目用到的所有配置文件;
下边创建项目的类和接口:
创建项目用到的pojo对象,这个对象与数据库表里的对象相对应,数据库表里的字段对应这个对象的属性
User.java
package com.ssm.cyf.pojo; public class User { private String id; private String username; private String password; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } } |
controller层:TopicController.java
package com.ssm.cyf.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import com.ssm.cyf.service.TopicService; @Controller//controller层加@Controller注解 public class TopicController { @Autowired//自动注入service层对象 private TopicService topicService; @RequestMapping("/curd")//命名空间地址 用于前端访问路径 public String curdTest(){ topicService.curdTest();//调用service层方法 return "index";//跳转到对应页面 因为在springmvc配置文件里配置了视图解析器 这里只写页面名称 不用加路径和后缀 } } |
service层的接口TopicService.java和实现类TopicServiceImpl.java
TopicService.java
package com.ssm.cyf.service; import org.springframework.transaction.annotation.Transactional; public interface TopicService { @Transactional//在这加上事务注解 void curdTest(); } |
TopicServiceImpl.java
package com.ssm.cyf.service.impl; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.ssm.cyf.dao.TopicDao; import com.ssm.cyf.pojo.User; import com.ssm.cyf.service.TopicService; @Service//在service层加上@Service注解 public class TopicServiceImpl implements TopicService { private static final Logger LOGGER = Logger.getLogger(TopicServiceImpl.class); @Autowired//自动注入dao层对象 private TopicDao topicDao; @Override public void curdTest() { //查询所有 LOGGER.info("查询所有"); LOGGER.info(this.topicDao.selectAll()); //插入一个,查询所有 System.out.println("============================="); LOGGER.info("插入一个"); User user = new User(); user.setId("11"); user.setUsername("11www"); user.setPassword("112222"); topicDao.insert(user); //查询一个 System.out.println("============================="); LOGGER.info("查询一个"); LOGGER.info(this.topicDao.selectByPrimaryKey("3")); //修改一个,然后查询 System.out.println("============================="); LOGGER.info("修改一个"); User user2 = new User(); user2.setId("22"); user2.setUsername("22www"); user2.setPassword("222222"); this.topicDao.updateByPrimaryKey(user2); LOGGER.info(this.topicDao.selectByPrimaryKey("3")); //删除一个,然后查询 System.out.println("============================="); LOGGER.info("删除一个,然后查询"); this.topicDao.deleteByPrimaryKey("3"); LOGGER.info(this.topicDao.selectByPrimaryKey("1")); } } |
dao层的TopicDao.java
package com.ssm.cyf.dao; import java.util.List; import org.springframework.stereotype.Repository; import com.ssm.cyf.pojo.User; @Repository//在dao层加上@Repository注解 public interface TopicDao { /** * 根据主键删除数据库的记录 * * @param id */ int deleteByPrimaryKey(String id); /** * 插入数据库记录 * * @param record */ int insert(User user); /** * 根据主键获取一条数据库记录 * * @param id */ User selectByPrimaryKey(String id); /** * 获取全部数据库记录 * */ List<User> selectAll(); /** * 根据主键来更新数据库记录 * * @param record */ int updateByPrimaryKey(User user); } |
至此整个框架整合完毕,,
项目创建时的注意:
(1) jdk版本问题,需要在pom.xml文件里指定项目用的版本是多少,不然在用maven的update之后项目的jdk版本会恢复成默认的1.5(具体见父项目的pom.xml文件)