@ResponseBody
@RequiresPermissions("msg:msgInner:view")
@RequestMapping(value = {"test", ""})
public String test(HttpServletRequest request){
int value1 = 1;
int value2 = 1;
int value3 = 1;
try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jeesite", "root", "282469907");
Statement statement = connection.createStatement()){
statement.executeUpdate("UPDATE jeesite.cfpdata SET 衣 = " + request.getParameter("value1"));
statement.executeUpdate("UPDATE jeesite.cfpdata SET 食 = " + request.getParameter("value2"));
statement.executeUpdate("UPDATE jeesite.cfpdata SET 住 = " + request.getParameter("value3"));
statement.executeUpdate("UPDATE jeesite.cfpdata SET 行 = " + request.getParameter("value4"));
statement.executeUpdate("UPDATE jeesite.cfpdata SET 用 = " + request.getParameter("value5"));
statement.executeUpdate("UPDATE jeesite.cfpdata SET 总计 = " + request.getParameter("value6"));
statement.executeBatch();
}catch (SQLException e){
e.printStackTrace();
}
return request.getParameter("value1");
}
数据库获取不了对应的value值,只能获取第一个,其他都为null是为什么?