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
<insert id="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})
</insert>
//实体类
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