spring-boot 入门 ssmb小例子

最新推荐文章于 2022-12-07 13:20:38 发布

weixin_39280200

最新推荐文章于 2022-12-07 13:20:38 发布

阅读量245

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/weixin_39280200/article/details/73617570

本文详细介绍了一个使用Spring Boot、MyBatis和Spring MVC(SSM)框架整合的实战项目。项目中利用Spring Boot进行快速开发，并结合MyBatis实现数据持久化层的操作，同时通过Spring MVC完成前后端交互。文章覆盖了pom.xml依赖配置、数据源配置、Mapper层CURD操作、Service层业务逻辑处理、Controller层请求响应处理等核心内容。

pom.xml 依赖包

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.4.RELEASE</version>
   </parent>
   <dependencies>
        <!-- 表示可以发布web程序 自动启动一个tomcat -->
	    <dependency>
	        <groupId>org.springframework.boot</groupId>
	        <artifactId>spring-boot-starter-web</artifactId>
	    </dependency>
	    
		<!-- mybatis集成 -->
		<dependency>
		  <groupId>org.mybatis.spring.boot</groupId>
		  <artifactId>mybatis-spring-boot-starter</artifactId>
		  <version>1.2.1</version>
		</dependency>
		
		
		
		<!-- 操作数据源 -->
		<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		
		<!-- 添加转译jsp的jar -->
	    <dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-tomcat</artifactId>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.apache.tomcat.embed</groupId>
			<artifactId>tomcat-embed-jasper</artifactId>
			<scope>provided</scope>
		</dependency>
		
		<!-- 自动监听配置文件和jsp(开发者模式)  -->
		<dependency>
	        <groupId>org.springframework.boot</groupId>
	        <artifactId>spring-boot-devtools</artifactId>
	        <optional>true</optional>
	    </dependency>

		<dependency>
		    <groupId>oracle</groupId>
		    <artifactId>oracle</artifactId>
		    <version>3.2.8</version>
			<scope>system</scope>
		    <systemPath>C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar</systemPath>
		</dependency>

application.properties 配置数据源四要素

spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.datasource.username=scott
spring.datasource.password=tiger
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

mapper 层对数据库的curd

package cn.et.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import cn.et.entity.Emp;
//实例化这个类
@Mapper
public interface EmpMapper {
   
    @Delete({
        "delete from SCOTT.EMP",
        "where EMPNO = #{empno}"
    })
    public  int deleteByPrimaryKey(Short empno);

    
    @Insert({
    	"insert into emp(empno,sal,ename,job) values((select max(empno)+1 from emp),#{sal},#{ename},#{job})"
    })
    public int insert(Emp record);

   
   
    @Select({
        "select EMPNO, ENAME, JOB, SAL from (select t.*,rownum as ro from SCOTT.EMP t where ENAME LIKE #{0}) where ro BETWEEN #{1} AND #{2} "
    })
    public List<Emp> selectByPrimaryKey(String name,int startIndex,int endIndex);
    
    @Select({
        "select count(rowid) from SCOTT.EMP where ENAME LIKE #{name}"
    })
    public int getCount(String name);
  
    @Update({
    	
        "update SCOTT.EMP set ENAME = #{ename},JOB = #{job},SAL = #{sal} where EMPNO = #{empno}"
    })
    public int updateByPrimaryKey(Emp record);
}

service层

package cn.et.service.imp;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import cn.et.entity.Emp;
import cn.et.entity.PageEntity;
import cn.et.mapper.EmpMapper;
import cn.et.service.EmpService;
import cn.et.utils.PageUtils;
//调用事物
@Transactional
//实例化类
@Service
public class EmpServiceImp implements EmpService {
	@Autowired
	private EmpMapper em;
	//此方法不启用事物
	@Transactional(readOnly=true)
	public PageEntity query(Emp ui, int curPage) {
		int count = em.getCount("%"+ui.getEname()+"%");
		PageEntity pe = PageUtils.getPageEntity(count, 5, curPage);
		List<Emp> list = em.selectByPrimaryKey("%"+ui.getEname()+"%",pe.getstartIndex() , pe.getEndIndex());
		pe.setData(list);
		return pe;
	}

	public void add(Emp ui) {
		em.insert(ui);
		
	}

	public void delete(Emp ui) {
		em.deleteByPrimaryKey(ui.getEmpno());
		
	}

	public void update(Emp ui) {
		em.updateByPrimaryKey(ui);
		
	}
	
}

control 层

package cn.et.control;

import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.util.List;

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 org.springframework.web.bind.annotation.RestController;

import cn.et.entity.Emp;
import cn.et.entity.PageEntity;
import cn.et.service.EmpService;
//实例化这个类
@RestController
public class EmpAction {
	@Autowired
	private EmpService es;
	
	@RequestMapping("queryEmp")
	public PageEntity query(String ename,int curPage){
		Emp ui=new Emp();
		ui.setEname(ename);
		PageEntity pe = es.query(ui, curPage);

		return pe;
	}
	
