java - 收到json数据如何传入变量Jsp Page

Question

我正在jsp中创建一个简单的销售系统。我想将数据添加到数据库中。我不知道如何将数据检索到jsp页面中。这是我传递数据函数的方式:

var data = "&items=" + JSON.stringify((items));

$.ajax({
    type: "POST",
    url: "sales_add.jsp",
    dataType: 'JSON',
    data: data,

数据已成功传递 - 我通过控制台进行了检查。

这是我在 jsp 页面上检索数据的方式:

String[] json =request.getParameterValues("items"); 

for(int x = 0; x < json.length; x++)
{
    String item = json[x][0]);
    String price = json[x][1]);
    String qty = json[x][2]);
    String $total = json[x][3]);
}

这段代码不起作用

所有销售都应添加此表数据。我将发送到 sales_add.jsp 页面。我是这样检查的

console.log(JSON.stringify(items)); 

这是我的完整代码:

function add_product_to_array(item, price,qty, tot)
{
    var item = [item, price,qty, tot];
    items.push(item);
    console.log(JSON.stringify(items));
}

我通过 Console.log 检查的表它成功显示如下

[["巧克力",32,"1",32]](索引):237 [["巧克力",32,"1",32],["芒果",10,"1",10]]我以这种方式发送 **var data = "&items="+ JSON.stringify((items)) 到 sales.add.jsp 页面

function addProject()
{
    var data = "&items=" + JSON.stringify((items));
    $.ajax({
        type: "POST",
        url: "sales_add.jsp",
        dataType: 'JSON',
        data: data,
        success: function (data) {
            console.log(_data);

            alert("Success");
        },

        error: function (xhr, status, error) {
            alert(xhr);
            console.log(xhr.responseText);

        }

    });
}

我这样编辑Jsp页面:

String jsonData = request.getParameter("data");

先生，这个格式

[{"item":"巧克力","price":"巧克力","pro_price":"32","qty":"1","total":"32"},{"item":"巧克力","价格":"巧克力","pro_price":"32","数量":"1","总计":"32"},{"item":"巧克力","价格":"巧克力","pro_price":"32","数量":"1","总计":"32"},{"item":"巧克力","price":"巧克力","pro_price":"32","数量":"1","总计":"32"}]

 Connection con1;
PreparedStatement insert;
Class.forName("com.mysql.jdbc.Driver");   
   con1=DriverManager.getConnection("jdbc:mysql://localhost/icepos","root","");        

 for(int x = 0; x < jsonData .length; x++)
        {

              String query = "INSERT INTO sale_product(item,price,qty,total) VALUES (?,?,?,?)";

            String   item = jsonData [x]['item']);
            String  price = jsonData [x]['price']);
            String   qty = jsonData [x]['qty']);
            String  total = jsonData [x]['total']);


        }

但是先生不工作

Answer 1

//below in HTML part
<input type="hidden" value='<%=request.getAttribute("items") %>' id='items' name='items'>

//below in js part
<script>
let jsonItems=docuement.querySelector('items').value;//now jsonItems item //carry the recived data , using these js function to reFormat the data 
//JSON.stringify() or JSON.parse() based on what you want to do
<script>