SpringMVC，采用的是SpringJDBC

1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
2.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">  
3.     <modelVersion>4.0.0</modelVersion>  
4.     <groupId>org.andy.springmvc</groupId>  
5.     <artifactId>springmvc_demo</artifactId>  
6.     <packaging>war</packaging>  
7.     <version>0.0.1-SNAPSHOT</version>  
8.   
9.     <name>springmvc_demo Maven Webapp</name>  
10.     <url>http://maven.apache.org</url>  
11.   
12.     <properties>  
13.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  
14.         <spring.version>4.1.4.RELEASE</spring.version>  
15.         <jackson.version>2.5.0</jackson.version>  
16.     </properties>  
17.   
18.     <dependencies>  
19.   
20.         <!-- junit -->  
21.         <dependency>  
22.             <groupId>junit</groupId>  
23.             <artifactId>junit</artifactId>  
24.             <version>4.12</version>  
25.             <scope>test</scope>  
26.         </dependency>  
27.   
28.         <!-- spring -->  
29.         <dependency>  
30.             <groupId>org.springframework</groupId>  
31.             <artifactId>spring-core</artifactId>  
32.             <version>${spring.version}</version>  
33.         </dependency>  
34.   
35.         <dependency>  
36.             <groupId>org.springframework</groupId>  
37.             <artifactId>spring-beans</artifactId>  
38.             <version>${spring.version}</version>  
39.         </dependency>  
40.   
41.         <dependency>  
42.             <groupId>org.springframework</groupId>  
43.             <artifactId>spring-context</artifactId>  
44.             <version>${spring.version}</version>  
45.         </dependency>  
46.   
47.         <dependency>  
48.             <groupId>org.springframework</groupId>  
49.             <artifactId>spring-tx</artifactId>  
50.             <version>${spring.version}</version>  
51.         </dependency>  
52.   
53.         <dependency>  
54.             <groupId>org.springframework</groupId>  
55.             <artifactId>spring-web</artifactId>  
56.             <version>${spring.version}</version>  
57.         </dependency>  
58.   
59.         <dependency>  
60.             <groupId>org.springframework</groupId>  
61.             <artifactId>spring-webmvc</artifactId>  
62.             <version>${spring.version}</version>  
63.         </dependency>  
64.   
65.         <dependency>  
66.             <groupId>org.springframework</groupId>  
67.             <artifactId>spring-jdbc</artifactId>  
68.             <version>${spring.version}</version>  
69.         </dependency>  
70.   
71.         <dependency>  
72.             <groupId>org.springframework</groupId>  
73.             <artifactId>spring-test</artifactId>  
74.             <version>${spring.version}</version>  
75.             <scope>test</scope>  
76.         </dependency>  
77.   
78.         <!-- log4j -->  
79.         <dependency>  
80.             <groupId>log4j</groupId>  
81.             <artifactId>log4j</artifactId>  
82.             <version>1.2.17</version>  
83.         </dependency>  
84.   
85.         <!-- mysql连接 -->  
86.         <dependency>  
87.             <groupId>mysql</groupId>  
88.             <artifactId>mysql-connector-java</artifactId>  
89.             <version>5.1.34</version>  
90.         </dependency>  
91.   
92.         <!-- c3p0数据源 -->  
93.         <dependency>  
94.             <groupId>com.mchange</groupId>  
95.             <artifactId>c3p0</artifactId>  
96.             <version>0.9.5-pre10</version>  
97.         </dependency>  
98.   
99.         <!-- json -->  
100.         <dependency>  
101.             <groupId>com.alibaba</groupId>  
102.             <artifactId>fastjson</artifactId>  
103.             <version>1.2.3</version>  
104.         </dependency>  
105.   
106.         <dependency>  
107.             <groupId>com.fasterxml.jackson.core</groupId>  
108.             <artifactId>jackson-annotations</artifactId>  
109.             <version>${jackson.version}</version>  
110.         </dependency>  
111.   
112.         <dependency>  
113.             <groupId>com.fasterxml.jackson.core</groupId>  
114.             <artifactId>jackson-core</artifactId>  
115.             <version>${jackson.version}</version>  
116.         </dependency>  
117.   
118.         <dependency>  
119.             <groupId>com.fasterxml.jackson.core</groupId>  
120.             <artifactId>jackson-databind</artifactId>  
121.             <version>${jackson.version}</version>  
122.         </dependency>  
123.   
124.         <!-- servlet -->  
125.         <dependency>  
126.             <groupId>javax.servlet</groupId>  
127.             <artifactId>servlet-api</artifactId>  
128.             <version>3.0-alpha-1</version>  
129.             <scope>provided</scope>  
130.         </dependency>  
131.   
132.         <dependency>  
133.             <groupId>javax.servlet</groupId>  
134.             <artifactId>jstl</artifactId>  
135.             <version>1.2</version>  
136.         </dependency>  
137.   
138.         <!-- 文件上传 -->  
139.         <dependency>  
140.             <groupId>commons-io</groupId>  
141.             <artifactId>commons-io</artifactId>  
142.             <version>2.4</version>  
143.         </dependency>  
144.   
145.         <dependency>  
146.             <groupId>commons-fileupload</groupId>  
147.             <artifactId>commons-fileupload</artifactId>  
148.             <version>1.2.2</version>  
149.         </dependency>  
150.   
151.     </dependencies>  
152.   
153.   
154.     <build>  
155.         <finalName>springmvc_demo</finalName>  
156.   
157.         <plugins>  
158.             <!-- Run the JUnit unit tests in an isolated classloader -->  
159.             <plugin>  
160.                 <groupId>org.apache.maven.plugins</groupId>  
161.                 <artifactId>maven-surefire-plugin</artifactId>  
162.                 <version>2.4.2</version>  
163.                 <configuration>  
164.                     <skipTests>true</skipTests>  
165.                 </configuration>  
166.             </plugin>  
167.   
168.             <plugin>  
169.                 <groupId>org.apache.maven.plugins</groupId>  
170.                 <artifactId>maven-war-plugin</artifactId>  
171.                 <version>2.3</version>  
172.                 <configuration>  
173.                     <webXml>src/main/webapp/WEB-INF/web.xml</webXml>  
174.                 </configuration>  
175.             </plugin>  
176.   
177.             <!-- generate java doc -->  
178.             <plugin>  
179.                 <groupId>org.apache.maven.plugins</groupId>  
180.                 <artifactId>maven-javadoc-plugin</artifactId>  
181.                 <version>2.9.1</version>  
182.                 <configuration>  
183.                     <javadocDirectory>target/javadoc</javadocDirectory>  
184.                     <reportOutputDirectory>target/javadoc</reportOutputDirectory>  
185.                     <charset>UTF-8</charset>  
186.                     <encoding>UTF-8</encoding>  
187.                     <docencoding>UTF-8</docencoding>  
188.                     <show>private</show>  
189.                 </configuration>  
190.             </plugin>  
191.   
192.             <!-- 部署至本机 -->  
193.             <plugin>  
194.                 <groupId>org.codehaus.cargo</groupId>  
195.                 <artifactId>cargo-maven2-plugin</artifactId>  
196.                 <version>1.0</version>  
197.                 <configuration>  
198.                     <container>  
199.                         <containerId>tomcat6x</containerId>  
200.                         <home>D:\WebServer\apache-tomcat-6.0.39</home>  
201.                     </container>  
202.                     <configuration>  
203.                         <type>existing</type>  
204.                         <home>D:\WebServer\apache-tomcat-6.0.39</home>  
205.                     </configuration>  
206.                 </configuration>  
207.             </plugin>  
208.         </plugins>  
209.     </build>  
210. </project>  

 

