本文共 4519 字，大约阅读时间需要 15 分钟。

   
   	
    
     4.0.0
    	
    		
     
      org.springframework.boot
     		
     
      spring-boot-starter-parent
     		
     
      2.1.5.RELEASE
     		
      
     	
    	
    
     com.suke
    	
    
     springboot_1-0
    	
    
     0.0.1-SNAPSHOT
    	
    
     springboot_1-0
    	
    
     Demo project for Spring Boot
    	
    		
     
      UTF-8
     	
     
      UTF-8
     		
     
      1.8
     	
    	
    		
     			
      
       org.springframework.boot
      			
      
       spring-boot-starter-web
      		
     		
     			
      
       org.springframework.boot
      			
      
       spring-boot-starter
      		
     		
     			
      
       org.springframework.boot
      			
      
       spring-boot-starter-test
      			
      
       test
      		
     		
     			
      
       org.springframework.boot
      			
      
       spring-boot-configuration-processor
      			
      
       true
      		
     		
     			
      
       mysql
      			
      
       mysql-connector-java
      			
      
       5.1.43
      		
     		
           
     		
     			
      
       com.alibaba
      			
      
       druid
      			
      
       1.1.3
      		
     		
     			
      
       org.projectlombok
      			
      
       lombok
      		
     		
     		
     			
      
       org.mybatis.spring.boot
      			
      
       mybatis-spring-boot-starter
      			
      
       1.2.0
      		
     	
    	
    		
     			
      				
       
        org.springframework.boot
       				
       
        spring-boot-maven-plugin
       			
      		
     	
    
   

步骤2.创建启动类App.java

package com.example.controller;import org.mybatis.spring.annotation.MapperScan;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.builder.SpringApplicationBuilder;import org.springframework.boot.web.support.SpringBootServletInitializer;import org.springframework.context.annotation.ComponentScan;@SpringBootApplication @ComponentScan(basePackages="org.suke")//扫描注解@MapperScan(basePackages="org.suke.mapper") //扫描Mapper接口,自动生成Mapper的代理对象public class App extends SpringBootServletInitializer {
   	public static void main(String[] args) {
   		SpringApplication.run(App.class, args);	}		 @Override	 protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {
   	      return application.sources(App.class);	 }}

步骤3.在application.properties添加配置文件

####################################DataSource################################spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql://localhost:3306/house?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghaispring.datasource.username=rootspring.datasource.password=rootdruid.maxSize=100druid.minSize=5druid.initSize=5#spring.datasource.type=com.alibaba.druid.pool.DruidDataSource#日志文件logging.config=classpath:logConfig.xml#激活那个环境spring.profiles.active=dev#Mybatis配置mybatis.type-aliases-package=com.zl.app.entitymybatis.mapper-locations=classpath*:mapper/*Mapper.xml

步骤4.编写实体类

@Datapublic class Employee {
   	private Integer empno;	private String ename;	private String job;	private Integer mgr;	private Date hiredate;	private Double sal;	private Double comm;}

步骤5.编写Mapper接口

@Mapperpublic interface EmployeeMapper {
   	public List
   
     selectByPage(@Param("startNo")int startNo, @Param("pageSize")int pageSize) throws Exception;	public void add(Employee emp) throws Exception;}
   

步骤6.编写Service

public interface IEmployeeService {
   	public List
   
      queryByPage(int pageIndex,int pageSize) throws Exception;	public void addEmp(Employee emp) throws Exception;}@Service("empService")public class EmployeeServiceImpl implements IEmployeeService {
   	@Autowired	private EmployeeMapper empDap;		@Override	public List
    
      queryByPage(int pageIndex, int pageSize) throws Exception {
   		return empDap.selectByPage((pageIndex-1)*pageSize, pageSize);	}	@Transactional	@Override	public void addEmp(Employee emp) throws Exception {
   		empDap.add(emp);	}}
    
   

编写Mapper映射文件

    
    	
     		select * from  emp limit #{
   startNo},#{
   pageSize} 	 	 	
    
      		INSERT  INTO `emp`(`empno`,`ename`,`job`,`mgr`,`hiredate`,`sal`,`comm`)  		   VALUE(#{
   empno,jdbcType=INTEGER},#{
   ename,jdbcType=VARCHAR},#{
   job,jdbcType=VARCHAR} 		   ,#{
   mgr,jdbcType=INTEGER},#{
   hiredate,jdbcType=DATE},#{
   sal,jdbcType=DECIMAL},#{
   comm,jdbcType=DECIMAL} 		   ) 	
     
   

测试结果

转载地址：http://nyhrb.baihongyu.com/