使用mybatis来操作oracle

GitHub质检员

于 2024-02-21 09:14:27 发布

阅读量291

点赞数 1

分类专栏：优质好文分享文章标签： mybatis oracle 数据库

本文链接：https://blog.csdn.net/qq_40647372/article/details/136202959

版权

优质好文分享专栏收录该内容

55 篇文章 3 订阅

订阅专栏

本文介绍了如何使用SpringBoot进行项目初始化，添加Oracle数据库依赖，配置数据源和MyBatis映射，展示了从DAO到Controller的完整CRUD操作流程，并通过测试验证了接口的正确性。

摘要由CSDN通过智能技术生成

1.使用spring的初始化工具来构建项目-
在这里插入图片描述 -
2.添加依赖-
-
3.项目结构-
-
4.详细文件-
4.1配置文件

server:
  port: 8888
spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@127.0.0.1:11521:helowin
    username: mark
    password: 123456
  flyway:
    enabled: false

4.2DTO

@Data
@AllArgsConstructor
@NoArgsConstructor
public class UserDto implements Serializable {
    private Integer id;
    private String  name;
    private String  pwd;
}

4.3Controller

@RestController
@RequestMapping("/hel")
public class HelloOracle {

    @Autowired
    private UserService userService;

    @GetMapping("/user")
    public List<UserDto> getUsers(){
        List<UserDto> users= userService.getAllUsers();
        return users;
    }
}

4.4Service

public interface UserService {
    /**
     * 获取所有用户
     * @return
     */
    List<UserDto> getAllUsers();
}

@Service
public class UserServiceImpl implements UserService{
    @Autowired
    private UserDao userDao;

    @Override
    public List<UserDto> getAllUsers() {
        List<UserDto> users=userDao.selectAllUsers();
        return users;
    }
}

4.5Dao

@Mapper
public interface UserDao {
    /**
     * 获取所有用户
     * @return
     */
    List<UserDto> selectAllUsers();

}

4.6Mapper

<?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.example.oraclewithmybatis.dao.UserDao">
    <!--    配置查询所有 id为方法名 resultType指定封装的实体类型-->
    <select id="selectAllUsers" resultType="com.example.oraclewithmybatis.dto.UserDto">
        select
               ID id,
               PWD pwd,
               USER_NAME name
        from USER_INFO
    </select>
</mapper>

4.7Sql脚本

CREATE TABLE USER_INFO(
    ID INT NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    PWD VARCHAR(200) NOT NULL   COMMENT '密码' ,
    USER_NAME VARCHAR(200) NOT NULL   COMMENT '用户名' ,
    PRIMARY KEY (ID)
)  COMMENT = '用户表';

4.8测试结果

GET http://localhost:8888/hel/user

HTTP/1.1 200 
Content-Type: application/json
Transfer-Encoding: chunked
Date: Mon, 25 Oct 2021 13:14:56 GMT
Keep-Alive: timeout=60
Connection: keep-alive

[
  {
    "id": 1,
    "name": "mark",
    "pwd": "123456"
  },
  {
    "id": 2,
    "name": "张安",
    "pwd": "123456"
  }
]

Response code: 200; Time: 1040ms; Content length: 75 bytes