10天冲刺第四天
今天做了什么：
springboot服务器搭建，实现图片上传
package com.example.psychological.Controller;
import com.example.psychological.DBHelpOpen;
import com.example.psychological.Dao;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import java.io.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
@RestController
@RequestMapping("/apply")
@CrossOrigin
public class approveController {
@Autowired
private JdbcTemplate jdbcTemplate;
/**
*
* @param uploadfile1 接收文件
* @param name1 接收其余参数
*@param uploadfile2 接收文件
*@param name2 接收其余参数
*@param name 接收其余参数
*@param id 接收其余参数
*@param money 接收其余参数
*@param intro 接收其余参数
* @return
* @throws IOException
*/
@PostMapping("/upload")
public String upload(MultipartFile uploadfile1,MultipartFile uploadfile2, String name1,String name2,String name,String id,String money,String intro) throws IOException, SQLException {
System.out.println(name);
//2、将上传的图片存储到硬盘
String path1="D:/code/Psychological/src/main/resources/"+name1;
String path2="D:/code/Psychological/src/main/resources/"+name2;
File dest1=new File(path1);
uploadfile1.transferTo(dest1);
File dest2=new File(path2);
uploadfile2.transferTo(dest2);
System.out.println(dest1.getPath());
String sql1="insert into consultant(id,name,money,introduction,personUrl,applyUrl,state) values('"+id+"','"+name+"','"+money+"','"+intro+"','"+path2+"','"+path1+"','未审批')";
String sql2="update consultant set name = '"+name+"',money = '"+money+"',introduction = '"+intro+"',state = '未审批' where id = '"+id+"'";
Dao d =new Dao();
Boolean y = d.haveCon(id);
if (y){
jdbcTemplate.update(sql2);
}
else {
jdbcTemplate.update(sql1);
}
return "success";
}
@GetMapping("/download")
public void download(HttpServletResponse response, HttpServletRequest request) throws IOException, SQLException {
String id = request.getHeader("id");
String sql ="select * from consultant where id = '"+id+"'";
Connection conn = DBHelpOpen.getConn();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
System.out.println(id);
rs.next();
String file = rs.getString("personUrl");
InputStream inputStream = new FileInputStream(file);
OutputStream outputStream = response.getOutputStream();
byte[] buffer = new byte[1024];
int bytesRead;
while ((bytesRead = inputStream.read(buffer))!=-1) {
outputStream.write(buffer,0,bytesRead);
}
inputStream.close();
outputStream.close();
}
@GetMapping("/download2")
public void download2(HttpServletResponse response, HttpServletRequest request) throws IOException, SQLException {
String id = request.getHeader("id");
String sql ="select * from consultant where id = '"+id+"'";
Connection conn = DBHelpOpen.getConn();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
System.out.println(id);
rs.next();
String file = rs.getString("applyUrl");
InputStream inputStream = new FileInputStream(file);
OutputStream outputStream = response.getOutputStream();
byte[] buffer = new byte[1024];
int bytesRead;
while ((bytesRead = inputStream.read(buffer))!=-1) {
outputStream.write(buffer,0,bytesRead);
}
inputStream.close();
outputStream.close();
}
/**
*
* @param uploadfile1 接收文件
* @param name1 接收其余参数
*@param name 接收其余参数
*@param id 接收其余参数
*@param money 接收其余参数
*@param intro 接收其余参数
* @return
* @throws IOException
*/
@PostMapping("/update")
public String update(MultipartFile uploadfile1,String name1,String name,String id,String money,String intro) throws IOException {
//2、将上传的图片存储到硬盘
String path1="D:/code/Psychological/src/main/resources/"+name1;
File dest1=new File(path1);
uploadfile1.transferTo(dest1);
String sql ="update consultant set name = '"+name+"',money = '"+money+"',introduction = '"+intro+"' where id = '"+id+"'";
jdbcTemplate.update(sql);
return "success";
}
}
咨询师资格申请
页面：
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:id="@+id/main"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
tools:context=".applyActivity">
<ImageView
android:layout_width="match_parent"
android:layout_height="20dp"
android:background="@color/white"/>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:text="证件照片："
android:textSize="20dp"
android:textColor="@color/black"/>
<ImageButton
android:id="@+id/ibt_jpg"
android:layout_width="200dp"
android:layout_height="200dp"
android:scaleType="centerCrop"
android:src="@drawable/baseline_add_24"
android:background="#BFBFBF" />
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:text="营业照片："
android:textSize="20dp"
android:textColor="@color/black"/>
<ImageButton
android:id="@+id/ibt_person"
android:layout_width="200dp"
android:layout_height="200dp"
android:scaleType="centerCrop"
android:src="@drawable/baseline_add_24"
android:background="#BFBFBF"/>
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:text="预约金额："
android:textSize="20dp"
android:textColor="@color/black"/>
<EditText
android:id="@+id/ed_money"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:inputType="number"/>
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:text="真实姓名："
android:textSize="20dp"
android:textColor="@color/black"/>
<EditText
android:id="@+id/ed_name"
android:layout_width="match_parent"
android:layout_height="wrap_content"/>
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="120dp"
android:layout_height="wrap_content"
android:text="简介："
android:textSize="20dp"
android:textColor="@color/black"/>
<EditText
android:id="@+id/ed_introduction"
android:layout_width="match_parent"
android:layout_height="100dp"
android:maxLength="50"/>
</LinearLayout>
<Button
android:id="@+id/bt_commit"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="提交"/>
</LinearLayout>
代码：
package com.example.psychological;
import android.Manifest;
import android.content.Intent;
import android.content.SharedPreferences;
import android.content.pm.PackageManager;
import android.os.Bundle;
import android.os.Looper;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.Toast;
import androidx.activity.EdgeToEdge;
import androidx.annotation.NonNull;
import androidx.appcompat.app.AppCompatActivity;
import androidx.core.app.ActivityCompat;
import androidx.core.content.ContextCompat;
import com.example.psychological.javaClass.Consultant;
import com.example.psychological.javaClass.HttpUtil;
import com.example.psychological.javaClass.Utils;
import java.io.File;
import java.io.IOException;
import okhttp3.Call;
import okhttp3.Callback;
import okhttp3.MediaType;
import okhttp3.MultipartBody;
import okhttp3.RequestBody;
import okhttp3.Response;
public class applyActivity extends AppCompatActivity implements View.OnClickListener {
private static final int STORAGE_PERMISSION = 1;
private static final int CHOOSE_PHOTO = 1;
private static final String NET="192.168.129.224";
private ImageButton ibt_jpg;
private ImageButton ibt_person;
private Button bt_commit;
private EditText ed_name;
private EditText ed_money;
private EditText ed_intro;
private File file1=null;
private File file2=null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
EdgeToEdge.enable(this);
setContentView(R.layout.activity_apply);
getSupportActionBar().hide();
ibt_jpg = findViewById(R.id.ibt_jpg);
ibt_person = findViewById(R.id.ibt_person);
bt_commit = findViewById(R.id.bt_commit);
ed_name = findViewById(R.id.ed_name);
ed_money = findViewById(R.id.ed_money);
ed_intro = findViewById(R.id.ed_introduction);
ibt_jpg.setOnClickListener(this);
ibt_person.setOnClickListener(this);
bt_commit = findViewById(R.id.bt_commit);
bt_commit.setOnClickListener(this);
}
@Override
public void onClick(View v) {
if(v.getId()==R.id.ibt_jpg){
if (ContextCompat.checkSelfPermission(applyActivity.this, android.Manifest.permission.WRITE_EXTERNAL_STORAGE) != PackageManager.PERMISSION_GRANTED) {
ActivityCompat.requestPermissions(applyActivity.this, new String[]{Manifest.permission.WRITE_EXTERNAL_STORAGE}, STORAGE_PERMISSION);
} else {
xzImage1();
}
} else if (v.getId()==R.id.ibt_person) {
if (ContextCompat.checkSelfPermission(applyActivity.this, android.Manifest.permission.WRITE_EXTERNAL_STORAGE) != PackageManager.PERMISSION_GRANTED) {
ActivityCompat.requestPermissions(applyActivity.this, new String[]{Manifest.permission.WRITE_EXTERNAL_STORAGE}, 2);
} else {
xzImage2();
}
}
else {
scImage();
finish();
startActivity(new Intent(this, MainActivity.class));
}
}
private void xzImage1() {
Intent intent = new Intent("android.intent.action.GET_CONTENT");
intent.setType("image/*");
startActivityForResult(intent,CHOOSE_PHOTO); // 打开本地存储
//CHOOSE_PHOTO：全局常量，标识
}
private void xzImage2() {
Intent intent = new Intent("android.intent.action.GET_CONTENT");
intent.setType("image/*");
startActivityForResult(intent,2); // 打开本地存储
//CHOOSE_PHOTO：全局常量，标识
}
private void scImage() {
SharedPreferences sharedPreferences = getSharedPreferences("user",MODE_PRIVATE);
String id = sharedPreferences.getString("id","");
String name = sharedPreferences.getString("name","");
String applyname="apply/"+id+".jpg";
String personname="person/"+id+".jpg";
String realname=ed_name.getText().toString();
String money=ed_money.getText().toString();
String intro=ed_intro.getText().toString();
if(file1==null||file2==null||realname.equals("")||personname.equals("")||money.equals("")||intro.equals("")) {
Looper.prepare();
Toast.makeText(applyActivity.this,"输入不符合要求", Toast.LENGTH_SHORT).show();
Looper.loop();
}
//1、创建请求体
RequestBody requestBody = new MultipartBody.Builder()
.setType(MultipartBody.FORM)//请求类型
.addFormDataPart("name1", applyname)//参数
.addFormDataPart("name2", personname)
.addFormDataPart("name",realname)
.addFormDataPart("money",money)
.addFormDataPart("intro",intro)
.addFormDataPart("id",id)
.addFormDataPart("uploadfile1", "uploadfile1", RequestBody.create(MediaType.parse("*/*"), file1))
.addFormDataPart("uploadfile2", "uploadfile2", RequestBody.create(MediaType.parse("*/*"), file2))// 第一个参数传到服务器的字段名，第二个你自己的文件名，第三个MediaType.parse("*/*")数据类型，这个是所有类型的意思,file就是我们之前创建的全局file，里面是创建的图片
.build();
//2、调用工具类上传图片以及参数
HttpUtil.uploadFile("http://"+NET+":8080/apply/upload", requestBody, new Callback() {
//请求失败回调函数
@Override
public void onFailure(Call call, IOException e) {
System.out.println("=============");
System.out.println("异常：：");
e.printStackTrace();
}
//请求成功响应函数
@Override
public void onResponse(Call call, Response response) throws IOException {
showResponse(response.body().string());//在主线程中显示提示框
}
});
}
@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);
String realPath;
//requestCode：标识码
//data：选择的图片的信息
switch (requestCode) {
case CHOOSE_PHOTO:
//显示图片
ibt_jpg.setImageURI(data.getData());
System.out.println("图片在手机上的虚拟路径为："+data.getData());
realPath = Utils.getRealPath(this, data);
file1 = new File(realPath);
System.out.println("图片在手机上的真实路径为："+realPath);
break;
case 2:
ibt_person.setImageURI(data.getData());
System.out.println("图片在手机上的虚拟路径为："+data.getData());
realPath = Utils.getRealPath(this, data);
file2 = new File(realPath);
System.out.println("图片在手机上的真实路径为："+realPath);
break;
default:
break;
}
}
//选择权限后的回调函数
@Override
public void onRequestPermissionsResult(int requestCode, @NonNull String[] permissions, @NonNull int[] grantResults) {
super.onRequestPermissionsResult(requestCode, permissions, grantResults);
switch (requestCode) {
case STORAGE_PERMISSION:
//检查是否有读取存储卡的权限，如果有则选择图片，如果没有则提示
if (grantResults.length > 0 && grantResults[0] == PackageManager.PERMISSION_GRANTED) {
xzImage1();
} else {
Toast.makeText(this, "You denied the permission", Toast.LENGTH_SHORT).show();
}
break;
case 2:
if (grantResults.length > 0 && grantResults[0] == PackageManager.PERMISSION_GRANTED) {
xzImage2();
} else {
Toast.makeText(this, "You denied the permission", Toast.LENGTH_SHORT).show();
}
break;
default:
}
}
//ui操作，提示框
private void showResponse(final String response) {
runOnUiThread(new Runnable() {
@Override
public void run() {
// 在这里进行UI操作，将结果显示到界面上
Toast.makeText(applyActivity.this, response, Toast.LENGTH_SHORT).show();
}
});
}
明天：咨询申请后界面
遇到的问题：相册图片权限获取问题，springboot知识问题
浙公网安备 33010602011771号