Spring boot 1.5.9 爬坑总结

最新推荐文章于 2022-08-17 12:18:48 发布

企鹅20133

最新推荐文章于 2022-08-17 12:18:48 发布

阅读量138

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/u012371521/article/details/84914902

版权

java 专栏收录该内容

40 篇文章 0 订阅

订阅专栏

1.参考教程： http://412887952-qq-com.iteye.com/category/356333?page=8

8. 使用JPA保存数据【从零开始学Spring Boot】

注意问题：

:问题1：需要安装一个mysql

问题2：mysql5.7以上版本，必须配置ssl

spring.datasource.url = jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=yes

问题3：mysql5.7以上，naming-strategy配置也改变了

spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

问题4：application.properties配置项，记住删掉末尾的空格（巨坑）

问题5: spring.datasource.url = jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=yes

test是数据库名，你要自己在mysql中创建一个数据库

解决方法：

1. ctrl+R 打开cmd命令行

2. mysql -u root -p 进入mysql输入密码

3. create database test;

问题6：access denied（数据库不允许远程访问）

解决方法： 1.登录数据库， mysql -u root -p

2.输入你想授权的账号名（替换myuser）和密码（替换mypassword）：

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

3.输入命令： FLUSH PRIVILEGES; 然后就能访问了

application.properties配置示例：

spring.datasource.url = jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=yes
spring.datasource.username = admin
spring.datasource.password = admin
spring.datasource.driverClassName = com.mysql.jdbc.Driver


# Specify the DBMS  
spring.jpa.database = MYSQL
# Show or not log for each sql query  
spring.jpa.show-sql = true
# Hibernate ddl auto (create, create-drop, update)  
spring.jpa.hibernate.ddl-auto = update
# Naming strategy  
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
# stripped before adding them to the entity manager)  
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

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.example</groupId>
	<artifactId>demo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>demo</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.9.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

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

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		
         <dependency>  
           <groupId>org.springframework.boot</groupId>  
           <artifactId>spring-boot-starter-data-jpa</artifactId>  
         </dependency>  
		<dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>


</project>

28. SpringBoot启动时的Banner设置【从零开始学Spring Boot】

注意问题

可以在代码中配置关闭banner，也可以在properties中配置

spring.main.banner-mode=off

29. Spring boot 文件上传（多文件上传）【从零开始学Spring Boot】

注意问题

文件上传到指定路径，一定要是文件，如果是目录就会出现拒绝访问。

 String path="F:/test/";
File savedir = new File(path);  
if (!savedir.exists()) {  
	       savedir.mkdirs();  
}  
File myFile=new File(path+"1.txt");
BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(myFile));