java - 使用 Angular js、Spring、hibernate 一次保存大量行

Question

我发布的代码片段工作正常，值正在保存到数据库中。但实际上我需要的是一次性保存行列表。我如何使用 Angularjs 更新每一行来实现这一点。希望有人能帮助我解决这个问题。

UI View 的

引用链接

https://www.codeproject.com/Tips/1028442/Bulk-Upload-in-AngularJS

analysis.html

<select ng-model="analysis.state" ng-options="state.stateName as state.stateName for state in stateList" x-ng-change="updateDistrict(analysis.state)">
<option value="">Select State</option>
</select>
<select ng-model="analysis.itemName"  ng-options="product.itemName as product.itemName for product in itemList">
<option value="">Select Item</option>
</select>

<input name="minimumPrice" ng-model="analysis.minimumPrice" placeholder="Minimum Price" required />
<input name="maximumPrice" ng-model="analysis.maximumPrice" placeholder="Maximum Price" required />
<input type="submit" name="Submit" class="btn btn-primary" value="Submit" /> 

saveController.js

scope.saveAnalysis = function(analysis) {
    Repository.saveAnalysis(analysis)
        .then(function(response) {
                var status = response.statusMessage;
                    if (status = "success") {
                        alert("Record added successfully....!!");
                        state.go('analyserhome');
                        } else {
                        alert("Details Saving Fail...!!")
                        state.go("home");
                }
            });
        };

Repository.js新增代码

this.saveAnalysis = function(analysis){

var defer = $q.defer(); 
//defer is units of work,promise is data from those defer
rootScope.marketPrice = [{
    "itemName" : "xyz",
    "minimumPrice" : "111",
    "maximumPrice" : "222",
    "marketName":"xyz",
    "unitofPrice":"xyz",
    "category":"xyz",
    "marketPlace":"xyz",
    "state":"xyz",
    "district":"xyz"
},{
    "itemName" : "xyz",
    "minimumPrice" : "555",
    "maximumPrice" : "666",
    "marketName":"xyz",
    "unitofPrice":"xyz",
    "category":"xyz",
    "marketPlace":"xyz",
    "state":"xyz",
    "district":"xyz"
}];
var analysisPromise = http.post('/project/saveAnalysis/',rootScope.marketPrice);

analysisPromise.then(function(response){ 
    analysis =response.data;
    defer.resolve(analysis);
});
return defer.promise;

};

价格.java

public class MarketPrice {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "itemId")
private Long itemId;

@Column(name = "itemName")
private String itemName;

@Column(name = "minimumPrice",columnDefinition = "Float(10,2)")
private Float minimumPrice;

@Column(name = "maximumPrice",columnDefinition = "Float(10,2)")
private Float maximumPrice;

@Column(name = "state")
private String state;

//getters and setters

保存分析.java//我在 Controller 中所做的更改

@RequestMapping(value = {"/saveAnalysis"} , method = RequestMethod.POST)
@ResponseBody
public MarketPrice bulkSaveMarketAnalysis(@RequestBody 
        List<MarketPrice> marketPrices, HttpServletResponse response,
        HttpServletRequest request){

    MarketPrice marketPrice1 = new MarketPrice();
    System.out.println("List data:"+marketPrices.get(0)+""+marketPrices);
    String marketDataResponse = analyserService.saveListOfMarketPrice(marketPrices);
    System.out.println(marketDataResponse);
    marketPrice1.setStatusMessage("success");
    return marketPrice1;
}

}

保存AnalysisDAO.java

public String saveListOfMarketPrice(List<MarketPrice> marketPrices) {
    System.out.println("In Analyser DAO fro bulk saving");
    final Session session = getSession();
    session.beginTransaction();
    for (MarketPrice price : marketPrices) {
        System.out.println("In save method using for each loop");
        session.save(price);
        session.getTransaction().commit();
        return "success";
    }
    return null;
}

当用户输入他的所有数据时，整个列表应该保存到数据库中。但是这里的状态只会被选择一次，并且会更新到每一行。

在将 2 条记录的列表传递给 Controller ​​之后。并且只有一条记录保存到数据库中。即每个循环只执行一次。

我现在面临的主要问题是值应该来自 html 页面

提前谢谢你。

Answer 1

您可以重构您的后端以获得批量更新解决方案。

---

前端

在您的前端应用程序中，创建一个包含市场价格列表的有效 json。

例如有效对象 ->

var analysis = [
    {
        "state": "A",
        "itemName": "Test#1",
        "minimumPrice": 11.2,
        "maximumPrice": 10.2
    },
    {
        "state": "A",
        "itemName": "Test#2",
        "minimumPrice": 11.2,
        "maximumPrice": 10.2
    },
    {
        "state": "A",
        "itemName": "Test#3",
        "minimumPrice": 11.2,
        "maximumPrice": 10.2
    }
];

在您的发布请求正文(数据)上发送一个包含市场价格数组的 Json。

存储库片段

saveAnalysis = function(analysis)   {
    $http({
        url: 'request-url',
        method: 'POST',
        data: analysis
        })
    .then(function(response)    {
    //HANDLE success
    }, function(errorResponse)  {
    //HANDLE error
    });
};

---

后端

在您的 Controller 上创建一个接收市场价格列表的新方法。

保存分析

@RequestMapping(value = {"/bulkSsaveAnalysis"} , method = RequestMethod.POST)
@ResponseBody
public Response bulkSaveMarketAnalysis(@RequestBody List<MarketPrice> marketPrices, HttpServletResponse response, HttpServletRequest request)

服务层:

隔离您的验证方法(如果存在)，以便您可以将其重新用于单个对象或列表。然后，创建一个接收列表的新方法，并在数据库中一个一个地创建一个新行。

for(MarketPrice price : martketPrices)  {
    //call your validation or helpers methods
    //Here you have to choose what to do on fail scenario
    saveAnalysisDAO.saveMarketPrice(price);
}

这个设计有个问题:任意一个交易失败怎么办？你应该回滚所有人吗？您是否应该存储错误并向前端发送一个新列表，其中包含失败的错误和成功的错误？

您必须选择对您的应用程序进行错误处理的最佳方案。