分享一些狀態(tài)碼400 404 500等原因:

出錯:


前端:

// 獲取所有的導(dǎo)航菜單async getMenuList(){const {data:res} = await this.$http.get("menus");console.log(res.data);if( res.status != 200) return this.$message.error("操作失敗！！！");this.menuList = res.data;},

后端：

@RestController public class MenuController {@AutowiredMenuDao menuDao;@CrossOrigin@RequestMapping("/menus")public String getAllMenus(){System.out.println("sucess");HashMap<String, Object> data = new HashMap<>();List<MainMenu> mainMenus = menuDao.getMainMenus();data.put("data",mainMenus);data.put("status",200);String data_json = JSON.toJSONString(data);System.out.println("成功訪問！！！");return data_json;} }

xml文件:

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.naughty.userlogin02.dao.MenuDao"><resultMap id="menumap" type="com.naughty.userlogin02.bean.MainMenu"><id column="id" property="id"></id><result column="title" property="title"></result><result column="path" property="path"></result><collection property="slist" ofType="com.naughty.userlogin02.bean.SubMenu"><result column="sid" property="id"></result><result column="stitle" property="title"></result><result column="spath" property="path"></result></collection></resultMap><select id="getMainMenus" resultMap="menumap">SELECT mm.*,sm.id as sid ,sm.title as stitle,sm.path as spath FROM mainmenu mm ,submenu sm WHERE mm.id = sm.mid;</select></mapper>

檢查后發(fā)現(xiàn)是配置文件寫錯，修改為:

spring:datasource:#MySQL配置driverClassName: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3308/data1?useSSL=false&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTCusername: heziyipassword: 123456

修改完后再次啟動，沒有報(bào)錯了

錯誤碼404：
發(fā)現(xiàn)是因?yàn)閏ontroller類上面沒有加@RestController注解

2.17日又一次出現(xiàn)錯誤碼500

response報(bào)錯：

{“timestamp”:“2021-02-17T08:22:46.911+0000”,“status”:500,“error”:“Internal
Server Error”,“message”:“Invalid bound statement (not found):
com.naughty.userlogin02.dao.TeacherDao.getTeacherCounts”,“path”:"/allteacher"}

自己的TeacherDao中有一句話:
public int getTeacherCounts(@Param(“name”) String name);
然后查了一下發(fā)現(xiàn)有可能是因?yàn)閤ml中沒有對應(yīng)的語句造成的，在xml中加上：

<select id="getTeacherCounts" resultType="java.lang.Integer">SELECT count(*) FROM `teacherlist`<if test="name !=null ">WHERE name like #{name}</if></select>

再運(yùn)行已經(jīng)成功了，前端頁面能夠正常顯示數(shù)據(jù)：

2.21
出現(xiàn)錯誤碼500原因之一:
xml文件中方法名的大小寫與接口中的方法名大小寫沒對上
之后仍然再次出現(xiàn)錯誤碼500
信息:

Cannot determine value type from string ‘?dāng)?shù)學(xué)’; nested exception is java.sql.SQLDataException: Cannot determine value type from string

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Error attempting to get column ‘title’ from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string ‘?dāng)?shù)學(xué)’
; Cannot determine value type from string ‘?dāng)?shù)學(xué)’; nested exception is java.sql.SQLDataException: Cannot determine value type from string ‘?dāng)?shù)學(xué)’] with root cause

在message實(shí)體類中加上無參構(gòu)造函數(shù)之后解決。

總結(jié)

以上是生活随笔為你收集整理的Uncaught (in promise) Error: Request failed with status code 500的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。