整合maven+spring+springmvc+mybatis实现ssm通用增删查改基础开发框架

整合maven+spring+springmvc+mybatis实现ssm基础开发框架,封装通用增删查改api,提高程序开发效率

myeclipse创建maven项目:

把maven项目转成maven web项目:项目右键Properties

把WebRoot里面的东西移到src/main/webapp下面

打开pom.xml,加入如下,否则报错

项目缺少web.xml文件,在src/main/webapp/WEB-INF下加入web.xml文件即可

pom.xml管理ssm相关jar包

<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>com.xe.demo</groupId><artifactId>demo-ssm</artifactId><version>0.0.1-SNAPSHOT</version><packaging>war</packaging><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><jdk.version>1.8</jdk.version><spring.version>4.2.5.RELEASE</spring.version><mybatis.version>3.3.1</mybatis.version><mybatis.spring.version>1.2.4</mybatis.spring.version><mysql.version>5.1.29</mysql.version><fastjson.version>1.2.4</fastjson.version><druid.version>1.0.13</druid.version></properties><dependencies><!--web --><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.1.0</version></dependency><!-- spring --><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-oxm</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId></dependency><!--spring-aop依赖 --><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.8.2</version></dependency><!--spring-json依赖 --><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.4.6</version></dependency><!--Mybatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>${mybatis.spring.version}</version></dependency><!--分页插件 --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>4.1.6</version></dependency><!--mysql --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><!--druid --><dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>${fastjson.version}</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>${druid.version}</version></dependency><!-- commons --><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.3</version></dependency><dependency><groupId>commons-collections</groupId><artifactId>commons-collections</artifactId><version>3.2.2</version></dependency><dependency><groupId>org.apache.commons</groupId><artifactId>commons-lang3</artifactId><version>3.1</version></dependency><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency></dependencies><dependencyManagement><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-framework-bom</artifactId><version>${spring.version}</version><type>pom</type><scope>import</scope></dependency></dependencies></dependencyManagement><build><plugins><plugin><artifactId>maven-compiler-plugin</artifactId><configuration><source>1.8</source><target>1.8</target></configuration></plugin><!-- 打成war包 --><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-war-plugin</artifactId><configuration><warName>ssm</warName></configuration></plugin></plugins></build></project>

删除WebRoot目录,右键更新项目

创建项目包结构

到此项目基础结构创建完成

==================================================整合ssm==================================================

配置mybatis-config.xml:

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><settings><!-- mybatis支持log4j日志 --><setting name="logImpl" value="LOG4J"/><!-- 开启缓存 --><setting name="cacheEnabled" value="true" /><!-- 开启全局懒加载 --><setting name="lazyLoadingEnabled" value="true" /><!-- 当设置为‘true’的时候，懒加载的对象可能被任何懒属性全部加载。否则，每个属性都按需加载 --><setting name="aggressiveLazyLoading" value="false" /><!-- 允许单一语句返回多结果集 --><setting name="multipleResultSetsEnabled" value="true" /><!-- 使用列标签代替列名 --><setting name="useColumnLabel" value="true" /><!-- 允许 JDBC 支持生成的键 --><setting name="useGeneratedKeys" value="true" /><!-- 指定 MyBatis 如何自动映射列到字段/ 属性 --><setting name="autoMappingBehavior" value="FULL" /><!-- 配置默认的执行器 --><setting name="defaultExecutorType" value="REUSE" /><!-- 设置超时时间 --><setting name="defaultStatementTimeout" value="25000" /></settings><plugins><!-- 分页插件 --><plugin interceptor="com.github.pagehelper.PageHelper"/></plugins></configuration>

