织梦做电子商务网站,如何推广app,合适做服装的国际网站,wordpress首页幻灯片尺寸一、前言 这里简单讲述一下如何快速使用springmvc和spring data jpa搭建后台开发工程#xff0c;并提供了一个简单的demo作为参考。 二、创建maven工程 http://www.cnblogs.com/hujunzheng/p/5450255.html 三、配置文件说明 1.application.properties jdbc.drivercom.mysql.jd… 一、前言 这里简单讲述一下如何快速使用springmvc和spring data jpa搭建后台开发工程并提供了一个简单的demo作为参考。 二、创建maven工程 http://www.cnblogs.com/hujunzheng/p/5450255.html 三、配置文件说明 1.application.properties jdbc.drivercom.mysql.jdbc.Driver
jdbc.urljdbc:mysql://localhost:3306/springdata?useUnicodetruecharacterEncodingutf-8
jdbc.usernameroot
jdbc.password123456
jdbc.pool.initialSize5
jdbc.pool.maxActive300
jdbc.pool.maxIdle10
jdbc.pool.minIdle8
jdbc.pool.maxWait60000
jdbc.pool.minEvictableIdleTimeMillis6000
jdbc.pool.removeAbandonedtrue
jdbc.pool.removeAbandonedTimeout120
jdbc.pool.logAbandonedtrue
jdbc.pool.testOnBorrowtrue
jdbc.pool.testWhileIdletrue
jdbc.pool.validationQueryselect 1 from dual
jdbc.pool.validationQueryTimeout1
jdbc.pool.timeBetweenEvictionRunsMillis30000
jdbc.pool.numTestsPerEvictionRun300 View Code 配置数据库连接的常用属性 2.spring公共配置文件 ?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xmlns:contexthttp://www.springframework.org/schema/contextxsi:schemaLocationhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsddefault-lazy-inittruedescriptionSpring公共配置/descriptionbean idpropertyConfigurerclassorg.springframework.beans.factory.config.PropertyPlaceholderConfigurerproperty namelocationslistvalue/WEB-INF/config/application.properties/value/list/property/beanbean idconfigPropertiesclassorg.springframework.beans.factory.config.PropertiesFactoryBeanproperty namelocationslistvalue/WEB-INF/config/application.properties/value/list/property/bean!-- 使用annotation 自动注册bean, 并保证Required、Autowired的属性被注入 --context:component-scan base-packagecom.hjzcontext:exclude-filter typeannotationexpressionorg.springframework.stereotype.Controller /context:exclude-filter typeannotationexpressionorg.springframework.web.bind.annotation.ControllerAdvice //context:component-scan
/beans View Code 配置configProperties可以在xml文件中读取application.properties中属性,当然换成context:property-placeholder locationapplication.properties/更简洁一些。还有就是使用annotation 自动注册bean, 并保证Required、Autowired的属性被注入这里排除了Controller注解类的扫描。 3.spring mvc配置文件 ?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xmlns:contexthttp://www.springframework.org/schema/contextxmlns:mvchttp://www.springframework.org/schema/mvcxsi:schemaLocationhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsdhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsdcontext:component-scan base-packagecom.hjzuse-default-filtersfalsecontext:include-filter typeannotationexpressionorg.springframework.stereotype.Controller /context:include-filter typeannotationexpressionorg.springframework.web.bind.annotation.ControllerAdvice //context:component-scanmvc:annotation-drivenmvc:message-converters register-defaultstruebean classorg.springframework.http.converter.StringHttpMessageConverterconstructor-arg valueUTF-8 /property namewriteAcceptCharset valuefalse //beanbean classorg.springframework.http.converter.json.MappingJackson2HttpMessageConverterproperty nameprettyPrint valuetrue //bean/mvc:message-converters/mvc:annotation-drivenbeanclassorg.springframework.web.servlet.view.InternalResourceViewResolverproperty nameprefix value/WEB-INF/views/ /property namesuffix value.jsp //bean!-- 静态资源访问 --mvc:resources location/WEB-INF/img/ mapping/img/**/ mvc:resources location/WEB-INF/js/ mapping/js/**/ mvc:resources location/WEB-INF/css/ mapping/css/**/ mvc:default-servlet-handler //beans View Code 配置对Controller注解类的扫描消息转换器针对String和Json的解析视图解析器这里只配置了jsp的视图解析器静态资源的访问映射。 4.spring data jpa配置文件 ?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xmlns:txhttp://www.springframework.org/schema/txxmlns:jpahttp://www.springframework.org/schema/data/jpaxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.0.xsdhttp://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsddefault-lazy-inittrue!-- 数据源配置, 使用Tomcat JDBC连接池 --bean iddataSource classorg.apache.commons.dbcp.BasicDataSourcedestroy-methodcloseproperty namedriverClassName value${jdbc.driver} /property nameurl value${jdbc.url} /property nameusername value${jdbc.username} /property namepassword value${jdbc.password} /!--initialSize: 初始化连接 --property nameinitialSize value${jdbc.pool.initialSize} /!--maxActive: 最大连接数量 --property namemaxActive value${jdbc.pool.maxActive} /!--minIdle: 最小空闲连接 --property nameminIdle value${jdbc.pool.minIdle} /!--maxIdle: 最大空闲连接 --property namemaxIdle value${jdbc.pool.maxIdle} /!--maxWait: 超时等待时间以毫秒为单位 --property namemaxWait value${jdbc.pool.maxWait} /!-- 连接被泄露时是否打印 --property namelogAbandoned value${jdbc.pool.logAbandoned} /!--removeAbandoned: 是否自动回收超时连接 --property nameremoveAbandoned value${jdbc.pool.removeAbandoned} /!--removeAbandonedTimeout: 超时时间(以秒数为单位) --property nameremoveAbandonedTimeout value${jdbc.pool.removeAbandonedTimeout} /!-- 连接在池中保持空闲而不被空闲连接回收器线程(如果有)回收的最小时间值单位毫秒 --property nameminEvictableIdleTimeMillis value${jdbc.pool.minEvictableIdleTimeMillis} /property nametestOnBorrow value${jdbc.pool.testOnBorrow} /property nametestWhileIdle value${jdbc.pool.testWhileIdle} /property namevalidationQuery value${jdbc.pool.validationQuery} /property namevalidationQueryTimeout value${jdbc.pool.validationQueryTimeout} /property nametimeBetweenEvictionRunsMillis value${jdbc.pool.timeBetweenEvictionRunsMillis} /property namenumTestsPerEvictionRun value${jdbc.pool.numTestsPerEvictionRun} //bean!-- Jpa Entity Manager 配置 --bean identityManagerFactoryclassorg.springframework.orm.jpa.LocalContainerEntityManagerFactoryBeanproperty namedataSource refdataSource /property namejpaVendorAdapter refhibernateJpaVendorAdapter /property namepackagesToScanarrayvaluecom.hjz/value/array/propertyproperty namejpaPropertiesprops!-- 命名规则 My_NAME-MyName --prop keyhibernate.dialectorg.hibernate.dialect.MySQLDialect/propprop keyhibernate.ejb.naming_strategyorg.hibernate.cfg.ImprovedNamingStrategy/propprop keyhibernate.show_sqltrue/prop/props/property/bean!-- Spring Data Jpa配置 --jpa:repositories base-packagecom.hjztransaction-manager-reftransactionManagerentity-manager-factory-refentityManagerFactoryfactory-classcom.hjz.dao.impl.BaseDaoFactoryBean/jpa:repositoriesbean idhibernateJpaVendorAdapterclassorg.springframework.orm.jpa.vendor.HibernateJpaVendorAdapterproperty namedatabasePlatformbean factory-methodgetDialectclassorg.springside.modules.persistence.Hibernatesconstructor-arg refdataSource //bean/property/bean!-- Jpa 事务配置 --bean idtransactionManager classorg.springframework.orm.jpa.JpaTransactionManagerproperty nameentityManagerFactory refentityManagerFactory //bean!-- 使用annotation定义事务 --tx:annotation-driven transaction-managertransactionManagerproxy-target-classtrue /bean idjdbcTemplate classorg.springframework.jdbc.core.JdbcTemplateproperty namedataSource refdataSource/property/bean/beans View Code 数据源配置, 使用Tomcat JDBC连接池Jpa Entity Manager 配置Spring Data Jpa repository 自定义工厂配置。 5.web.xml ?xml version1.0 encodingUTF-8?
web-app xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xmlnshttp://java.sun.com/xml/ns/javaee xsi:schemaLocationhttp://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd version3.0display-nameArchetype Created Web Application/display-namewelcome-file-listwelcome-file/WEB-INF/views/index.html/welcome-file/welcome-file-listcontext-paramparam-namecontextConfigLocation/param-nameparam-value/WEB-INF/config/applicationContext.xml,/WEB-INF/config/applicationContext-jpa.xml/param-value/context-paramcontext-paramparam-namespring.profiles.default/param-nameparam-valueproduction/param-value/context-paramfilterfilter-nameencodingFilter/filter-namefilter-classorg.springframework.web.filter.CharacterEncodingFilter/filter-classinit-paramparam-nameencoding/param-nameparam-valueUTF-8/param-value/init-paraminit-paramparam-nameforceEncoding/param-nameparam-valuetrue/param-value/init-param/filterfilter-mappingfilter-nameencodingFilter/filter-nameurl-pattern/*/url-pattern/filter-mappingfilterfilter-nameaccessControlFilter/filter-namefilter-classcom.hjz.filter.AccessControlFilter/filter-class/filterfilter-mappingfilter-nameaccessControlFilter/filter-nameurl-pattern/*/url-pattern/filter-mappinglistenerlistener-classorg.springframework.web.context.ContextLoaderListener/listener-class/listenerfilterfilter-nameopenEntityManagerInViewFilter/filter-namefilter-classorg.springframework.orm.jpa.support.OpenEntityManagerInViewFilter/filter-class/filterfilter-mappingfilter-nameopenEntityManagerInViewFilter/filter-nameurl-pattern/*/url-pattern/filter-mappingservletservlet-namespringServlet/servlet-nameservlet-classorg.springframework.web.servlet.DispatcherServlet/servlet-classinit-paramparam-namecontextConfigLocation/param-nameparam-value/WEB-INF/config/spring-mvc-config.xml/param-value/init-paramload-on-startup1/load-on-startup/servletservlet-mappingservlet-namespringServlet/servlet-nameurl-pattern//url-pattern/servlet-mappingsession-configsession-timeout20/session-timeout/session-configerror-pageexception-typejava.lang.Throwable/exception-typelocation/WEB-INF/views/error/500.jsp/location/error-pageerror-pageerror-code500/error-codelocation/WEB-INF/views/error/500.jsp/location/error-pageerror-pageerror-code404/error-codelocation/WEB-INF/views/error/404.jsp/location/error-page
/web-app View Code 配置welcome-file-listcontextConfigLocationencodingFilteraccessControlFilter解决跨域访问openEntityManagerInViewFilter将一个JPAsession与一次完整的请求过程对应的线程相绑定session在整个view层结束后才关闭。Spring ContextLoaderListenerSpring MVC DispatcherServlet。 四、spring data jpa自定义repository工厂 1.基础实体类 package com.hjz.entity;import org.hibernate.annotations.GenericGenerator;import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.MappedSuperclass;
import java.io.Serializable;
import java.sql.Timestamp;MappedSuperclass
public abstract class AbsIdEntity implements Serializable {private static final long serialVersionUID 7988377299341530426L;public final static int IS_DELETE_YES 1;// 标记删除public final static int IS_DELETE_NO 0;// 未删除,保留的IdGenericGenerator(nameuuid, strategyuuid)GeneratedValue(generatoruuid)protected String id;Column(name creationtime)protected Timestamp creationTimestamp new Timestamp(System.currentTimeMillis());Column(name lastmodifiedtime)protected Timestamp modificationTimestamp new Timestamp(System.currentTimeMillis());Column(name dr)protected int dr;// 是否删除。0:未删除;1:已删除/*** 主键对应id字段*/public String getId() { return id; }public void setId(String id) { this.id id; }/*** 创建日期对应ts_insert字段*/public Timestamp getCreationTimestamp() { return creationTimestamp; }public void setCreationTimestamp(Timestamp creationTimestamp) { this.creationTimestamp creationTimestamp; }/*** 修改日期对应ts_update字段*/public Timestamp getModificationTimestamp() { return modificationTimestamp; }public void setModificationTimestamp(Timestamp modificationTimestamp) { this.modificationTimestamp modificationTimestamp; }/*** 是否删除对应dr字段* return*/public int getDr() {return dr;}public void setDr(int dr) {this.dr dr;}} View Code 首先说明所有的实体类都会继承 基础实体类 AbsIdEntity。 对应的VO类 package com.hjz.vo;import java.io.Serializable;public class PersonVO extends SuperVO implements Serializable{private static final long serialVersionUID -4745138914786180462L;private String name;private int age;public String getName() {return name;}public void setName(String name) {this.name name;}public int getAge() {return age;}public void setAge(int age) {this.age age;}
} View Code 2.自定义工厂 package com.hjz.dao.impl;import java.io.Serializable;
import javax.persistence.EntityManager;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.support.JpaRepositoryFactory;
import org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean;
import org.springframework.data.jpa.repository.support.SimpleJpaRepository;
import org.springframework.data.repository.core.RepositoryInformation;
import org.springframework.data.repository.core.RepositoryMetadata;
import org.springframework.data.repository.core.support.RepositoryFactorySupport;import com.hjz.entity.AbsIdEntity;public class BaseDaoFactoryBeanR extends JpaRepositoryT, Serializable, T extends AbsIdEntity extends JpaRepositoryFactoryBeanR, T, Serializable {Overrideprotected RepositoryFactorySupport createRepositoryFactory(final EntityManager entityManager) {return new JpaRepositoryFactory(entityManager) {protected SimpleJpaRepositoryT, Serializable getTargetRepository(RepositoryInformation information, EntityManager entityManager) {return new BaseDaoImpl((ClassT) information.getDomainType(), entityManager);}Overrideprotected Class? getRepositoryBaseClass(RepositoryMetadata metadata) {return BaseDaoImpl.class;}};}
} View Code 工厂中返回的自定义的JpaRepository, 如下。 3.自定义JpaRepository package com.hjz.dao.impl;import java.io.Serializable;
import java.sql.Timestamp;import javax.persistence.EntityManager;import org.springframework.data.jpa.repository.support.JpaEntityInformation;
import org.springframework.data.jpa.repository.support.SimpleJpaRepository;
import org.springframework.transaction.annotation.Transactional;import com.hjz.dao.BaseDao;
import com.hjz.entity.AbsIdEntity;
Transactional
public class BaseDaoImplT extends AbsIdEntity extends SimpleJpaRepositoryT, Serializable implements BaseDaoT {private final EntityManager entityManager;public BaseDaoImpl(ClassT domainClass, EntityManager entityManager) {super(domainClass, entityManager);this.entityManager entityManager;}public BaseDaoImpl(JpaEntityInformationT, Serializable information, EntityManager entityManager){super(information, entityManager);this.entityManager entityManager;}Overridepublic S extends T S save(S entity) {entity.setModificationTimestamp(new Timestamp(System.currentTimeMillis()));return super.save(entity);}//进行逻辑删除Overridepublic void delete(T entity) {entity.setDr(1);save(entity);}Overridepublic void delete(Serializable id) {T entity findOne(id);entity.setDr(1);this.save(entity);}} View Code 重写了删除方法这里做逻辑删除。 五、后台开发模式 1.实体类 package com.hjz.entity;import java.io.Serializable;import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;Entity
Table(name person)
public class PersonEntity extends AbsIdEntity implements Serializable{private static final long serialVersionUID -1649223236097252346L;Column(name name)private String name;Column(name age)private int age;public String getName() {return name;}public void setName(String name) {this.name name;}public int getAge() {return age;}public void setAge(int age) {this.age age;}
} View Code 实体对应的VO package com.hjz.vo;import java.io.Serializable;public class PersonVO extends SuperVO implements Serializable{private static final long serialVersionUID -4745138914786180462L;private String name;private int age;public String getName() {return name;}public void setName(String name) {this.name name;}public int getAge() {return age;}public void setAge(int age) {this.age age;}
} View Code 2.repository类 package com.hjz.dao;import java.util.List;import javax.transaction.Transactional;import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;import com.hjz.entity.PersonEntity;public interface PersonDao extends BaseDaoPersonEntity{Query(value select * from person where dr 0, nativeQuery true)ListPersonEntity findAllPersons();Query(value select * from person where dr 0 and id ?1, nativeQuery true)PersonEntity findOneById(String id);TransactionalModifyingQuery(value update PersonEntity set dr 1 where id in (?1))int deletePersons(ListString ids);
} View Code 3.service类 package com.hjz.service;import java.util.ArrayList;
import java.util.List;import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Service;import com.hjz.dao.PersonDao;
import com.hjz.entity.PersonEntity;
import com.hjz.vo.PersonVO;Service
public class PersonService {Autowiredprivate PersonDao personDao;public ListPersonVO findAllPersons(){ListPersonVO listVO new ArrayList();ListPersonEntity listEntity personDao.findAllPersons();for(PersonEntity entity : listEntity) {PersonVO vo new PersonVO();BeanUtils.copyProperties(entity, vo);listVO.add(vo);}return listVO;}public ListPersonVO findPageablePersons(Pageable pageable){ListPersonVO listVO new ArrayList();PagePersonEntity pageEntity personDao.findAll(new SpecificationPersonEntity() {Overridepublic Predicate toPredicate(RootPersonEntity root, CriteriaQuery? query, CriteriaBuilder cb) {return cb.equal(root.get(dr).as(Integer.class), 0);}}, pageable);for (PersonEntity entity : pageEntity) {PersonVO personVO new PersonVO();BeanUtils.copyProperties(entity, personVO);listVO.add(personVO);}return listVO;}public long count() {return personDao.count(new SpecificationPersonEntity() {Overridepublic Predicate toPredicate(RootPersonEntity root, CriteriaQuery? query, CriteriaBuilder cb) {return cb.equal(root.get(dr).as(Integer.class), 0);}});}public PersonVO findOnePerson(String id){PersonVO vo new PersonVO();PersonEntity entity personDao.findOneById(id);BeanUtils.copyProperties(entity, vo);return vo;}public void deleteOnePerson(String id) {personDao.delete(id);}public PersonVO save(PersonVO vo){PersonEntity entity new PersonEntity();BeanUtils.copyProperties(vo, entity);personDao.save(entity);BeanUtils.copyProperties(entity, vo);return vo;}public void deletePersons(ListString ids) {personDao.deletePersons(ids);}
} View Code 4.controller类 package com.hjz.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;import com.alibaba.fastjson.JSONObject;
import com.hjz.code.ReturnCode;
import com.hjz.page.PagableResponse;
import com.hjz.service.PersonService;
import com.hjz.vo.PersonVO;Controller
RequestMapping(value person)
public class PersonController {Autowiredprivate PersonService personService;RequestMapping(value save, method RequestMethod.POST)ResponseBodypublic JSONObject save(RequestBody PersonVO personVO){JSONObject ret new JSONObject();try {personService.save(personVO);ret.put(msg, 保存成功!);ret.put(code, ReturnCode.SUCCESS);} catch (Exception e) {e.printStackTrace();ret.put(msg, 保存失败!);ret.put(code, ReturnCode.FAILURE);}return ret;}RequestMapping(value del)ResponseBodypublic JSONObject del(RequestParam(valueid) String id){JSONObject ret new JSONObject();try {personService.deleteOnePerson(id);ret.put(msg, 删除成功!);ret.put(code, ReturnCode.SUCCESS);} catch (Exception e) {e.printStackTrace();ret.put(msg, 删除失败!);ret.put(code, ReturnCode.FAILURE);}return ret;}RequestMapping(value delBatch, method RequestMethod.POST)ResponseBodypublic JSONObject delBatch(RequestParam(ids) ListString ids){JSONObject ret new JSONObject();try {personService.deletePersons(ids);ret.put(msg, 批量删除成功!);ret.put(code, ReturnCode.SUCCESS);} catch (Exception e) {e.printStackTrace();ret.put(msg, 批量删除失败!);ret.put(code, ReturnCode.FAILURE);}return ret;}RequestMapping(value page)public ModelAndView page(RequestParam(pageNumber) int pageNumber, RequestParam(pageSize) int pageSize) {PageRequest pageRequest new PageRequest(pageNumber-1, pageSize);PagableResponsePersonVO response new PagableResponsePersonVO();response.setPageNumber(pageNumber);response.setPageSize(pageSize);try {ListPersonVO data personService.findPageablePersons(pageRequest);long count personService.count();response.setList(data);response.setCount(count);response.setCode(ReturnCode.SUCCESS);response.setMsg(获取人员信息成功);} catch(Exception e) {e.printStackTrace();response.setCode(ReturnCode.FAILURE);response.setMsg(获取人员信息失败); }return new ModelAndView(person, page, response);}
} View Code 六、前端开发 简单的使用jquery及其一些插件完成了数据的分页jquery.paginate.js数据的新增删除批量删除等操作。具体的页面代码请看完整项目。演示效果如下图所示。 七、完整项目 https://github.com/hjzgg/springmvcAndSpringDataJpa 转载于:https://www.cnblogs.com/hujunzheng/p/5883188.html
