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&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的配置问题,其他都很容易配置实现。
c4.1.0+spring data jpa1.7.0+maven整合