配置spring-mybatis.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:tx="http://www.springframework.org/schema/tx"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:mvc="http://www.springframework.org/schema/mvc"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.2.xsd    http://www.springframework.org/schema/tx    http://www.springframework.org/schema/tx/spring-tx-4.2.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-4.2.xsd    http://www.springframework.org/schema/aop    http://www.springframework.org/schema/aop/spring-aop-4.2.xsd    http://www.springframework.org/schema/cache    http://www.springframework.org/schema/cache/spring-cache-4.2.xsd    http://www.springframework.org/schema/mvc    http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd"><mvc:annotation-driven /><!-- 启动组件扫描，排除@Controller组件，该组件由SpringMVC配置文件扫描 --><context:component-scan base-package="com.xe.demo"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /></context:component-scan><!-- mysql数据源 --><bean id="mysqlDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"><property name="driverClassName" value="${mysql.driver}" /><property name="url" value="${mysql.url}" /><property name="username" value="${mysql.username}" /><property name="password" value="${mysql.password}" /><property name="defaultAutoCommit" value="false" /><property name="maxActive" value="20" /><property name="initialSize" value="1" /><property name="maxWait" value="60000" /><property name="minIdle" value="1" /><property name="timeBetweenEvictionRunsMillis" value="60000" /><property name="minEvictableIdleTimeMillis" value="300000" /><property name="validationQuery" value="SELECT 'x'" /><property name="testWhileIdle" value="true" /><property name="testOnBorrow" value="false" /><property name="testOnReturn" value="false" /><property name="poolPreparedStatements" value="true" /><property name="maxPoolPreparedStatementPerConnectionSize" value="50" /></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="mysqlDataSource" /><property name="typeAliasesPackage" value="com.xe.demo.model" /><property name="configLocation" value="classpath:mybatis/mybatis-config.xml" /><property name="mapperLocations" value="classpath:mybatis/*/*.xml"></property></bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.xe.demo.mapper" /><property name="markerInterface" value="com.xe.demo.mapper.BaseMapper" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /></bean><bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate"><constructor-arg ref="sqlSessionFactory" /></bean><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="mysqlDataSource" /></bean><!-- 启动对@AspectJ注解的支持 --><aop:aspectj-autoproxy proxy-target-class="true" /><!-- 配置事务切面Bean,指定事务管理器 --><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" /><tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" /><tx:method name="save*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" /><tx:method name="batch*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" /></tx:attributes></tx:advice><!-- Service aop --><aop:config><aop:pointcut id="pc" expression="execution(* com.xe.demo.service.*Service.*(..))" /><aop:advisor pointcut-ref="pc" advice-ref="txAdvice" /></aop:config></beans>

spring管理配置文件spring.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:tx="http://www.springframework.org/schema/tx"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:mvc="http://www.springframework.org/schema/mvc"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.2.xsd    http://www.springframework.org/schema/tx    http://www.springframework.org/schema/tx/spring-tx-4.2.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-4.2.xsd    http://www.springframework.org/schema/aop    http://www.springframework.org/schema/aop/spring-aop-4.2.xsd    http://www.springframework.org/schema/cache    http://www.springframework.org/schema/cache/spring-cache-4.2.xsd    http://www.springframework.org/schema/mvc    http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd"><!-- 读取配置文件 --><context:property-placeholder location="classpath*:config.properties" ignore-unresolvable="false" /><import resource="classpath:spring/spring-mybatis.xml"/></beans>

