有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

javascript Ajax请求在springmvc项目中不起作用

我正在制作Spring-Mvc project。我使用DAOCONTROLLER获取DB数据并设置输出

我的观点由JSPJS组成

我必须把DB数据放入JS文件中。所以我试图通过Ajax解决它,但失败了

刀。java

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.stereotype.Service;

import net.point.service.game.config.SqlSessionFactoryDao;


@Service
public class ADao {

    private SqlSessionFactory sqlSessionFactory;

    public ADao() {
        sqlSessionFactory = SqlSessionFactoryDao.getSqlSessionFactory();
    }




    public List<Map<Object,Object>> selectAllPayment() {
        SqlSession session = sqlSessionFactory.openSession();
        List<Map<Object,Object>> payments = new ArrayList<Map<Object, Object>>();
        try {
        payments =  session.selectList("AdminPaymentDao.selectAllPayment");
        System.out.println("payments: " + payments);
        System.out.println("-----------------------------------------------------");
        }catch (Exception error) {
            error.printStackTrace();
        } finally {
            session.close();
        }
        return payments;
    }

}

控制器。java

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import ch.qos.logback.classic.Logger;
import net.point.service.game.admin.payment.collection.ADao;

@Controller
public class Controller {

    private static Logger logger =  (Logger) LoggerFactory.getLogger(AdminPaymentController.class);

    @Autowired
    ADao aDao;

    @ResponseBody
    @RequestMapping(value="/adminRequestCharge", method = RequestMethod.POST)
    public  Map<String, Object> selectAllPayment() {
        Map<String, Object> result = new HashMap<String, Object>();
        logger.info("selectAllPayment start~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~");
        System.out.println("gggggggggggggggggggggggggggggggggggggggggggggg");
        try {
        List<Map<Object, Object>> resultList = new ArrayList<Map<Object, Object>>();
        resultList = aDao.selectAllPayment();
        for (Object list : resultList) {
            System.out.println("resultList:" + resultList);
        }
        result.put("jqgrid_data", resultList);
        }catch (Exception error) {
            error.printStackTrace();
        }
        return result;
    }

}

js文件

$(function(){

    //ajax
    $("#chargeRequestList").submit(function() {

        let queryData = $(this).serialize();

        $.ajax({
            url:"/adminRequestCharge",
            type: "POST",
            dataType: "json"
            data: queryData
            success: function(result) {
                console.log(result);
            }
        })
    })


    setRequestList(jqgrid_data);

    // grid resize
    $(window).on('resize.jqGrid', function() {
        $("#chargeRequestList").jqGrid('setGridWidth', $(".grid-cover").width());
    })

});



function setRequestList(jqgrid_data){
    jQuery("#chargeRequestList").jqGrid({
        data : jqgrid_data,
...

我想要的价值形式:

var jqgrid_data = [{
    seq: '1512',
    status : '0',
    value : '10,000',
    purchase_means : '1001',
    paid : '20',
    reg_date : '2019-06-24 12:43:33',
    pay_status : '0',
    paid_date : '2019-06-08 10:33:23',
    func : '1'
},
{
...
}

有许多事情我以前从来都不熟悉springs,但我对JavaAjax并不完全熟悉

这可能是一个基本的错误,因为有很多东西是缺乏的

我需要你的帮助

提前谢谢


共 (2) 个答案

  1. # 1 楼答案

    来自示例ajax数据集:

    [
    {
       seq: '1512',
        status : '0',
        value : '10,000',
        purchase_means : '1001',
        paid : '20',
        reg_date : '2019-06-24 12:43:33',
        pay_status : '0',
        paid_date : '2019-06-08 10:33:23',
        func : '1'
        },
        ....
        ]
    

    现在创建一个类,用jsonObject i,e的键的相同名称声明它的字段

    public class YourDto{
       private String seq;
       private String status;
       ....
       ...
    }
    

    现在用以下内容替换控制器方法声明:

     @ResponseBody
        @RequestMapping(value="/adminRequestCharge", method = RequestMethod.POST)
        public  Map<String, Object> selectAllPayment(HttpServletRequest request, @RequestBody List<YourDto> yourDataList, HttpServletResponse response) {
        //your logic here;
        .....
    }
    

    希望这有帮助

  2. # 2 楼答案

    您必须插入url以匹配控制器的值,如下面的代码所示。url不能等于视图的值

    $.ajax({
    url:"/ChargeData",
    type: “POST”,
    dataType: “json”,
    data: data,
    success: function(result) {
    console.log(result.jqgrid_data);    
    setRequestList(result.jqgrid_data)
    }
    })