springboot整合mybatis连接oracle

原创已于 2022-05-26 15:23:47 修改 · 9.3k 阅读

33 ·

CC 4.0 BY-SA版权

文章标签：

#springboot #mybatis

于 2019-06-29 17:06:24 首次发布

springboot 专栏收录该内容

22 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中整合MyBatis，包括配置pom依赖、设置数据源、创建实体类、mapper、service和controller，以及启动项目进行数据库操作的全过程。

创建springboot项目

1.pom文件：

<dependencies>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
	</dependency>

	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-tomcat</artifactId>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-test</artifactId>
	</dependency>
	<!-- springboot整合mybatis -->
	<dependency>
		<groupId>org.mybatis.spring.boot</groupId>
		<artifactId>mybatis-spring-boot-starter</artifactId>
		<version>1.3.2</version>
	</dependency>
	<!-- oracle驱动 -->
	<dependency>
		<groupId>com.oracle</groupId>
		<artifactId>ojdbc7</artifactId>
		<version>12.1.0.2</version>
	</dependency>
	<!-- 编译时自动生成实体类的setter,getter方法 -->
	<dependency>
		<groupId>org.projectlombok</groupId>
		<artifactId>lombok</artifactId>
	</dependency>
</dependencies>

本地仓库安装ojdbc7.jar，参考：win10安装mvn,安装ojdbc7.jar_QYHuiiQ的博客-优快云博客_ojdbc7.jar

2.创建application.properties：

######datasource
spring.datasource.url=jdbc:oracle:thin:@192.168.184.129:1522:orcl
spring.datasource.username=wyh
spring.datasource.password=xxxx
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

3.创建实体类Testuser：

package com.wyh.entity;

import lombok.Data;

@Data//使用lombok简化代码，自动在编译的时候生成setter,getter方法
public class Testuser {
	//创建实体类，注意属性名要和数据库中的字段名保持一致
	
	private Integer id;
	private Integer age;
	private String name;

}

4.建表：

5.创建mapper：

package com.wyh.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.wyh.entity.Testuser;

//这里可以不使用注解，在启动类中加上MapperScan注解，里面添加该mapper所在的包路径即可
public interface UserMapper {

	//使用注解式开发查询语句
	@Select("SELECT * FROM TESTUSER WHERE NAME = #{name}")
	Testuser getUserByName(@Param("name") String name);
	
	@Insert("INSERT INTO TESTUSER(NAME, AGE) VALUES(#{name}, #{age})")
	int insert(@Param("name") String name, @Param("age") Integer age);

}

6.创建service：

package com.wyh.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.wyh.mapper.UserMapper;

@Service
public class UserService {
	
	@Autowired
	private UserMapper userMapper;
	
	public int insertUser(String name, Integer age) {
		int insertResult = userMapper.insert(name, age);
		return insertResult;
	}

}

7.创建controller：

package com.wyh.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.wyh.service.UserService;

@RestController
public class UserController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping("/insertUser")
	public Integer insertUser(String name, Integer age) {
		int insertUser = userService.insertUser(name, age);
		return insertUser;
	}

}

8.启动类：

package com.wyh;

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

@SpringBootApplication//扫描同级包及子包
@MapperScan(basePackages = {"com.wyh.mapper"})//在mapper中不用添加注解，在此处指明要扫描的mapper所在的包路径。通过反射技术读取该包下面的所有类
public class SpringbootKafkaApplication {

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

}

9.启动项目，访问url：