襄阳微网站建设,网络公司网站建,小说网站开发对影成三人小说,自己如何做网站优化文章目录 一、数据库表二、引入依赖三、修改配置文件四、公共组件1、BaseController2、BaseService3、IService4、BaseMapper 五、代码1、Application2、Student实体类3、Controller4、Service5、ServiceImpl6、Mapper7、Mapper.xml 一、数据库表
CREATE TABLE student (id i… 文章目录 一、数据库表二、引入依赖三、修改配置文件四、公共组件1、BaseController2、BaseService3、IService4、BaseMapper 五、代码1、Application2、Student实体类3、Controller4、Service5、ServiceImpl6、Mapper7、Mapper.xml 一、数据库表
CREATE TABLE student (id int(11) NOT NULL AUTO_INCREMENT COMMENT ID,name varchar(63) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 名称,age int(3) NOT NULL COMMENT 年龄,PRIMARY KEY (id) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 2 CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT Dynamic;二、引入依赖 dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactIdversion2.1.1.RELEASE/version/dependency!-- tk.myabtis --dependencygroupIdtk.mybatis/groupIdartifactIdmapper-spring-boot-starter/artifactIdversion2.1.5/version/dependency!-- 分页插件 --dependencygroupIdcom.github.pagehelper/groupIdartifactIdpagehelper-spring-boot-starter/artifactIdversion1.2.5/version/dependency!-- mysql --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.17/version/dependency三、修改配置文件 application.yml server:# 服务端口port: 8051servlet:# 项目contextPathcontext-path: /testtomcat:# tomcat的URI编码uri-encoding: UTF-8# tomcat最大线程数默认为200max-threads: 800# Tomcat启动初始化的线程数默认值25min-spare-threads: 30# Spring配置
spring:# 环境 dev|pre|prodprofiles:active: devjackson:time-zone: GMT8date-format: yyyy-MM-dd HH:mm:ss# MyBatis
mybatis:# 搜索指定包别名type-aliases-package: org.example.domainmapper-locations: classpath*:mapper/*Mapper.xml#配置驼峰下划线configuration:map-underscore-to-camel-case: true# PageHelper分页插件
pagehelper:helperDialect: mysqlreasonable: truesupportMethodsArguments: trueparams: countcountSqlapplication-dev.yml spring:# 数据源配置datasource:driver-class-name: com.mysql.cj.jdbc.Driverfilters: wall,mergeStaturl: jdbc:mysql://127.0.0.1:3306/netty?autoReconnecttrueuseUnicodetruecharacterEncodingutf8zeroDateTimeBehaviorconvertToNullserverTimezoneCTTuseSSLfalseusername: rootpassword: 123456四、公共组件
1、BaseController
package org.example.base;import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.function.Supplier;/*** Controller公共组件*/
public abstract class BaseController {/*** 封装分页返回信息** param pageInfo* return*/private MapString, Object getDataTable(PageInfo? pageInfo) {MapString, Object rspData new HashMap();rspData.put(list, pageInfo.getList());rspData.put(total, pageInfo.getTotal());rspData.put(pageNumber, pageInfo.getPageNum());rspData.put(pageSize, pageInfo.getPageSize());return rspData;}/*** 分页查询** param request* param s* return*/protected MapString, Object findPages(QueryRequest request, Supplier? s) {PageHelper.startPage(request.getPageNum(), request.getPageSize());PageInfo? pageInfo new PageInfo((List?) s.get());PageHelper.clearPage();return getDataTable(pageInfo);}}
2、BaseService
package org.example.base;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.entity.Example;import java.util.List;public abstract class BaseServiceT implements IServiceT {Autowiredprotected MapperT mapper;public MapperT getMapper() {return mapper;}Overridepublic ListT selectAll() {return mapper.selectAll();}Overridepublic T selectByKey(Object key) {return mapper.selectByPrimaryKey(key);}OverrideTransactional(rollbackFor Exception.class)public int insert(T entity) {return mapper.insert(entity);}OverrideTransactional(rollbackFor Exception.class)public int insertSelective(T entity) {return mapper.insertSelective(entity);}OverrideTransactional(rollbackFor Exception.class)public int delete(Object key) {return mapper.deleteByPrimaryKey(key);}OverrideTransactional(rollbackFor Exception.class)public int batchDelete(ListString list, String property, ClassT clazz) {Example example new Example(clazz);example.createCriteria().andIn(property, list);return this.mapper.deleteByExample(example);}OverrideTransactional(rollbackFor Exception.class)public int updateAll(T entity) {return mapper.updateByPrimaryKey(entity);}OverrideTransactional(rollbackFor Exception.class)public int updateNotNull(T entity) {return mapper.updateByPrimaryKeySelective(entity);}Overridepublic ListT selectByExample(Object example) {return mapper.selectByExample(example);}}
3、IService
package org.example.base;import org.springframework.stereotype.Service;import java.util.List;Service
public interface IServiceT {ListT selectAll();T selectByKey(Object key);int insert(T entity);int insertSelective(T entity);int delete(Object key);int batchDelete(ListString list, String property, ClassT clazz);int updateAll(T entity);int updateNotNull(T entity);ListT selectByExample(Object example);}4、BaseMapper
package org.example.base;import tk.mybatis.mapper.common.Mapper;/*** mybatis通用Mapper* 特别注意该接口不能被扫描到否则会出错*/
public interface BaseMapperT extends MapperT {}五、代码
1、Application
package org.example;import org.example.server.IMServer;
import tk.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplication()
MapperScan(org.example.mapper)
public class Application {public static void main( String[] args ) {SpringApplication.run(Application.class, args);}
}2、Student实体类
package org.example.domain;import lombok.Data;import javax.persistence.*;
import java.io.Serializable;Data
Table(name student)
public class Student implements Serializable {/*** id*/IdGeneratedValue(strategy GenerationType.IDENTITY)Column(name id)private Integer id;/*** 预约id*/Column(name name)private String name;/*** 预约id*/Column(name age)private Integer age;
}
3、Controller
package org.example.controller;import org.example.base.BaseController;
import org.example.domain.Student;
import org.example.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;RestController
RequestMapping(/Student)
public class StudentController extends BaseController {Autowiredprivate StudentService studentService;PostMapping(/insert)public void insert () {Student student new Student();student.setAge(20);student.setName(李子木);studentService.insert(student);}
}
4、Service
package org.example.service;import org.example.base.IService;
import org.example.domain.Student;public interface StudentService extends IServiceStudent {
}
5、ServiceImpl
package org.example.service.impl;import org.example.base.BaseService;
import org.example.domain.Student;
import org.example.service.StudentService;
import org.springframework.stereotype.Service;Service(StudentService)
public class StudentServiceImpl extends BaseServiceStudent implements StudentService {
}
6、Mapper
package org.example.mapper;import org.example.base.BaseMapper;
import org.example.domain.Student;
import org.springframework.stereotype.Repository;Repository
public interface StudentMapper extends BaseMapperStudent {
}
7、Mapper.xml
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtdmapper namespaceorg.example.mapper.StudentMapper/mapper
文章转载自： http://www.morning.wctqc.cn.gov.cn.wctqc.cn http://www.morning.wwsgl.com.gov.cn.wwsgl.com http://www.morning.phcqk.cn.gov.cn.phcqk.cn http://www.morning.hlrtzcj.cn.gov.cn.hlrtzcj.cn http://www.morning.tkztx.cn.gov.cn.tkztx.cn http://www.morning.npbkx.cn.gov.cn.npbkx.cn http://www.morning.nfgbf.cn.gov.cn.nfgbf.cn http://www.morning.rkfh.cn.gov.cn.rkfh.cn http://www.morning.rnngz.cn.gov.cn.rnngz.cn http://www.morning.jwwfk.cn.gov.cn.jwwfk.cn http://www.morning.ydryk.cn.gov.cn.ydryk.cn http://www.morning.bndkf.cn.gov.cn.bndkf.cn http://www.morning.ltksw.cn.gov.cn.ltksw.cn http://www.morning.wljzr.cn.gov.cn.wljzr.cn http://www.morning.zylzk.cn.gov.cn.zylzk.cn http://www.morning.skrh.cn.gov.cn.skrh.cn http://www.morning.zrrgx.cn.gov.cn.zrrgx.cn http://www.morning.qhfdl.cn.gov.cn.qhfdl.cn http://www.morning.nzlsm.cn.gov.cn.nzlsm.cn http://www.morning.qqklk.cn.gov.cn.qqklk.cn http://www.morning.rbtny.cn.gov.cn.rbtny.cn http://www.morning.zlnf.cn.gov.cn.zlnf.cn http://www.morning.cryb.cn.gov.cn.cryb.cn http://www.morning.mzqhb.cn.gov.cn.mzqhb.cn http://www.morning.bmmhs.cn.gov.cn.bmmhs.cn http://www.morning.nffwl.cn.gov.cn.nffwl.cn http://www.morning.zmwzg.cn.gov.cn.zmwzg.cn http://www.morning.ybgpk.cn.gov.cn.ybgpk.cn http://www.morning.zlqyj.cn.gov.cn.zlqyj.cn http://www.morning.pfggj.cn.gov.cn.pfggj.cn http://www.morning.gwtbn.cn.gov.cn.gwtbn.cn http://www.morning.ctfh.cn.gov.cn.ctfh.cn http://www.morning.ypbp.cn.gov.cn.ypbp.cn http://www.morning.lmbm.cn.gov.cn.lmbm.cn http://www.morning.duqianw.com.gov.cn.duqianw.com http://www.morning.ldgqh.cn.gov.cn.ldgqh.cn http://www.morning.kqgqy.cn.gov.cn.kqgqy.cn http://www.morning.sjpbh.cn.gov.cn.sjpbh.cn http://www.morning.srckl.cn.gov.cn.srckl.cn http://www.morning.nxbsq.cn.gov.cn.nxbsq.cn http://www.morning.rttkl.cn.gov.cn.rttkl.cn http://www.morning.qyqmj.cn.gov.cn.qyqmj.cn http://www.morning.ypfw.cn.gov.cn.ypfw.cn http://www.morning.mtrrf.cn.gov.cn.mtrrf.cn http://www.morning.mmplj.cn.gov.cn.mmplj.cn http://www.morning.pxlql.cn.gov.cn.pxlql.cn http://www.morning.tgtwy.cn.gov.cn.tgtwy.cn http://www.morning.ghccq.cn.gov.cn.ghccq.cn http://www.morning.lwmxk.cn.gov.cn.lwmxk.cn http://www.morning.wngpq.cn.gov.cn.wngpq.cn http://www.morning.mspqw.cn.gov.cn.mspqw.cn http://www.morning.knpbr.cn.gov.cn.knpbr.cn http://www.morning.ykxnp.cn.gov.cn.ykxnp.cn http://www.morning.mwlxk.cn.gov.cn.mwlxk.cn http://www.morning.qfwfj.cn.gov.cn.qfwfj.cn http://www.morning.kghhl.cn.gov.cn.kghhl.cn http://www.morning.knmp.cn.gov.cn.knmp.cn http://www.morning.wrlcy.cn.gov.cn.wrlcy.cn http://www.morning.wdshp.cn.gov.cn.wdshp.cn http://www.morning.rnngz.cn.gov.cn.rnngz.cn http://www.morning.mbpzw.cn.gov.cn.mbpzw.cn http://www.morning.rnhh.cn.gov.cn.rnhh.cn http://www.morning.kpwdt.cn.gov.cn.kpwdt.cn http://www.morning.wfyqn.cn.gov.cn.wfyqn.cn http://www.morning.bqdpy.cn.gov.cn.bqdpy.cn http://www.morning.jrqw.cn.gov.cn.jrqw.cn http://www.morning.jfsbs.cn.gov.cn.jfsbs.cn http://www.morning.yzxhk.cn.gov.cn.yzxhk.cn http://www.morning.gwdkg.cn.gov.cn.gwdkg.cn http://www.morning.zydr.cn.gov.cn.zydr.cn http://www.morning.qkqgj.cn.gov.cn.qkqgj.cn http://www.morning.zsyqg.cn.gov.cn.zsyqg.cn http://www.morning.gwwtm.cn.gov.cn.gwwtm.cn http://www.morning.pdkht.cn.gov.cn.pdkht.cn http://www.morning.klzt.cn.gov.cn.klzt.cn http://www.morning.gqjzp.cn.gov.cn.gqjzp.cn http://www.morning.tlpgp.cn.gov.cn.tlpgp.cn http://www.morning.gbqgr.cn.gov.cn.gbqgr.cn http://www.morning.bppml.cn.gov.cn.bppml.cn http://www.morning.qqhersx.com.gov.cn.qqhersx.com
