二、stpringMVC mysql+jpa 篇

承接上一部分的内容，这次我们加一些基于mysql的操作的内容

添加依赖包pom.xml
这里其中有一些不是必要的，童鞋们可以根据自己需要删减

<properties>        <spring-framework.version>4.1.7.RELEASE</spring-framework.version>    </properties><!-- spring data jpa -->        <dependency>            <groupId>org.springframework.data</groupId>            <artifactId>spring-data-jpa</artifactId>            <version>1.7.0.RELEASE</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>${spring-framework.version}</version>        </dependency>        <!-- hibernate -->        <dependency>            <groupId>org.hibernate</groupId>            <artifactId>hibernate-entitymanager</artifactId>            <version>4.3.6.Final</version>        </dependency>        <!-- mysql jdbc -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.32</version>        </dependency>        <!-- tomcat jdbc -->        <dependency>            <groupId>org.apache.tomcat</groupId>            <artifactId>tomcat-jdbc</artifactId>            <version>7.0.55</version>            <scope>runtime</scope>        </dependency>        <!-- general unit -->        <dependency>            <groupId>org.apache.commons</groupId>            <artifactId>commons-lang3</artifactId>            <version>3.3.2</version>        </dependency>        <!-- fastjson -->        <dependency>            <groupId>com.alibaba</groupId>            <artifactId>fastjson</artifactId>            <version>1.2.5</version>        </dependency>        <dependency>            <groupId>com.google.guava</groupId>            <artifactId>guava</artifactId>            <version>18.0</version>        </dependency>        <!-- servlet -->        <dependency>            <groupId>javax.servlet</groupId>            <artifactId>javax.servlet-api</artifactId>            <version>3.1.0</version>        </dependency>        <dependency>            <groupId>org.apache.httpcomponents</groupId>            <artifactId>httpclient</artifactId>            <version>4.3.5</version>        </dependency>        <dependency>            <groupId>commons-httpclient</groupId>            <artifactId>commons-httpclient</artifactId>            <version>3.1</version>        </dependency>        <dependency>            <groupId>org.apache.commons</groupId>            <artifactId>commons-csv</artifactId>            <version>1.2</version>            <type>jar</type>            <scope>compile</scope>        </dependency>        <dependency>            <groupId>org.apache.commons</groupId>            <artifactId>commons-compress</artifactId>            <version>1.10</version>            <type>jar</type>            <scope>compile</scope>        </dependency>        <!-- file upload -->        <dependency>            <groupId>commons-fileupload</groupId>            <artifactId>commons-fileupload</artifactId>            <version>1.2.1</version>        </dependency>        <dependency>            <groupId>commons-io</groupId>            <artifactId>commons-io</artifactId>            <version>2.4</version>        </dependency>        <dependency>            <groupId>com.squareup.okhttp</groupId>            <artifactId>okhttp</artifactId>            <version>2.5.0</version>        </dependency>

配置applicationContext.xml
头部内容有所改变，童鞋们可以不变，但是如果编译过程中出现bug的话可以copy这份头部信息

<?xml version="1.0" encoding="UTF-8"?><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:jpa="http://www.springframework.org/schema/data/jpa" xmlns="http://www.springframework.org/schema/beans"    xmlns:task="http://www.springframework.org/schema/task"    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd        http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd"    default-lazy-init="true">

接下来就是一些JPA和方面的配置

<description>Spring公共配置</description>    <!-- 使用annotation 自动注册bean, 并保证@Required、@Autowired的属性被注入 -->    <context:component-scan base-package="com.demo">        <context:exclude-filter type="annotation"            expression="org.springframework.stereotype.Controller" />        <context:exclude-filter type="annotation"            expression="org.springframework.web.bind.annotation.ControllerAdvice" />    </context:component-scan>    <!-- Jpa Entity Manager 配置 -->    <bean id="entityManagerFactory"        class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">        <property name="dataSource" ref="dataSource" />        <!-- 设置hibernate方言 可以使用java类动态生成 -->        <property name="jpaVendorAdapter" ref="hibernateJpaVendorAdapter" />        <property name="packagesToScan" value="com.demo" />        <property name="jpaProperties">            <props>                <!-- 命名规则 My_NAME->MyName -->                <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>                <!-- 配置hibernate的属性 如果使用log4jdbc这个就不起作用 -->                <prop key="hibernate.show_sql">false</prop>                <prop key="hibernate.format_sql">false</prop>                <!--<prop key="hibernate.hbm2ddl.auto">create</prop> -->                <!-- validate 加载hibernate时，验证创建数据库表结构 create 每次加载hibernate，重新创建数据库表结构，这就是导致数据库表数据丢失的原因。                     create-drop 加载hibernate时创建，退出是删除表结构 update 加载hibernate自动更新数据库结构 -->                <prop key="hibernate.hbm2ddl.auto">none</prop>            </props>        </property>    </bean>    <bean id="hibernateJpaVendorAdapter"        class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">        <property name="databasePlatform">            <bean factory-method="getDialect" class="com.demo.support.Hibernates">                <constructor-arg ref="dataSource" />            </bean>        </property>    </bean>    <!-- 使用配置文件加载数据库配置 -->    <context:property-placeholder        ignore-unresolvable="true" location="classpath*:/application.properties" />    <!-- 数据源配置, 使用Tomcat JDBC连接池 -->    <!-- 默认数据源 -->    <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"        destroy-method="close">        <!-- Connection Info -->        <property name="driverClassName" value="${ds.driver}" />        <property name="url" value="${ds.url}" />        <property name="username" value="${ds.username}" />        <property name="password" value="${ds.password}" />        <!-- Connection Pooling Info -->        <property name="maxActive" value="${ds.pool.maxActive}" />        <property name="minIdle" value="${ds.pool.minIdle}" />        <property name="maxIdle" value="${ds.pool.maxIdle}" />        <property name="defaultAutoCommit" value="${ds.pool.defaultAutoCommit}" />    </bean>    <!-- Spring Data Jpa配置 -->    <jpa:repositories base-package="com.demo"        transaction-manager-ref="transactionManager"        entity-manager-factory-ref="entityManagerFactory" />    <!-- Jpa 事务配置 -->    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">        <property name="entityManagerFactory" ref="entityManagerFactory" />    </bean>    <!-- 使用annotation定义事务 -->    <tx:annotation-driven transaction-manager="transactionManager"        proxy-target-class="true" />

最后附上一份上述可能需要的工具类文件地址(private write read)工具包

到此完成mysql+JPA的支持