springBoot集成SSM框架

最新推荐文章于 2023-06-20 13:51:10 发布

悔建阿里杰克马

最新推荐文章于 2023-06-20 13:51:10 发布

阅读量393

点赞数

分类专栏： SpringBoot 文章标签： spring

本文链接：https://blog.csdn.net/wukkk111/article/details/107785411

版权

SpringBoot 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

导入maven依赖

<dependencies>
        <!--添加jdbc连接依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--添加数据库连接依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--添加mybatis集成依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
        <!--添加项目对web应用支持依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--添加应用对aop的依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
        <!--添加测试依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <!--添加lombok的依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

创建配置文件以及mapper等文件夹
配置文件

server:
  port: 8088

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    password: 123456
    username: root

mybatis:
  type-aliases-package: com.everyweek.ssm //别名
  mapper-locations: classpath:mapper/*.xml //mapper文件位置

业务代码及结构

@RestController
public class userController {

    @Autowired
    userService userService;

    @RequestMapping("/getUserByUserId")
    public User getUserByUserId(@RequestParam("userId") String userId){
       return userService.getUserByUserId(userId);
    }
}

@Service
public class userServiceImpl implements userService {

    @Resource  //使用@Resource 用@Autowired无法找到mapper
    userDaoMapper userDao;

    @Override
    public User getUserByUserId(String userId) {
        return userDao.getUserByUserId(userId);
    }
}

@Mapper
public interface userDaoMapper {

    User getUserByUserId(@Param("id") String id);
}

mapper配置文件

<mapper namespace="com.everyweek.ssm.dao.userDaoMapper">

    <resultMap id="user" type="com.everyweek.ssm.entrty.User">
        <id property="userId" column="id"></id>
        <result property="userName" column="name"></result>
        <result property="userBirthday" column="birthday"></result>
        <result property="userAddress" column="address"></result>
    </resultMap>

    <select id="getUserByUserId" parameterType="String" resultMap="user">
            select * from user where id=#{id}
    </select>

</mapper>