简单实现在eclipse中spring boot项目连接数据库

简单实现在eclipse中spring boot项目连接数据库

第一步：
1.首先创建一个maven项目，在此之前要确定你已经配置好了有关maven的插件。new << project
本项目命名并不规范，请原谅

2.记得勾选第一项

3.进行项目命名
Group Id : org.springframework.boot
Aetifact : spring-boot-starter-parent
Version : 2.0.0.RELEASE

4.创建好后的效果

5.在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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.midgetontoes</groupId>
<artifactId>y</artifactId>
<!-- 记得改成你的项目名 -->
<version>1.0-SNAPSHOT</version>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring.boot.version>2.3.1.RELEASE</spring.boot.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>${spring.boot.version}</version>
<exclusions>
          <exclusion>
               <groupId>org.slf4j</groupId>
               <artifactId>slf4j-log4j12</artifactId>
          </exclusion>
     </exclusions>
</dependency>
<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.3</version>
		</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.4</version>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>2.3.1.RELEASE</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>${spring.boot.version}</version>
<executions>
<execution>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>

第二步：
1.创建有关的包
注意application.java的位置

2.创建有关类，

(1)怎样创建application.properties文件


第三步：
1.创建了一个y数据库，里面的表名为 yy

2.在数据表中加入有关数据

3.在eclipse中连接数据库
(1)application.properties文件加入

server.port=8083
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/y?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=mysql
mybatis.mapper-locations: classpath:mapper/*.xml

**注意：**访问路径为8083

在mapper.xml中加入

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="y.mapper.YMapper">
   <select id="getY" parameterType="java.lang.Integer" resultType="y.model.Y">
    select * from yy where id = #{id}
   </select>
</mapper>

第四步：

1. Application.java

package y;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class Application {
	public static void main(String[] args) {	
		SpringApplication.run(Application.class,args);	
	}
}

2. YController.java

package y.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import y.model.Y;
import y.service.YService;
@RestController
@RequestMapping("/y")
public class YController {
	@Autowired
	private YService yService;
	@RequestMapping("/getY")
	public List<Y> getUser(@RequestParam("id") int id) {
		return yService.getY(id);	
	}
}

3. YMapper.java

package y.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import y.model.Y;
@Mapper
public interface YMapper {
	List<Y> getY(int id);
}

4. Y.java

package y.model;
import org.springframework.stereotype.Component;
@Component
public class Y {
	private int id;
	private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

5. YService.java

package y.service;
import java.util.List;
import y.model.Y;
public interface YService {
	public List<Y> getY(int id);
}

6. YServiceImpl.java

package y.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import y.model.Y;
import y.service.YService;
import y.mapper.YMapper;
@Service
public class YServiceImpl implements YService {
	@Autowired
	private YMapper yMapper;
	public List<Y> getY(int id) {
		return yMapper.getY(id);
	}
}

注意：
如果遇到问题，请先更新maven配置（有时因maven配置更新不及时则需要进行更新）
更新maven配置方法
选中项目右击 << maven << update project

更新完后在
选中项目右击 << build path << configgure build path
查看project 中有没有其他的项目 如果有请移除

在libraries中是否只有这两项，如果出现tomcat有关包可进行移除

运行结果
在浏览器中输入 http://localhost:8083/y/getY?id=1
注：id后的数使查询数据库的第几条

如果运行成功则可以实现了简单的spring boot的数据交换了