配置spring-mvc.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:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"><mvc:annotation-driven /><context:component-scan base-package="com.xe.demo.controller" /><!-- 对静态资源文件的访问 --><mvc:resources mapping="/assets/**" location="/assets/" /><!-- 配置SpringMVC的视图解析器 --><bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="" /><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="-1" /><property name="maxInMemorySize" value="40960" /></bean></beans>

创建全局配置文件config.properties:

########################### 数据源配置 ####################################本地数据库##########数据源驱动mysql.driver=com.mysql.jdbc.Drivermysql.username=rootmysql.password=xie8845233mysql.url=jdbc:mysql://localhost/demo?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

加载log4j.properties日志文件:

log4j.rootLogger=DEBUG,CONSOLE,ERR_LOGlog4j.addivity.org.apache=false#打印到控制台log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppenderlog4j.appender.CONSOLE.Target=System.outlog4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayoutlog4j.appender.CONSOLE.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} -%-4r [%t] %-5p  %x - %m%n#输入日志到文件log4j.appender.ERR_LOG=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.ERR_LOG.Threshold=ERRORlog4j.appender.ERR_LOG.File=${catalina.home}/logs/demolog4j.appender.ERR_LOG.DatePattern='_'yyyyMMdd'.log'log4j.appender.ERR_LOG.Encoding=utf-8log4j.appender.ERR_LOG.layout=org.apache.log4j.PatternLayoutlog4j.appender.ERR_LOG.layout.ConversionPattern=[m6]  %d{yyyy-MM-dd HH\:mm\:ss} %5p %c{1}\:%L \: %m%nlog4j.logger.org.apache=ERRORlog4j.logger.org.mybatis=ERRORlog4j.logger.org.springframework=ERROR

配置web.xml:

<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd" ><web-app><display-name>demo-bstable</display-name><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring/spring.xml</param-value></context-param><context-param><param-name>log4jConfigLocation</param-name><param-value>classpath:log4j.properties</param-value></context-param><listener><listener-class>org.springframework.web.util.Log4jConfigListener</listener-class></listener><!-- 启动加载spring容器 --><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><servlet><servlet-name>demoServlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring/spring-mvc.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>demoServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping>    <servlet-mapping>        <servlet-name>default</servlet-name>        <url-pattern>*.html</url-pattern>    </servlet-mapping><!-- 编码过滤器 --><filter><filter-name>encodingFilter</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>encodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping></web-app>

创建通用mapper接口BaseMapper.java:

package com.xe.demo.mapper;import java.io.Serializable;import java.util.List;import org.apache.ibatis.annotations.Param;import com.xe.demo.common.pojo.PageAjax;/** * Mybatis基础DAO * @author 蔡泽华 */public interface BaseMapper<T> {/** * 通过ID查询 * @param id * @return */Object selectById(Serializable id);/** * 查询单条记录 * @param entity * @return */Object selectOne(@Param("item")Object obj);/** * 查询记录集合 * @param entity * @return */List<?> selectList(@Param("item")Object obj);/** * 分页查询 * @param t * @param page * @return */List<T> selectPage(@Param("item")Object obj, @Param("page")PageAjax<T> page);/** * 通用的保存方法 * @param <T> * @param entity */void save(@Param("item")Object obj);/** * 批量保存 * @param list */int batchSave(List<?> list);/** * 通用的修改方法 * @param <T> * @param entity */int update(@Param("item")Object obj);/** * 批量更新 * @param list * @return */int batchUpdate(List<?> list);/** * 删除方法 * @param id */int delById(Serializable id);/** * 批量删除 * @param list * @return */int delList(List<?> list);/** * 批量删除方法 * @param ids */int delArray(int[] ids);/** * 统计查询 * @param <T> * @param params 查询参数 * @return 总记录条数 */int count(Object obj);}

创建通用业务层实现BaseService.java:

package com.xe.demo.service;import java.io.Serializable;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import com.xe.demo.common.pojo.PageAjax;import com.xe.demo.mapper.BaseMapper;/** * 通用业务层 * @author 蔡泽华 */public class BaseService<T> {@Autowiredprivate BaseMapper<T> baseMapper;/** * 通过ID查询 * @param id * @return */public Object selectById(Serializable id) {return baseMapper.selectById(id);}/** * 查询单条记录 * @param entity * @return */public Object selectOne(Object obj) {return baseMapper.selectOne(obj);}/** * 查询集合 * @param t * @return */public List<?> selectList(Object obj) {return (List<?>) baseMapper.selectList(obj);}/** * 分页查询 * @param t * @param page * @return */public PageAjax<T> selectPage(Object obj, PageAjax<T> page){List<T> list = baseMapper.selectPage(obj, page);return new PageAjax<T>(list);}/** * 通用的保存方法 * @param <T> * @param entity */public void save(Object obj) {baseMapper.save(obj);}/** * 批量保存 * @param list */public void batchSave(List<?> list) {baseMapper.batchSave(list);}/** * 通用的修改方法 * @param <T> * @param entity */public void update(Object obj) {baseMapper.update(obj);}/** * 删除方法 * @param id */public int delById(Serializable id) {return baseMapper.delById(id);}/** * 批量删除 * @param list * @return */public int delList(List<?> list) {return baseMapper.delList(list);}/** * 批量删除方法 * @param ids */public int delArray(int[] ids) {return baseMapper.delArray(ids);}/** * 统计查询 * @param <T> * @param params 查询参数 * @return 总记录条数 */public int count(T t) {return baseMapper.count(t);}/** * 批量更新 * @param list * @return */public int batchUpdate(List<?> list){return baseMapper.batchUpdate(list);}/*@Autowiredprivate SqlSessionTemplate sqlSessionTemplate;*//** * 批量更新 * @param str * @param obj * @return * @throws Exception *//*public int batchUpdate(String str, List<?> objs) {SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();// 批量执行器SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);int succ = 0;try {if (objs != null) {for (int i = 0, size = objs.size(); i < size; i++) {sqlSession.update(str, objs.get(i));}sqlSession.flushStatements();sqlSession.commit();sqlSession.clearCache();}} finally {sqlSession.close();}return succ;}*/}

