基于maven,springmvc+mybatis+pagehepler分页配置
来源:互联网 发布:运动减肥软件 编辑:程序博客网 时间:2024/06/06 09:12
基于maven配置springmvc + mybatis + pagehelper分页,另外附上公共的BaseDao方法和BaseService方法
下载地址:http://download.csdn.net/download/qq346625506/10117580
项目结构
数据库
user表
项目名称musician
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>musician</groupId><artifactId>musician</artifactId><version>0.0.1-SNAPSHOT</version><packaging>war</packaging><properties><!-- spring版本号 --><spring.version>4.3.4.RELEASE</spring.version><!-- log4j日志文件管理包版本 --><slf4j.version>1.6.6</slf4j.version><log4j.version>1.2.12</log4j.version><!-- junit版本号 --><junit.version>4.10</junit.version><!-- mybatis版本号 --><mybatis.version>3.3.0</mybatis.version></properties><dependencies><dependency> <groupId>com.github.jsqlparser</groupId> <artifactId>jsqlparser</artifactId> <version>0.9.4</version></dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>4.1.1</version></dependency> <dependency><groupId>commons-io</groupId><artifactId>commons-io</artifactId><version>2.5</version></dependency><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.3.3</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.6.3</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-core</artifactId><version>2.6.3</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-annotations</artifactId><version>2.6.0</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.0</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.1</version><scope>provided</scope></dependency><!-- 添加Spring依赖 --><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context-support</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.8.12</version></dependency><dependency><groupId>commons-dbcp</groupId><artifactId>commons-dbcp</artifactId><version>1.4</version></dependency><!--单元测试依赖 --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>${junit.version}</version><scope>test</scope></dependency><!-- 日志文件管理包 --><!-- log start --><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>${log4j.version}</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>${slf4j.version}</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>${slf4j.version}</version></dependency><!-- log end --><!--spring单元测试依赖 --><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version><scope>test</scope></dependency><!--mybatis依赖 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency><!-- mybatis/spring包 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.2.0</version></dependency><!-- mysql驱动包 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.29</version></dependency></dependencies><build><plugins><plugin><groupId>org.eclipse.jetty</groupId><artifactId>jetty-maven-plugin</artifactId><version>9.2.8.v20150217</version></plugin><plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.3.1</version> <configuration> <source>1.8</source> <target>1.8</target> <encoding>UTF-8</encoding> </configuration> </plugin> </plugins></build></project>
2. jdbc.properties
jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/musician?useUnicode=true&autoReconnect=true&characterEncoding=UTF-8jdbc.username=rootjdbc.password=123456jdbc.maxActive=300jdbc.maxIdle=5
3. log4j.properties
#log4j.rootLogger=CONSOLE,info,error,DEBUGlog4j.rootLogger=info,error,CONSOLE,DEBUGlog4j.rootLogger=info,ServerDailyRollingFile,stdoutlog4j.appender.ServerDailyRollingFile=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.ServerDailyRollingFile.DatePattern='.'yyyy-MM-ddlog4j.appender.ServerDailyRollingFile.File=logs/log.loglog4j.appender.ServerDailyRollingFile.layout=org.apache.log4j.PatternLayoutlog4j.appender.ServerDailyRollingFile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} [%t] %-5p [%c] - %m%nlog4j.appender.ServerDailyRollingFile.Append=truelog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d %p [%c] %m%n
4. spring-context.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:mvc="http://www.springframework.org/schema/mvc" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd"><context:component-scan base-package="com.sy" /><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!-- dataSource在 applicationContext-dao.xml中配置了 --><property name="dataSource" ref="dataSource"></property></bean><!-- 通知 --><!-- transaction-manager 表示把这通知给谁 transactionManager就是上面的事务管理器的id --><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><!-- 传播行为 --><tx:method name="save*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="find*" propagation="SUPPORTS" read-only="true" /><tx:method name="get*" propagation="SUPPORTS" read-only="true" /><tx:method name="select*" propagation="SUPPORTS" read-only="true" /></tx:attributes></tx:advice><!-- aop 通知是有aop来调用 --><aop:config><!-- pointcut 表示aop的切点 --><!-- execution(* com.sy.service.impl.*.*(..)) 表示要切com.mybatis.service.impl这个包下面的所有类的所有方法 --><aop:advisor advice-ref="txAdvice"pointcut="execution(* com.sy.musician.service.impl.*.*(..))" /></aop:config><context:property-placeholder location="classpath:jdbc.properties"/> <!-- 配置数据源 --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <!-- 连接池最大数量 --> <property name="maxActive" value="${jdbc.maxActive}"/> <!-- 连接池最大空闲 --> <property name="maxIdle" value="${jdbc.maxIdle}"/> </bean> <!-- 配置SqlSessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 加载数据库连接池 --> <property name="dataSource" ref="dataSource"></property> <property name="mapperLocations" value="classpath*:mapper/com/sy/musician/**/*.xml"></property> <property name="plugins"> <array> <bean class="com.github.pagehelper.PageHelper"> <property name="properties"> <value> dialect=mysql </value> </property> </bean> </array> </property> </bean> <!-- 配置mapper扫描器 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!-- 扫描包路径,如果需要扫描多个,中间使用半角的逗号隔开 --> <property name="basePackage" value="com.sy.musician.dao.*"></property> <property name="SqlSessionFactoryBeanName" value="sqlSessionFactory"></property> </bean> </beans>
5. spring-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/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 http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd"> <context:component-scan base-package="com.sy" /><mvc:annotation-driven/> <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"> <property name="supportedMediaTypes"> <list> <value>text/html;charset=UTF-8</value> <value>text/plain;charset=UTF-8</value> <value>application/json;charset=UTF-8</value> </list> </property> </bean> <!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 --> <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> <property name="messageConverters"> <list> <ref bean="mappingJacksonHttpMessageConverter" /> <!-- JSON转换器 --> </list> </property> </bean> <!-- 定义跳转的文件的前后缀 ,视图模式配置--> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 --> <property name="prefix" value="/WEB-INF/jsp/" /> <property name="suffix" value=".jsp" /> </bean> <!-- 配置文件上传,如果没有使用文件上传可以不用配置,当然如果不配,那么配置文件中也不必引入上传组件包 --> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <!-- 默认编码 --> <property name="defaultEncoding" value="utf-8" /> <!-- 文件大小最大值 --> <property name="maxUploadSize" value="10485760000" /> <!-- 内存中的最大值 --> <property name="maxInMemorySize" value="40960" /> </bean> </beans>
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.sy.musician.dao.UserDao"><select id="selectByMap" parameterType="map" resultType="com.sy.musician.entity.User">select * from user where id = #{id}</select></mapper>
7. 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>musician</display-name><welcome-file-list><welcome-file>index.html</welcome-file><welcome-file>index.htm</welcome-file><welcome-file>index.jsp</welcome-file><welcome-file>default.html</welcome-file><welcome-file>default.htm</welcome-file><welcome-file>default.jsp</welcome-file></welcome-file-list><context-param><param-name>contextConfigLocation</param-name><param-value>/WEB-INF/classes/spring-*.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!-- springmvc前端控制器 --><servlet><servlet-name>spring-servlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring-servlet.xml</param-value></init-param></servlet><servlet-mapping><servlet-name>spring-servlet</servlet-name><url-pattern>/*</url-pattern></servlet-mapping></web-app>
8. IndexController.java
package com.sy.musician.controller;import java.util.HashMap;import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.bind.annotation.RestController;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import com.sy.musician.entity.JSONResult;import com.sy.musician.entity.User;import com.sy.musician.service.UserService;@RestControllerpublic class IndexController {@Autowiredprivate UserService userService;/** * 首页 */@RequestMapping("/index")public JSONResult index(HttpServletRequest request) {JSONResult jsonResult = new JSONResult();jsonResult.setFlag(true);Map<String, Object> params = new HashMap<>();params.put("id", 1);jsonResult.setData(userService.getUser(params));return jsonResult;}/** * 分页 */@RequestMapping("/pager")public JSONResult pager(@RequestParam(defaultValue="1") Integer page, @RequestParam(defaultValue="10") Integer pageSize) {JSONResult jsonResult = new JSONResult();jsonResult.setFlag(true);Map<String, Object> params = new HashMap<>();params.put("id", 1);PageHelper.startPage(page, pageSize);PageInfo<User> p = new PageInfo<User>(userService.getUser(params));jsonResult.setData(p);return jsonResult;}}
9. BaseDao.java
package com.sy.musician.dao;import java.util.List;import org.springframework.dao.DataAccessException;public interface BaseDao {/** * 新增 * @param obj * @throws DataAccessException */int insert(Object obj) throws DataAccessException;/** * 新增 * @param statementName * @param obj * @throws DataAccessException */int insert(String statementName, Object obj) throws DataAccessException;/** * 删除对象 * @param obj * @return * @throws DataAccessException */int delete(Object obj) throws DataAccessException;/** * 按主键ID删除记录 * @param statementName * @param objId * @return * @throws DataAccessException */int deleteById(Integer objId) throws DataAccessException;/** * 删除满足条件的所有记录 * * @param statementName * @param obj * 条件obj * @return * @throws DataAccessException */int delete(String statementName, Object obj) throws DataAccessException;/** * 按主键ID进行查找 * * @param objId * 主键ID * @return * @throws DataAccessException */Object selectById(Integer id) throws DataAccessException;/** * 更新对象 * * @param statementName * @param obj * 要更新的对象 * @return * @throws DataAccessException */int update(Object obj) throws DataAccessException;/** * 更新对象 * * @param statementName * @param obj * 要更新的对象 * @return * @throws DataAccessException */int update(String statementName, Object obj) throws DataAccessException;/** * 查询所有满足给定条件的对象列表 * * @param statementName * @param obj * 过滤条件obj * @return */List<?> selectList(String statementName, Object obj);/** * 查询所有满足给定条件的对象列表 * * @param obj * 过滤条件obj * @return */List<?> selectByMap(Object obj);/** * 查询所有满足给定条件的对象列表 * * @param statementName * @param obj * 过滤条件obj * @return */Object selectOne(String statementName, Object obj);}
10. BaseDaoImpl.java
package com.sy.musician.dao.impl;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.annotation.Resource;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.support.SqlSessionDaoSupport;import org.springframework.dao.DataAccessException;import org.springframework.stereotype.Repository;import com.sy.musician.dao.BaseDao;@Repositorypublic abstract class BaseDaoImpl extends SqlSessionDaoSupport implements BaseDao {/****************SqlMapper里面公共的方法******************/private static final String UPDATE = "update";private static final String INSERT = "insert";private static final String DELETE = "delete";private static final String SELECTBYMAP = "selectByMap";/** * 获得namespace */public abstract String getNamespace();/** * 获得statement * @param id 对应sqlmapper的id * @return */public String createStatement(String id) {return getNamespace() + id;}@Resource public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) { super.setSqlSessionFactory(sqlSessionFactory); }@Overridepublic int insert(String statementName, Object obj) throws DataAccessException {return getSqlSession().insert(statementName, obj);}@Overridepublic int update(String statementName, Object obj) throws DataAccessException {return getSqlSession().update(statementName, obj);}@Overridepublic List<?> selectList(String statementName, Object obj) {return getSqlSession().selectList(statementName, obj);}@Overridepublic int insert(Object obj) throws DataAccessException {return getSqlSession().insert(getNamespace() + INSERT, obj);}@Overridepublic Object selectById(Integer id) throws DataAccessException {Map<String, Object> params = new HashMap<>();params.put("id", id);return getSqlSession().selectOne(getNamespace() + SELECTBYMAP, params);}@Overridepublic int update(Object obj) throws DataAccessException {return update(getNamespace() + UPDATE, obj);}@Overridepublic int deleteById(Integer objId) throws DataAccessException {Map<String, Object> params = new HashMap<>();params.put("id", objId);return delete(params);}@Overridepublic int delete(Object obj) throws DataAccessException {return delete(getNamespace() + DELETE, obj);}@Overridepublic int delete(String statementName, Object obj) throws DataAccessException {return getSqlSession().delete(statementName, obj);}@Overridepublic Object selectOne(String statementName, Object obj) {return getSqlSession().selectOne(statementName, obj);}@Overridepublic List<?> selectByMap(Object obj) {return getSqlSession().selectList(getNamespace() + SELECTBYMAP, obj);} }
11. BaseService.java
package com.sy.musician.service;import java.util.List;import java.util.Map;public interface BaseService {/** * 查询 * @param params * @return */public List<?> selectByMap(Map<String, Object> params);/** * 新增 * @param obj * @return */public int insert(Object obj);/** * 更新 * @param obj * @return */public int update(Object obj);/** * 删除 * @param obj * @return */public int delete(Object obj);}
12. BaseServiceImpl.java
package com.sy.musician.service.impl;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import com.sy.musician.dao.BaseDao;import com.sy.musician.service.BaseService;public class BaseServiceImpl implements BaseService{@Autowiredprivate BaseDao baseDao;@Overridepublic List<?> selectByMap(Map<String, Object> params) {return baseDao.selectByMap(params);}@Overridepublic int insert(Object obj) {return baseDao.insert(obj);}@Overridepublic int update(Object obj) {return baseDao.update(obj);}@Overridepublic int delete(Object obj) {return baseDao.delete(obj);}}
其它的我就不附上了,详情可以直接把demo下载下来看。
另外运行出结果数据截图:
阅读全文
0 0
- 基于maven,springmvc+mybatis+pagehepler分页配置
- Mybatis分页插件-PageHepler的使用
- SpringMVC+MyBatis+MAVEN配置
- 基于maven的SpringMVC,Spring,MyBatis的全注解配置
- mybatis+springmvc+maven+Extjs配置
- maven-springmvc-mybatis整合配置
- maven-mybatis分页插件配置
- Maven+Mybatis+Spring+SpringMVC实现分页
- spring+SpringMVC+Maven+Mybatis+Mysql分页实现
- bootstrap + mybatis + maven + springmvc 实现分页效果
- SpringMVC+Spring+Mybatis基于Maven的整合
- 建立基于maven 的springmvc mybatis工程
- SpringMVC+maven+mybatis+mysql配置web应用
- maven+springmvc+spring+mybatis 配置实例
- maven springMVC + Mybatis + spring 常用配置
- maven+Spring+SpringMVC+Mybatis 整合 xml配置
- idea15 springmvc mybatis maven 的安装,配置
- springmvc/mybatis/maven环境配置1
- error LNK2005: _DllMain@12 已经在 MSVCRTD.lib(dllmain.obj) 中定义
- IBM X3500M3阵列卡坏了|更换raid阵列卡步骤
- asp.net弹出提示信息的几种方式
- osgEarth mapbox地图 20.mapbox.earth
- LayaAir类的写法
- 基于maven,springmvc+mybatis+pagehepler分页配置
- Spring Boot启动失败:...rethrowRuntimeException....
- 原生JS实现网页烟花动画效果——前端工程师必备技能!
- Spring4 之 Bean(二)
- Qt--qt.conf
- 和各种诡异 Bug 打交道 13 年,我总结了 18 条经验
- 【第二届蓝桥杯】轮换
- 深入理解 Promise 五部曲:3. 可靠性问题
- Converting circular structure to JSON