整合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>
- <?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.xsd
- http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
- http://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.Driver
- mysql.username=root
- mysql.password=xie8845233
- mysql.url=jdbc:mysql://localhost/demo?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
加载log4j.properties日志文件:
- log4j.rootLogger=DEBUG,CONSOLE,ERR_LOG
- log4j.addivity.org.apache=false
- #打印到控制台
- log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
- log4j.appender.CONSOLE.Target=System.out
- log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
- log4j.appender.CONSOLE.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} -%-4r [%t] %-5p %x - %m%n
- #输入日志到文件
- log4j.appender.ERR_LOG=org.apache.log4j.DailyRollingFileAppender
- log4j.appender.ERR_LOG.Threshold=ERROR
- log4j.appender.ERR_LOG.File=${catalina.home}/logs/demo
- log4j.appender.ERR_LOG.DatePattern='_'yyyyMMdd'.log'
- log4j.appender.ERR_LOG.Encoding=utf-8
- log4j.appender.ERR_LOG.layout=org.apache.log4j.PatternLayout
- log4j.appender.ERR_LOG.layout.ConversionPattern=[m6] %d{yyyy-MM-dd HH\:mm\:ss} %5p %c{1}\:%L \: %m%n
- log4j.logger.org.apache=ERROR
- log4j.logger.org.mybatis=ERROR
- log4j.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> {
- @Autowired
- private 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);
- }
- /*@Autowired
- private 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>
创建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;
- @Controller
- public class UserController {
- @Autowired
- private 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("csew@163.com");
- // 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", "dfdwfg@163.com");
- 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版本)