springboot这么写将一组数据写入数据库表中postman请求出现500错误，如何解决？
springboot这么写将一组数据写入数据库表中postman请求出现500错误
//ser层
@Override
public int addMyPerTrace(Position mP) {
mP.setUserID(mP.UserID);
mP.setTraceID(mP.traceID);
mP.setLatitude(mP.latitude);
mP.setLongitude(mP.longitude);
mP.setTheFirstDate(mP.TheFirstDate);
mP.setOpenID(mP.OpenID);
mP.setWarning(mP.Warning);
return userMapper.insertMyPerTimeTrace(mP);
}
//controller层
@RequestMapping(value="/addMyPerTrace/{UserID}/{traceID}/{longitude}/{latitude}/{ThisFirstDate}/{OpenID}/{Warning}")
@ResponseBody
public int addPerTrace(@PathVariable("UserID") Integer UserID,@PathVariable("traceID") Integer traceID,@PathVariable("longitude") Float longitude,@PathVariable("latitude") Float latitude,@PathVariable("TheFirstDate") String TheFirstDate,@PathVariable("OpenID") String OpenID,@PathVariable("Warning") Integer Warning) {
Position mP=new Position(UserID,traceID,longitude,latitude,TheFirstDate,OpenID,Warning);
return userService.addMyPerTrace(mP);
}
//mapper.xml
"insertMyPerTimeTrace" parameterType="com.example.demo01.domain.Position">
insert into position.location(UserID,traceID,longitude,latitude,TheFirstDate,OpenID,Warning) values(#{UserID},#{traceID},#{longitude},#{latitude},#{TheFirstDate},#{OpenID},#{Warning})
//实体类
public class Position {
@TableId(type= IdType.AUTO)
public Integer UserID;
public Integer traceID;
public Float longitude;
public Float latitude;
public String TheFirstDate;
public String OpenID;
public Integer Warning;
}
//请求
127.0.0.1/position/addMyPerTrace/1/2/23.456789/12.345678/2023-04-19%2015:07:37/980/0
没有指定请求方式吧,指定一下请求方式试一下,是get还是post
报错如下
Set query string encoding to UTF-8
2023-04-20 09:47:41.663 DEBUG 18940 --- [nio-8000-exec-1] o.a.c.authenticator.AuthenticatorBase : Security checking request POST /position/addMyPerTrace/1/2/23.456789/12.345678/2023-04-19%2015:07:37/980/0
2023-04-20 09:47:41.664 DEBUG 18940 --- [nio-8000-exec-1] org.apache.catalina.realm.RealmBase : No applicable constraints defined
2023-04-20 09:47:41.678 DEBUG 18940 --- [nio-8000-exec-1] o.a.c.a.jaspic.AuthConfigFactoryImpl : Loading persistent provider registrations from [C:\Users\齐大人\AppData\Local\Temp\tomcat.8000.92042815815836260\conf\jaspic-providers.xml]
2023-04-20 09:47:41.679 DEBUG 18940 --- [nio-8000-exec-1] o.a.c.authenticator.AuthenticatorBase : Not subject to any constraint
2023-04-20 09:47:41.686 INFO 18940 --- [nio-8000-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2023-04-20 09:47:41.686 INFO 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2023-04-20 09:47:41.687 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Detected StandardServletMultipartResolver
2023-04-20 09:47:41.687 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Detected AcceptHeaderLocaleResolver
2023-04-20 09:47:41.687 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Detected FixedThemeResolver
2023-04-20 09:47:41.691 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Detected org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@2d73767e
2023-04-20 09:47:41.692 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Detected org.springframework.web.servlet.support.SessionFlashMapManager@17053b5
2023-04-20 09:47:41.692 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : enableLoggingRequestDetails='false': request parameters and headers will be masked to prevent unsafe logging of potentially sensitive data
2023-04-20 09:47:41.692 INFO 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 6 ms
2023-04-20 09:47:41.735 DEBUG 18940 --- [nio-8000-exec-1] org.apache.tomcat.util.http.Parameters : Set encoding to UTF-8
2023-04-20 09:47:41.735 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : POST "/position/addMyPerTrace/1/2/23.456789/12.345678/2023-04-19%2015:07:37/980/0", parameters={}
2023-04-20 09:47:41.760 DEBUG 18940 --- [nio-8000-exec-1] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to com.example.demo01.Controller.UserController#addPerTrace(Integer, Integer, Float, Float, String, String, Integer)
2023-04-20 09:47:41.813 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.method.HandlerMethod : Could not resolve parameter [4] in public int com.example.demo01.Controller.UserController.addPerTrace(java.lang.Integer,java.lang.Integer,java.lang.Float,java.lang.Float,java.lang.String,java.lang.String,java.lang.Integer): Required URI template variable 'TheFirstDate' for method parameter type String is not present
2023-04-20 09:47:41.828 WARN 18940 --- [nio-8000-exec-1] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingPathVariableException: Required URI template variable 'TheFirstDate' for method parameter type String is not present]
2023-04-20 09:47:41.831 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Completed 500 INTERNAL_SERVER_ERROR
2023-04-20 09:47:41.836 DEBUG 18940 --- [nio-8000-exec-1] o.a.c.c.C.[Tomcat].[localhost] : Processing ErrorPage[errorCode=0, location=/error]
2023-04-20 09:47:41.855 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : "ERROR" dispatch for POST "/error", parameters={}
2023-04-20 09:47:41.861 DEBUG 18940 --- [nio-8000-exec-1] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController#error(HttpServletRequest)
2023-04-20 09:47:41.951 DEBUG 18940 --- [nio-8000-exec-1] o.s.w.s.m.m.a.HttpEntityMethodProcessor : Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]
2023-04-20 09:47:41.953 DEBUG 18940 --- [nio-8000-exec-1] o.s.w.s.m.m.a.HttpEntityMethodProcessor : Writing [{timestamp=Thu Apr 20 09:47:41 CST 2023, status=500, error=Internal Server Error, path=/position/add (truncated)...]
2023-04-20 09:47:42.111 DEBUG 18940 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : Exiting from "ERROR" dispatch, status 500
2023-04-20 09:47:42.114 DEBUG 18940 --- [nio-8000-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Disabling the response for further output
2023-04-20 09:47:42.117 DEBUG 18940 --- [nio-8000-exec-1] o.apache.coyote.http11.Http11Processor : Socket: [org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@64c4289f:org.apache.tomcat.util.net.NioChannel@36e5d08b:java.nio.channels.SocketChannel[connected local=/127.0.0.1:8000 remote=/127.0.0.1:56776]], Status in: [OPEN_READ], State out: [CLOSED]
2023-04-20 09:47:42.118 DEBUG 18940 --- [nio-8000-exec-1] o.apache.tomcat.util.threads.LimitLatch : Counting down[http-nio-8000-exec-1] latch=1
2023-04-20 09:47:42.118 DEBUG 18940 --- [nio-8000-exec-1] org.apache.tomcat.util.net.NioEndpoint : Calling [org.apache.tomcat.util.net.NioEndpoint@5b5637b9].closeSocket([org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper@64c4289f:org.apache.tomcat.util.net.NioChannel@36e5d08b:java.nio.channels.SocketChannel[connected local=/127.0.0.1:8000 remote=/127.0.0.1:56776]])
2023-04-20 09:47:58.223 DEBUG 18940 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-04-20 09:47:58.224 DEBUG 18940 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-04-20 09:48:27.543 DEBUG 18940 --- [alina-utility-2] org.apache.catalina.session.ManagerBase : Start expire sessions StandardManager at 1681955307543 sessioncount 0
2023-04-20 09:48:27.545 DEBUG 18940 --- [alina-utility-2] org.apache.catalina.session.ManagerBase : End expire sessions StandardManager processingTime 2 expired sessions: 0
2023-04-20 09:48:28.239 DEBUG 18940 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-04-20 09:48:28.240 DEBUG 18940 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Fill pool skipped, pool is at sufficient level.
- 这篇博客: Springboot中调用外部接口的三种方式中的 postman测试 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
此处因为我使用了所在项目，所以需要添加一定的请求头等信息，关于Feign的请求头添加也会在后续补充
补充如下：