springboot整合mybatis小练习 对员工表的增删改查【连表分页】

对员工表的增删改查【连表分页】
测试接口

项目结构

导入依赖

 
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.0
        

        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            com.alibaba
            druid-spring-boot-starter
            1.2.1
        
        
            com.github.pagehelper
            pagehelper-spring-boot-starter
            1.2.13
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

application.yml

#配置端口号
server:
  port: 8080
#  配置druid的信息
spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/emp?serverTimezone=Asia/Shanghai
      username: root
      password: root
      max-active: 20
      initial-size: 5
      min-idle: 5
      max-wait: 3000
  main:
    allow-circular-references: true
# 配置mybatis映射文件所在的路径
mybatis:
  mapper-locations: classpath:mapper/*.xml
# mybatis输入sql语句
logging:
  level:
    com.ccr.dao: debug
#pageHelper
pagehelper:
  reasonable: true #分页合理化

EmpMapper.xml

    
        
        
        
        
        
        
            
            
        
    
    
    
     SELECT e.empId, e.empName,e.gender,e.email,e.d_Id  from  tbl_emp e
        INNER JOIN tbl_dept t
        on t.deptId=e.d_Id
     where e.empId=#{empId}
    

    
        SELECT e.empId, e.empName,e.gender,e.email,e.d_Id  from  tbl_emp e
         INNER JOIN tbl_dept t
         on t.deptId=e.d_Id

    

    
        insert into tbl_emp(empName,gender,email,d_Id) values (#{empName},#{gender},#{email},#{dId})
    

    
        update tbl_emp set empName=#{empName},gender=#{gender},email=#{email},d_Id=#{dId} where empId=#{empId}


    
        delete from tbl_emp where empId=#{empId}
    


 
Emp表
 
package com.ccr.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.stereotype.Component;

@Data
@NoArgsConstructor
@AllArgsConstructor
//配置文件前和赋值个的属性名相同
public class Emp {
    private Integer empId;
    private String empName;
    private char gender;
    private String email;
    private Integer dId;
    private Dept dept;
}

 
Dept表
 
package com.ccr.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Dept {
    private Integer deptId;
    private String deptName;
}

 
Util中的CommonResult
 
package com.ccr.util;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class CommonResult {
    private Integer code;
    private String msg;
    private Object data;
}

 
service
 
package com.ccr.service;

import com.ccr.entity.Emp;
import com.ccr.util.CommonResult;

public interface EmpService {
//    根据id查询信息
    public CommonResult selectById(Integer empId );
//    查询所有分页
    public CommonResult selectByPage(Integer page,Integer limit);
//    添加信息
    public CommonResult addEmp(Emp emp);
//    修改
    public CommonResult upEmp(Emp emp);
//    删除
    public CommonResult delEmp(Integer empId);

}

 
service下的impl的EmpServiceimpl
 
package com.ccr.service.impl;

import com.ccr.dao.EmpDao;
import com.ccr.entity.Emp;
import com.ccr.service.EmpService;
import com.ccr.util.CommonResult;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service(value = "EmpService")
public class EmpServiceimpl implements EmpService {
    @Resource
    public EmpDao empDao;
    @Override
    public CommonResult selectById(Integer empId) {
        Emp eId = empDao.findById(empId);
        return new CommonResult(200,"查询成功",eId);
    }

    @Override
    public CommonResult selectByPage(Integer page, Integer limit) {
        PageHelper.startPage(page,limit);
        List all = empDao.findAll();
        PageInfo empPageInfo = new PageInfo<>(all);
        return new CommonResult(200,"查询成功",empPageInfo);
    }

    @Override
    public CommonResult addEmp(Emp emp) {
        int add = empDao.addEmp(emp);
        return new CommonResult(200,"添加成功",add);
    }

    @Override
    public CommonResult upEmp(Emp emp) {
        int up = empDao.upEmp(emp);
        return new CommonResult(200,"修改成功",up);
    }

    @Override
    public CommonResult delEmp(Integer empId) {
        int delEmp = empDao.delEmp(empId);
        return new CommonResult(200,"删除成功",delEmp);
    }
}

 
dao中的EmpDao
 
package com.ccr.dao;

import com.ccr.entity.Emp;

import java.util.List;

public interface EmpDao {
//    根据id查询
    public Emp findById(int empId);
//    查询所有
    public List  findAll();
//    添加
    public int addEmp(Emp emp);
//    修改
    public  int upEmp(Emp emp);
//    删除
    public int delEmp(Integer empId);

}

 
controller中的EmpController
 
package com.ccr.controller;

import com.ccr.entity.Emp;
import com.ccr.service.EmpService;
import com.ccr.util.CommonResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping("emp")
public class EmpController {
    @Autowired
    private EmpService empService;
//    根据id查询信息
    @GetMapping("/getById")
    public CommonResult getById(Integer empId){
        return empService.selectById(empId);
    }
//    查询所有信息分页
    @GetMapping("/getAll")
    public CommonResult getAll(Integer page,Integer limit){
        return empService.selectByPage(page,limit);
    }
//    添加
    @PostMapping("/addEmp")
    public CommonResult addEmp(Emp emp){
        return empService.addEmp(emp);
    }
//    修改
    @PutMapping("upEmp")
    public CommonResult upEmp(Emp emp){
        return empService.upEmp(emp);
    }
//    删除
    @DeleteMapping("delEmp")
    public CommonResult delEmp(Integer empId){
        return empService.delEmp(empId);
    }


}

 
启动的测试类
 
package com.ccr;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
//为指定包下的接口生产代理实现类
@MapperScan(basePackages = "com.ccr.dao")
public class SpringbootMybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootMybatisApplication.class, args);
    }

}

 
测试结果
 根据id查询的员工信息
 
 
查询所有分页
 
 添加员工信息
 
 修改员工信息
 
 
删除员工信息
 
 注解总结：
 
	//为指定包下的接口生产代理实现类
	@MapperScan(basePackages = "com.ykq.dao")
	//    删除
    @DeleteMapping("delEmp")
    //    修改
    @PutMapping("upEmp")
    //    添加
    @PostMapping("/addEmp")
    //    查询所有信息分页
    @GetMapping("/getAll")
					
										


					

						
欢迎分享，转载请注明来源：内存溢出
原文地址: http://outofmemory.cn/zaji/5681727.html
					
				
								

										查询
										信息
										删除
										添加
										修改
									
								

					
						
							
						 赞
						(0)
					
					

						
							 打赏
						
							
								 微信扫一扫
							
							
								 支付宝扫一扫
							
						
					
				
				

					

						

							
								
								机器人插件
								一级用户组
							
						
						

							

								
									
										
									
									0
								
								
									
										
									
									0
								
							
							

								
									
										
									
									生成海报
								
								
									
										
									
								
								
									
										
									
								
								
									
										
									
								
								
									
										
									
								
							
							

								
									
										
									
								
							
						
					
				
			
			
            

            	            
            
			

								

					
						Elasticsearch(一)
					
					

         				
							
								
							 上一篇
						
						2022-12-17
					
				
												

					
						05 Spark on 读取内部数据分区存储策略(源码角度分析)
					
					

         				
							下一篇 
           						
							
						
						2022-12-17
					
				
							

			
			

				

					

						发表评论
					
										

						

							请登录后评论...
						
						

							

								登录后才能评论
							
							提交
						
					
									
								
 评论列表（0条）
				

									
				
											
		

	

	





	

























    

    

    

        
            保存