spring4.1.0+spring mvc4.1.0+spring data jpa1.7.0+maven整合

最新推荐文章于 2020-04-02 18:31:48 发布

最新推荐文章于 2020-04-02 18:31:48 发布 · 244 阅读

文章标签：

#测试 #数据库 #json

spring 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了如何使用Spring 4.1版本整合Spring MVC和Spring Data JPA，通过示例展示了如何配置Maven依赖、persistence.xml、applicationContext.xml等关键文件，并提供了一个简单的持久层接口实现。

个人博客：http://www.loveweir.com/

spring4.1.0已经正式发布了，整合一下使用spring mvc和spring 的jpa，之前的另一个项目有用到，感觉挺好用的，有减少了很多工作量，而且用起来简单，今天在搭建一个最新的。

首先从maven开始，我用的myeclipse2014.

1.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>loveweir</groupId>
	<artifactId>loveweir</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>
	<name>loveweir</name>
	<description />
	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.1.0.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.1.0.RELEASE</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>4.1.0.RELEASE</version>
		</dependency>

		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>4.3.6.Final</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-entitymanager</artifactId>
			<version>4.3.6.Final</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.data</groupId>
			<artifactId>spring-data-jpa</artifactId>
			<version>1.7.0.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.32</version>
		</dependency>

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.0.9</version>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.1.41</version>
		</dependency>
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit-dep</artifactId>
			<version>4.11</version>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp.jstl</groupId>
			<artifactId>javax.servlet.jsp.jstl-api</artifactId>
			<version>1.2.1</version>
		</dependency>
		<dependency>
			<groupId>org.glassfish.web</groupId>
			<artifactId>jstl-impl</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-lang3</artifactId>
			<version>3.3.2</version>
		</dependency>
		<dependency> 
       <groupId>db2jcc</groupId> 
       <artifactId>db2jcc</artifactId> 
       <version>8.2</version> 
    </dependency>
	</dependencies>
	<build>
		<plugins>
			<plugin>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>2.3.2</version>
				<configuration>
					<source>1.6</source>
					<target>1.6</target>
				</configuration>
			</plugin>
			<plugin>
				<artifactId>maven-war-plugin</artifactId>
				<version>2.2</version>
				<configuration>
					<version>3.0</version>
					<failOnMissingWebXml>false</failOnMissingWebXml>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

这里就不解释了，一看就明白了。

2.persistence.xml文件：

这个文件我就不解释放在哪里了。

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
	<persistence-unit name="loveweir">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>  
        <properties>
            <!--配置Hibernate方言 -->
            <!-- <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" /> -->
            <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />
            <!--配置数据库驱动 -->
            <!-- <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" /> -->
            <property name="hibernate.connection.driver_class" value="com.ibm.db2.jcc.DB2Driver" />
            <!--配置数据库用户名 -->
            <property name="hibernate.connection.username" value="db2admin" />
            <!--配置数据库密码 -->
            <property name="hibernate.connection.password" value="wiseknitssap" />
            <!--配置数据库url -->
            <!-- <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/loveweir?useUnicode=true&amp;characterEncoding=UTF-8" /> -->
            <property name="hibernate.connection.url" value="jdbc:db2://172.168.1.20:50000/wk_prod" />
            <!--设置外连接抓取树的最大深度 -->
            <property name="hibernate.max_fetch_depth" value="3" />
            <!--自动输出schema创建DDL语句 -->
            <!-- <property name="hibernate.hbm2ddl.auto" value="update" /> -->
            <property name="hibernate.show_sql" value="true" />
            <property name="hibernate.format_sql" value="true" />
            <property name="javax.persistence.validation.mode" value="none"/>
        </properties>
    </persistence-unit>
</persistence>

我用的数据库是ibm db2 ，大家自行使用。

3.applicationContext.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:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:jpa="http://www.springframework.org/schema/data/jpa"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:util="http://www.springframework.org/schema/util"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd
		http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd">
	
	<context:annotation-config/>
	<context:component-scan base-package="com.loveweir"/>
  	<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
  		<property name="persistenceUnitName" value="loveweir"></property>
  		<property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml"></property>
  		<property name="jpaVendorAdapter">
  			<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
  				<property name="showSql" value="true"></property>
  				<property name="database" value="MYSQL"></property>
  			</bean>
  		</property>
  	</bean>
  
	<!-- 自动扫描并注入Spring Data JPA -->
	<jpa:repositories base-package="com.loveweir.dao" entity-manager-factory-ref="entityManagerFactory" transaction-manager-ref="transactionManager">
	</jpa:repositories>	

    <!-- 配置事务管理器 -->
	<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="entityManagerFactory" />
	</bean>
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="false"/>	
</beans>

4.loveweir-servlet.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:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
		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-4.1.xsd">
	
	<context:component-scan base-package="com.loveweir.controller"/>
	<bean id="fastJsonHttpMessageConverter"
		class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
		<property name="supportedMediaTypes">
			<list>
				<value>application/json</value>
			</list>
		</property>
	</bean>
	<bean
		class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
		<property name="messageConverters">
			<list>
				<ref bean="fastJsonHttpMessageConverter" />
			</list>
		</property>
	</bean>
	<!-- 对模型视图名称的解析，即在模型视图名称添加前后缀 -->
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="viewClass"
			value="org.springframework.web.servlet.view.JstlView" />
		<property name="prefix" value="/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>

    <!-- 支持上传文件 -->  
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>
</beans>

