Jpetstore研究（一）：spring MVC + jpetstore + mysql搭建

来源：互联网发布：如何看待网络水军编辑：程序博客网时间：2024/05/16 18:22

1> 下载spring MVC自带的jpetstore工程源码http://download.csdn.net/detail/sundongsdu/5344600

2> 将db\mysql目录里的schema和data导入mysql

3> 修改pom.xml:

i) 禁掉

        <dependency>
           <groupId>org.apache.struts</groupId>
           <artifactId>com.springsource.org.apache.struts</artifactId>
           <version>${struts.version}</version>
       </dependency>

ii) 将

       <dependency>
           <groupId>hsqldb</groupId>
           <artifactId>hsqldb</artifactId>
           <version>${hsqldb.version}</version>
       </dependency>

改为

   <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.20</version>
       </dependency>

添加：

      <dependency>
           <groupId>commons-pool</groupId>
           <artifactId>commons-pool</artifactId>
           <version>1.4</version>
       </dependency>

4> 删除src/main/java/org/springframework/samples/jpetstore/web/struts

5>修改src/main/webapp/WEB-INF/jdbc.properties，例如：

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/jpetstore?useUnicode=true&characterEncoding=UTF8
jdbc.username=root
jdbc.password=123

6> 修改web.xml,禁掉

<servlet>
       <servlet-name>action</servlet-name>
       <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
       <load-on-startup>3</load-on-startup>
   </servlet>

整个配置好的工程源码在：http://download.csdn.net/detail/sundongsdu/5347122