创建数据表t_user:

CREATE TABLE `t_user` (  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,  `username` char(20) NOT NULL,  `password` char(32) NOT NULL,  `email` varchar(100) DEFAULT NULL,  `useable` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否可用(0禁用,1可用)',  `addtime` datetime NOT NULL COMMENT '创建时间',  `logintime` datetime DEFAULT NULL COMMENT '登陆时间',  `loginip` varchar(15) DEFAULT NULL COMMENT '登陆IP',  PRIMARY KEY (`id`),  KEY `username` (`username`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

编写增删查改sql映射文件UserMapper.xml:

<?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.xe.demo.mapper.UserMapper"><select id="selectById" resultType="map">SELECT u.id, u.username, u.password, u.email, u.useable, u.addtime, u.logintime, u.loginip FROM t_user u where u.id = #{id}</select><select id="selectOne" resultType="user">SELECT u.id, u.username, u.password, u.email, u.useable, u.addtime, u.logintime, u.loginip FROM t_user u where 1 = 1<if test="null != id"> and u.id = #{id}</if><if test="null != username"> and u.username = #{username}</if><if test="null != email"> and u.email = #{email}</if></select><select id="selectList" resultType="map">SELECT u.id, u.username, u.password, u.email, u.useable, u.addtime, u.logintime, u.loginip FROM t_user u<where><if test="null != username and '' != username"> and u.username like CONCAT('%', #{username}, '%')</if><if test="null != email and '' != email"> and u.email like CONCAT('%', #{email}, '%')</if></where></select><select id="selectPage" resultType="map">SELECT u.id, u.username, u.password, u.email, u.useable, u.addtime, u.logintime, u.loginip FROM t_user u where 1 = 1<if test="null != obj.username and '' != obj.username"> and u.username like CONCAT('%', #{obj.username}, '%')</if><if test="null != obj.email and '' != obj.email"> and u.email = #{obj.email}</if>limit #{page.startRow}, #{page.pageSize}</select><insert id="save">insert into t_user(username, password, email, useable, addtime)values(#{username}, #{password}, #{email}, #{useable}, now())</insert><update id="update">update t_user set password = #{password}, email = #{email}, useable = #{useable} where id = #{id}</update><update id="batchSave">insert into t_user(username, password, email, useable, addtime) values<foreach collection="list" item="item" index="index" separator=",">(#{item.username}, #{item.password}, #{item.email}, #{item.useable}, now())</foreach></update><update id="batchUpdate"><foreach collection="list" item="item" index="index" open="" close="" separator=";">update t_user set password = #{item.password}, email = #{item.email}, useable = #{item.useable} where id = #{item.id}</foreach></update><delete id="delArray">delete from t_user where id in<foreach collection="array" item="item" open="(" separator="," close=")">#{item}</foreach></delete><delete id="delList">delete from t_user where id in<foreach collection="list" item="item" open="(" separator="," close=")">#{item}</foreach></delete></mapper>

创建UserService继承BaseService.java;

创建UserController.java实现功能:

package com.xe.demo.controller;import java.util.ArrayList;import java.util.Arrays;import java.util.HashMap;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import com.xe.demo.common.pojo.AjaxResult;import com.xe.demo.common.pojo.PageAjax;import com.xe.demo.model.User;import com.xe.demo.service.UserService;@Controllerpublic class UserController {@Autowiredprivate UserService userService;@ResponseBody@RequestMapping("/queryById")public AjaxResult queryById(int id){//User user = userService.selectById(id);Object user = userService.selectById(id);return new AjaxResult(user);}@ResponseBody@RequestMapping("/queryOne")public AjaxResult queryOne(User user){Object obj = userService.selectOne(user);return new AjaxResult(obj);}@ResponseBody@RequestMapping("/queryList")public AjaxResult queryList(User user){List<?> list = userService.selectList(user);return new AjaxResult(list);}@ResponseBody@RequestMapping("/queryPage")public PageAjax<User> queryPage(User user, PageAjax<User> page){return userService.selectPage(user, page);}@ResponseBody@RequestMapping("/save")public AjaxResult save(User user){//保存map测试Map<String, Object> map = new HashMap<String, Object>();map.put("username", user.getUsername());map.put("email", user.getEmail());map.put("useable", user.getUseable());map.put("password", user.getPassword());userService.save(map);return new AjaxResult();}@ResponseBody@RequestMapping("/update")public AjaxResult update(User user){//更新map测试//Map<String, Object> map = new HashMap<String, Object>();//map.put("id", user.getId());//map.put("email", user.getEmail());//map.put("useable", user.getUseable());//map.put("password", user.getPassword());userService.update(user);return new AjaxResult();}@ResponseBody@RequestMapping("/batchSave")public AjaxResult batchSave(){//List<User> list = new ArrayList<User>();//User user = null;//for(int i = 0; i < 10; i ++){//user = new User();//String username = "ourte" + i;//user.setUsername(username);//user.setPassword("123456");//user.setUseable(1);//user.setEmail(username + "@163.com");//list.add(user);//}//map批量保存List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();Map<String, Object> map = null;for(int i = 0; i < 10; i ++){map = new HashMap<String, Object>();String username = "csefgg" + i;map.put("username", username);map.put("email", username + "@163.com");map.put("useable", 1);map.put("password", "658264");list.add(map);}userService.batchSave(list);return new AjaxResult();}@ResponseBody@RequestMapping("/batchUpdate")public AjaxResult batchUpdate(){Integer[] ids = new Integer[]{30, 31, 32};//List<User> list = new ArrayList<User>();//User user = null;//for(int id: ids){//user = new User();//user.setId(id);//user.setPassword("654321");//user.setUseable(0);//user.setEmail("[e-mail]");//list.add(user);//}//map批量更新List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();Map<String, Object> map = null;for(int id: ids){map = new HashMap<String, Object>();map.put("id", id);map.put("email", "[e-mail]");map.put("useable", 1);map.put("password", "565656");list.add(map);}userService.batchUpdate(list);return new AjaxResult();}@ResponseBody@RequestMapping("/delList")public AjaxResult delList(Integer[] ids){List<Integer> list = Arrays.asList(ids);userService.delList(list);return new AjaxResult();}@ResponseBody@RequestMapping("/delArray")public AjaxResult delArray(int[] ids){userService.delArray(ids);return new AjaxResult();}}

部署启动项目,使用http请求模拟器请求接口测试:

1.通过ID查询:

2.通过条件查询返回实体集合

3.通过条件查询返回Map集合

4.多条件分页查询实体

5.多条件分页查询map

6.批量保存数据

7.批量更新数据

8.评论删除(mybatis接收List<Integer>参数)

9.批量删除(mybatis接收int[]参数)

10.添加数据

11.更新数据

项目源码下载地址:整合maven+spring+springmvc+mybatis实现ssm通用增删查改API(没BUG版本)