这里想说的是不要加：<mvc:annotation-driven></mvc:annotation-driven> 这个东西，

我在这个地方出现的问题是加了这个东西回报这样的错误：

Failed to load resource: the server responded with a status of 406 (Not Acceptable)

昨天弄了一天网上看了好多帖子都不行，今天有测试把<mvc:annotation-driven></mvc:annotation-driven>去掉，

没想到json就获取到了。

5.web.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>loveweir</display-name>
  <!-- 默认的spring配置文件是在WEB-INF下的applicationContext.xml -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/applicationContext.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<filter>
		<filter-name>OpenEntityManagerInViewFilter</filter-name>
		<filter-class>org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter</filter-class>
		<init-param>
			<param-name>entityManagerFactoryBeanName</param-name>
			<param-value>entityManagerFactory</param-value>
		</init-param>
		<init-param>
			<param-name>persistenceUnitName</param-name>
			<param-value>activitioa</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>OpenEntityManagerInViewFilter</filter-name>
		<url-pattern>*.do</url-pattern>
	</filter-mapping>

<!-- 配置spring mvc的相关内容，此处的servlet-name任意，但必须有<your servlet-name>-servlet.xml与之对应 -->
	<servlet>
		<servlet-name>loveweir</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>loveweir</servlet-name>
		<!-- 配置所有的页面 -->
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	
	<!-- 配置过滤器，同时把所有的请求都转为utf-8编码 -->
	<filter>
		<filter-name>Spring character encoding filter</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>
		<init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
	</filter>
	<filter-mapping>
		<filter-name>Spring character encoding filter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

配置就这些了，下面就是怎么整合spring data jpa,

spring data jpa 主要的作用是简化了做持久层的操作，spring data jpa做了非常好的封装。

public interface MenuDao extends PagingAndSortingRepository<Tmenu, String>{

	@Query("select o from Tmenu o where o.tmenu is null")
	public List<Tmenu> getListIsNull();
	@Query("select o from Tmenu o where o.tmenu.id=?")
	public List<Tmenu> getListById(String id);
}

例如这样一个接口，只需要继承PagingAndSortingRepository就ok，就可以实现CRUD还包括分页等持久化工作。

大家想了解的更多可以到网上搜搜：http://www.ibm.com/developerworks/cn/opensource/os-cn-spring-jpa/

好了就上面的一个接口就完成了持久层的工作，业务层不变需要service和其实现类

public interface MenuService {

	public List<MenuVo> tree();
	
	public List<MenuVo> gettrees(String id);
	
	public Tmenu find(String id);
	
	public void save(Tmenu tmenu);
	
	public void delete(String id);
}

@Service("menuService")
@Transactional
public class MenuServiceImpl implements MenuService {

	@Autowired
	private MenuDao menuDao;
	
	@Transactional(readOnly=true,propagation=Propagation.REQUIRED)
	public List<MenuVo> tree() {
		List<Tmenu> tmenus = (List<Tmenu>) menuDao.findAll();
		List<MenuVo> menus = new ArrayList<MenuVo>();
		MenuVo m = null;
		for (Tmenu tmenu : tmenus) {
			m = new MenuVo();
			m.setId(tmenu.getId());
			m.setIconcls(tmenu.getIconcls());
			m.setName(tmenu.getText());
			m.setUrl(tmenu.getUrl());
			Tmenu t = tmenu.getTmenu();
			if (t!=null) {
				m.setPid(t.getId());
				m.setPname(t.getText());
			}
			menus.add(m);
		}
		return menus;
	}
	@Transactional(readOnly=true,propagation=Propagation.REQUIRED)
	public List<MenuVo> gettrees(String id) {
		List<Tmenu> tmenus = null;
		if (id==null) {
			tmenus = menuDao.getListIsNull();
		}else {
			tmenus = menuDao.getListById(id);
		}
		List<MenuVo> menus = new ArrayList<MenuVo>();
		MenuVo m = null;
		for (Tmenu tmenu : tmenus) {
			m = new MenuVo();
			BeanUtils.copyProperties(tmenu, m);
			Set<Tmenu> tmenus2 = tmenu.getTmenus();
			Map<String, Object> attributes = new HashMap<String, Object>();
			attributes.put("url", tmenu.getUrl());
			m.setAttributes(attributes);
			if (tmenus2!=null && !tmenus2.isEmpty()) {
				m.setState("closed");
			}else {
				m.setState("open");
			}
			menus.add(m);
		}
		return menus;
	}
	
	@Transactional(readOnly=true,propagation=Propagation.REQUIRED)
	public Tmenu find(String id) {
		return menuDao.findOne(id);
	}
	
	public void save(Tmenu tmenu) {
		menuDao.save(tmenu);
	}
	
	public void delete(String id) {
		menuDao.delete(id);
	}
}

从实现类中可以看到spring data jpa 对持久层的封装是如此的完美。

控制层我就不写了。

这次整合出现的问题最多的是json格式的获取，也就是loveweir-servlet.xml的配置问题，其他都很容易配置实现。