	@RequestMapping("addEmp")
	public void add(Emp ui,OutputStream os) throws UnsupportedEncodingException, IOException{
		try {
			es.add(ui);
			os.write("1".getBytes("utf-8"));
		} catch (Exception e) {
			os.write("0".getBytes("utf-8"));
			e.printStackTrace();
		}
	}
	
	@RequestMapping("updateEmp")
	public void update(Emp ui,OutputStream os) throws UnsupportedEncodingException, IOException{
		try {
			es.update(ui);
			os.write("1".getBytes("utf-8"));
		} catch (Exception e) {
			os.write("0".getBytes("utf-8"));
			e.printStackTrace();
		}
	}
	
	@RequestMapping("deleteEmp")
	public void delete(Emp ui,OutputStream os) throws UnsupportedEncodingException, IOException{
		try {
			es.delete(ui);
			os.write("1".getBytes("utf-8"));
		} catch (Exception e) {
			os.write("0".getBytes("utf-8"));
			e.printStackTrace();
		}
	}
	
}

Utils包 service层的调用类

package cn.et.utils;

import cn.et.entity.PageEntity;
/*//开始位置
private int startIndex;
//结束位置
private int endIndex;
//总条数
private int count;
//当前页数
private	int curPage;
//下一页
private int nextPage;
//上一页
private int prePage;
//总页数
private int pageCount;
* 
 * 16 5
 * 1,2,3,4,5   1  5  开始位置=(页数-1)*每页行数+1;
 * 6,7,8,9,10   2	结束=页数*行数
 * 11,12,13,14,15  
 * 16,  4
*
*/
public class PageUtils {
	//通过数据的总条数,每页的数据条数,当前第几页;计算所需要的数据
	public static PageEntity getPageEntity(int count,int curCount,int curPage){
		PageEntity pe=new PageEntity();
		pe.setCount(count);
		pe.setCurPage(curPage);
		//计算总页数
		int pageCount=count%curCount==0? count/curCount:count/curCount+1;
		pe.setPageCount(pageCount);
		//计算上一页
		int prePage=curPage==1? curPage:curPage-1;
		pe.setPrePage(prePage);
		//计算下一页
		int nextPage=curPage==pageCount? curPage:curPage+1;
		pe.setNextPage(nextPage);
		//计算每页开始位置
		int startIndex=(curPage-1)*curCount+1;
		pe.setstartIndex(startIndex);
		//计算每页结束位置
		int endIndex=curPage==pageCount? count:curCount*curPage;
		pe.setEndIndex(endIndex);
		return pe;
	}

}

entity层 Emp实体类

package cn.et.entity;

import java.math.BigDecimal;
import java.util.Date;

public class Emp {
    
    private Short empno;

    
    private String ename;

    
    private String job;

   
    private BigDecimal sal;

    public Short getEmpno() {
        return empno;
    }

    
    public void setEmpno(Short empno) {
        this.empno = empno;
    }

    
    public String getEname() {
        return ename;
    }

   
    public void setEname(String ename) {
        this.ename = ename;
    }

    
    public String getJob() {
        return job;
    }

    
    public void setJob(String job) {
        this.job = job;
    }
    
    public BigDecimal getSal() {
        return sal;
    }

    
    public void setSal(BigDecimal sal) {
        this.sal = sal;
    }

    


	@Override
	public String toString() {
		return "Emp [empno=" + empno + ", ename=" + ename + ", job=" + job
				+ ", sal=" + sal+  "]";
	}
    
}

entity层工具实体类

package cn.et.entity;

import java.util.List;

public class PageEntity {
	//开始位置
	private int startIndex;
	//结束位置
	private int endIndex;
	//总条数
	private int count;
	//当前页数
	private	int curPage;
	//下一页
	private int nextPage;
	//上一页
	private int prePage;
	//总页数
	private int pageCount;
	/**
	 * 用来保存当前页的数据
	 * */
	private List data;
	public int getstartIndex() {
		return startIndex;
	}
	public void setstartIndex(int startIndex) {
		this.startIndex = startIndex;
	}
	public int getEndIndex() {
		return endIndex;
	}
	public void setEndIndex(int endIndex) {
		this.endIndex = endIndex;
	}
	public int getCount() {
		return count;
	}
	public void setCount(int count) {
		this.count = count;
	}
	public int getCurPage() {
		return curPage;
	}
	public void setCurPage(int curPage) {
		this.curPage = curPage;
	}
	public int getNextPage() {
		return nextPage;
	}
	public void setNextPage(int nextPage) {
		this.nextPage = nextPage;
	}
	public int getPrePage() {
		return prePage;
	}
	public void setPrePage(int prePage) {
		this.prePage = prePage;
	}
	public List getData() {
		return data;
	}
	public void setData(List data) {
		this.data = data;
	}
	public int getPageCount() {
		return pageCount;
	}
	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}
}

mian方法程序启动入口

package cn.et;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.transaction.annotation.EnableTransactionManagement;
//让service类中的事物生效,启动全局事物
@EnableTransactionManagement
//加载全局配置
@SpringBootApplication
public class StartSSMB {

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

}