mysql 使用mybatis保存图片

最新推荐文章于 2024-07-20 12:18:20 发布

lilianggui

最新推荐文章于 2024-07-20 12:18:20 发布

阅读量6.3k

点赞数 24

分类专栏： java mybatis 文章标签： mybatis 文件上传图片上传

本文链接：https://blog.csdn.net/lilianggui/article/details/102507794

版权

java 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

mybatis

2 篇文章 0 订阅

订阅专栏

1、创建springboot项目

2、引入依赖

<?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.1.9.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.llg</groupId>
	<artifactId>mybatis</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>mybatis</name>
	<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>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>

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

	</dependencies>

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

</project>

3、实体类

package com.llg.mybatis.entity;

import lombok.Data;

@Data
public class Users {
    private Integer id;
    private String username;
    private String password;
    private byte[] pic;
}

4、前端页面

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <form action="/upload" enctype="multipart/form-data" method="post">
        <input type="file" name="file"><br>
        <input type="submit" value="提交">
    </form>
</body>
</html>

5、上传方法

@PostMapping("/upload")
public String savePic(@RequestParam("file") MultipartFile file){
	if (file.isEmpty()) {
		return "上传失败，请选择文件";
	}
	try {
		InputStream is = file.getInputStream();
		Users u = new Users();
		u.setUsername("哈哈");
		u.setUsername("123456");
		byte[] pic = new byte[(int)file.getSize()];
		is.read(pic);
		u.setPic(pic);
		userService.addUser(u);
		return "上传成功";
	} catch (IOException e) {
		e.printStackTrace();
	}
	return "success";
}

6、mapper sql语句

<insert id="addUser">
    insert into users (username, password, pic) values (#{username}, #{password}, #{pic})
</insert>

7、启动程序-打开页面-上传图片

成功

8、前端获取数据库的图片并展示

后端代码

@GetMapping(value="/getPhoto")
public void getPhotoById(final HttpServletResponse response) throws IOException {
	Users users = userService.getLastUser();
	byte[] data = users.getPic();
	response.setContentType("image/jpeg");
	response.setCharacterEncoding("UTF-8");
	OutputStream outputSream = response.getOutputStream();
	InputStream in = new ByteArrayInputStream(data);
	int len = 0;
	byte[] buf = new byte[1024];
	while ((len = in.read(buf, 0, 1024)) != -1) {
		outputSream.write(buf, 0, len);
	}
	outputSream.close();
}

sql语句

<select id="getLastUser" resultType="com.llg.mybatis.entity.Users">
    select * from users order by id desc limit 1
</select>

结果

lilianggui

关注

24
点赞
踩
81

收藏

觉得还不错? 一键收藏
9
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录