Springboot+mybatis+mysql项目工程搭建

旧城等待， 2021-10-19 06:14 467阅读 0赞

Springboot在Spring和Springmvc基础上极大简化了配置，使开发者把主要精力放在业务实现上。下面介绍工程搭建和业务实现：

**一、工程目录介绍：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p3MV9jc2Ru_size_16_color_FFFFFF_t_70][]

**二、分层介绍**

**1、数据访问：PlanDao.java**

public interface PlanDao \{  
    public List<FusePlanEntity> selectPlan();//获取测试计划

**2、业务实体：FusePlanEntity.java**

public class FusePlanEntity implements Serializable\{  
      
    private static final long serialVersionUID = 1L;  
    public int id;  
    public String planName;//计划名称  
    public String planDec;//计划描述  
    public String creater;//创建者  
    public String lastRunTime;//最后运行时间  
    public int getId() \{  
        return id;  
    \}  
    public void setId(int id) \{  
        this.id = id;  
    \}  
    public String getPlanName() \{  
        return planName;  
    \}  
    public void setPlanName(String planName) \{  
        this.planName = planName;  
    \}  
    public String getPlanDec() \{  
        return planDec;  
    \}  
    public void setPlanDec(String planDec) \{  
        this.planDec = planDec;  
    \}  
    public String getCreater() \{  
        return creater;  
    \}  
    public void setCreater(String creater) \{  
        this.creater = creater;  
    \}  
    public String getLastRunTime() \{  
        return lastRunTime;  
    \}  
    public void setLastRunTime(String lastRunTime) \{  
        this.lastRunTime = lastRunTime;  
    \}

**3、业务接口类：PlanInter.java**

public interface PlanInter \{  
    public List<FusePlanEntity> selectPlan();//获取测试计划

**4、业务实现类：PlanImp.java**

@Service("planService")  
public class PlanImp implements PlanInter \{  
    @Resource  
    private PlanDao planDao;  
      
    //获取测试计划  
    @Override  
    public List<FusePlanEntity> selectPlan() \{  
        return planDao.selectPlan();  
    \}

**5、控制层：PlanController.java**

@RestController  
@EnableAutoConfiguration  
@RequestMapping("/plan")  
public class PlanController \{      
    private final Logger logger = LoggerFactory.getLogger(PlanController.class);      
    @Resource  
    private PlanInter planInter;  
      
    @RequestMapping("/getEnty")  
    public List<FusePlanEntity> getEnty()\{  
        List<FusePlanEntity> list=planInter.selectPlan();  
        return list;  
    \}

**6、启动文件：Application.java**

@SpringBootApplication  
@MapperScan("com.\*\*\*.stp.dao")  
public class Application \{  
    public static void main(String\[\] args) \{  
        SpringApplication.run(Application.class, args);  
    \}

**7、ORM映射：PlanMapper.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.\*\*\*.stp.dao.PlanDao">  
         
       <resultMap id="PlanResultMap" type="com.\*\*\*.stp.pojo.FusePlanEntity">  
           <id column="id" property="id" jdbcType="INTEGER" />  
           <result column="planName" property="planName" jdbcType="VARCHAR" />  
           <result column="planDec" property="planDec" jdbcType="VARCHAR" />  
           <result column="creater" property="creater" jdbcType="VARCHAR" />  
           <result column="lastRunTime" property="lastRunTime" jdbcType="VARCHAR" />  
       </resultMap>  
          
      <sql id="Plan\_Column\_List" >  
          id,planName,planDec,creater,lastRunTime  
      </sql>  
       <select id="selectPlan" resultMap="PlanResultMap">  
          select <include refid="Plan\_Column\_List"/>   
          from tfci\_fuseplan  
       </select>  
</mapper>

**8、配置文件：application.properties**

server.port=8081

\#springmvc  
spring.mvc.view.prefix=/WEB-INF/pages/  
spring.mvc.view.suffix=.jsp

\#server.servlet.context-path=/stp  
spring.resources.static-locations=/WEB-INF/resources/

\# MySql Database  
spring.datasource.url=jdbc:mysql://ip:3306/数据库名称?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true  
spring.datasource.driverClassName=com.mysql.jdbc.Driver  
spring.datasource.username=\*\*\*  
spring.datasource.password=\*\*\*

mybatis.mapper-locations=classpath:mapper/\*.xml

**三、启动项目，访问接口：**[http://localhost:8081/plan/getEnty][http_localhost_8081_plan_getEnty]

![20190817170421733.png][]

**       四、补充：**

**1、项目静态资源**

静态资源可自定义路径，但是得和上面application.properties中的配置保持一致，这里提供参考

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p3MV9jc2Ru_size_16_color_FFFFFF_t_70 1][]

**二、mapper映射文件存放位置**

在Springmvc+Spring工程中mapper的路径可以放在src/main/java下面，并且通过配置文件映射；例如

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
          
        <property name="dataSource" ref="jdbcDataSource" />  
          
        <property name="typeAliasesPackage" value="com.\*\*\*.automation.entity"></property>  
          
        <property name="mapperLocations" value="**classpath\*:com/\*\*\*/automation/mapper/\*.xml**"></property>  
    </bean>

**        但是，在Springboot中不能直接放在src/main/java下面。应该存放在src/main/resources路径下，在application.properties中添加配置中：mybatis.mapper-locations=classpath:mapper/\*.xml**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p3MV9jc2Ru_size_16_color_FFFFFF_t_70]: /images/20211018/b4972bf94b8342b78a52cde6138f2a29.png
[http_localhost_8081_plan_getEnty]: http://localhost:8081/plan/getEnty
[20190817170421733.png]: /images/20211018/840018cd3fe44f60b46c800885c638f3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p3MV9jc2Ru_size_16_color_FFFFFF_t_70 1]: /images/20211018/2b4462dd920a4ce68057d899e8f0670e.png