4、搭建Spring

4.1、 创建配置文件，添加c3p0数据源配置信息

      src/main/resources/applicationConfig.xml

[plain] view plain copy

1. #application all config  
2.   
3. #jdbc c3p0  
4. jdbc.driver = com.mysql.jdbc.Driver  
5. jdbc.url = jdbc:mysql://localhost:3306/shop?useUnicode=true&characterEncoding=utf-8  
6. jdbc.username = root  
7. jdbc.password = 12345  

4.2、创建Spring配置文件

    src/main/resources/applicationContext.xml

   

[html] view plain copy

1. <?xml version="1.0" encoding="UTF-8"?>  
2. <beans xmlns="http://www.springframework.org/schema/beans"  
3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"  
4.     xsi:schemaLocation="http://www.springframework.org/schema/beans  
5.             http://www.springframework.org/schema/beans/spring-beans-4.1.xsd  
6.             http://www.springframework.org/schema/context  
7.             http://www.springframework.org/schema/context/spring-context-4.1.xsd  
8.         ">  
9.   
10.     <!--引入配置属性文件 -->  
11.     <context:property-placeholder location="classpath*:/applicationConfig.properties" />  
12.     <!--扫描org.andy.work下文件，自动注入dao,entity,service为bean -->  
13.     <context:component-scan base-package="org.andy.shop.dao.Impl,org.andy.shop.service.Impl" />  
14.   
15.     <!-- c3p0数据源配置 -->  
16.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"  
17.         destroy-method="close">  
18.         <property name="driverClass" value="${jdbc.driver}" />  
19.         <property name="jdbcUrl" value="${jdbc.url}" />  
20.         <property name="user" value="${jdbc.username}" />  
21.         <property name="password" value="${jdbc.password}" />  
22.   
23.         <!-- 请求超时时间 -->  
24.         <property name="checkoutTimeout" value="30000" />  
25.         <!-- 每60秒检查所有连接池中的空闲连接。默认值: 0，不检查 -->  
26.         <property name="idleConnectionTestPeriod" value="30" />  
27.         <!-- 连接数据库连接池最大空闲时间 -->  
28.         <property name="maxIdleTime" value="30" />  
29.         <!-- 连接池初始化连接数 -->  
30.         <property name="initialPoolSize" value="5" />  
31.         <property name="minPoolSize" value="5" />  
32.         <property name="maxPoolSize" value="20" />  
33.         <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3 -->  
34.         <property name="acquireIncrement" value="5" />  
35.     </bean>  
36.   
37.     <!-- spring jdbc -->  
38.     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">  
39.         <property name="dataSource" ref="dataSource" />  
40.     </bean>  
41.   
42.     <bean id="namedParameterJdbcTemplate"  
43.         class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">  
44.         <constructor-arg ref="dataSource" />  
45.     </bean>  
46.   
47.     <!-- 配置事务管理 -->  
48.     <bean id="transactionManager"  
49.         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
50.         <property name="dataSource" ref="dataSource" />  
51.     </bean>  
52.   
53.     <!-- 声明式事务，事务拦截器 -->  
54.     <bean id="transactionInterceptor"  
55.         class="org.springframework.transaction.interceptor.TransactionInterceptor">  
56.         <property name="transactionManager" ref="transactionManager" />  
57.         <!-- 配置事务属性 -->  
58.         <property name="transactionAttributes">  
59.             <!--下面定义事务传播属性 -->  
60.             <props>  
61.                 <prop key="save*">PROPAGATION_REQUIRED</prop>  
62.                 <prop key="del*">PROPAGATION_REQUIRED</prop>  
63.                 <prop key="update">PROPAGATION_REQUIRED</prop>  
64.                   
65.                 <prop key="get*">PROPAGATION_SUPPORTS,readOnly</prop>  
66.                 <prop key="find*">PROPAGATION_SUPPORTS,readOnly</prop>  
67.                 <prop key="*">PROPAGATION_REQUIRED</prop>  
68.             </props>  
69.         </property>  
70.     </bean>  
71.   
72.     <!-- Bean后处理器BeanNameAutoProxyCreator，根据List配置创建事务代理 -->  
73.     <bean  
74.         class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">  
75.         <!-- 下面是所有需要自动创建事务代理的bean -->  
76.