springBoot多模块项目包含集成 mybatis链接Oracle数据库

最新推荐文章于 2024-07-26 12:28:02 发布

haqppy

最新推荐文章于 2024-07-26 12:28:02 发布

阅读量308

点赞数 1

分类专栏： springboot 文章标签： java spring boot 数据库

本文链接：https://blog.csdn.net/haqppy/article/details/105250962

版权

springboot 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

开发工具idea
本项目源码

1.创建项目

idea新建父项目parent—>module—>spring intializr next 在这里插入图片描述

parent项目中没有具体代码不需要选直接next，新建完成后目录

不需要src删除然后右键parent新建子项目server，client

选填需要什么插件 mybatis jdbc redis web等
创建好后项目目录为

测试项目server不需要打包删除启动类和配置文件，并把不需要的.mvndaoiml、mvnw、mvnw.cmd 等删除只剩pom.xml
在这里插入图片描述

项目依赖关系

parent打包方式修改为pom

<packaging>pom</packaging>

注意build中修改为maven-compiler-plugin

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.2.6.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.godstady</groupId>
	<artifactId>parent</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>parent</name>
	<packaging>pom</packaging>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>
    <!--声明有几个子模块-->
	<modules>
		<module>server</module>
		<module>client</module>
	</modules>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<!--<artifactId>spring-boot-maven-plugin</artifactId> 多项目互相依赖会有问题 报错-->
				<version>3.1</version>
				<configuration>
					<source>${java.version}</source>
					<target>${java.version}</target>
				</configuration>
			</plugin>

		</plugins>
	</build>

</project>

server子项目pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>com.godstady</groupId>
		<artifactId>parent</artifactId>
		<version>0.0.1-SNAPSHOT</version>
		<relativePath>../pom.xml</relativePath>
	</parent>
	<groupId>com.godstady</groupId>
	<artifactId>server</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>server</name>
	<packaging>jar</packaging>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-redis</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.2</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>

		<dependency>
			<groupId>com.oracle.ojdbc</groupId>
			<artifactId>ojdbc8</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
	</dependencies>


</project>

client子项目pom.xml因项目中需要调用server方法需要依赖server

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>com.godstady</groupId>
		<artifactId>parent</artifactId>
		<version>0.0.1-SNAPSHOT</version>
		<relativePath>../pom.xml</relativePath>
	</parent>
	<groupId>com.godstady</groupId>
	<artifactId>client</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>client</name>
	<packaging>jar</packaging>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>com.godstady</groupId>
			<artifactId>server</artifactId>
			<version>0.0.1-SNAPSHOT</version>
		</dependency>

		<dependency>
			<groupId>com.oracle.ojdbc</groupId>
			<artifactId>ojdbc8</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
			<exclusions>
				<exclusion>
					<groupId>org.junit.vintage</groupId>
					<artifactId>junit-vintage-engine</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId><configuration>
				<!--指定该Main Class为全局的唯一入口-->
				<mainClass>com.godstady.ClientApplication</mainClass>
				<layout>ZIP</layout>
			</configuration>
				<executions>
					<execution>
						<goals>
							<goal>repackage</goal><!--可以把依赖的包都打包到生成的Jar包中-->
						</goals>
					</execution>
				</executions>

			</plugin>
		</plugins>
	</build>

</project>

此时多项目搭建完成链接数据库测试，未达成client子项目调用server项目
entity，dao，server层都在server子项目中，controller放在client项目中
User.java

public class User {

    private String id;
    private String username;
    private String password;
    private String addr;
    private Integer age;
    private Date birth;

}

get,set toString 节省篇幅省略
User.dao

@Mapper
public interface UserDao {
    List<User> getAllList();
}

UserService.java

@Service
public class UserService {

    @Autowired
    private UserDao dao;
    public List<User> getAllList(){
        return dao.getAllList();
    }
}

UserController.java

package com.godstady.client.controller;

import com.godstady.server.entity.User;
import com.godstady.server.service.UserService;
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 java.util.List;

/**
 * Created by godstady on 2020/4/2.
 */
@RequestMapping("/userController")
@RestController
public class UserController {

    @Autowired
    private UserService service;

    @RequestMapping("/list")
    @ResponseBody
    public String getAllUsers(){

        List<User> allList = service.getAllList();

        return allList.toString();
    }
}

application.yml
在这里插入图片描述
代码编写完成创建数据库脚本

create table USERS
(
  id       VARCHAR2(64),
  username VARCHAR2(100),
  password VARCHAR2(100),
  addr     VARCHAR2(500),
  age      NUMBER,
  birth    DATE
)

在这里插入图片描述
启动项目浏览器访问成功

个人见解如有偏差，烦请指正，编写不易如有幸帮助到，请点赞谢谢。

haqppy

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
springBoot多模块项目包含集成 mybatis链接Oracle数据库

开发工具idea本项目源码1.创建项目idea新建父项目parent—>module—>spring intializr nextparent项目中没有具体代码不需要选直接next，新建完成后目录不需要src删除然后右键parent新建子项目server，client选填需要什么插件 mybatis jdbc redis web等创建好后项目目录为测试项目s...
复制链接

扫一扫

专栏目录