使用Ajax Get方法在前端检索Mongodb数据

Question

我在mongodb中插入了一个数据，并使用nodejs编写API，需要在前端使用jquery检索这些数据。我在mongodb中插入了3行数据。我已经使用下面的代码来获取数据，它工作得很好，但它是硬编码的。我希望它发生手动使用jquery。请帮忙解决这个问题。

$.ajax({
dataType:"json",
url: "/purchaser/purchasersList",
type:"GET",
global:false,
async:false,
success: function(response){
console.log("response is:",response);
document.getElementById("userName").innerHTML = (response[0].userName);
document.getElementById("email_id").innerHTML=(response[0].email_id);
document.getElementById("address").innerHTML=(response[0].address);
document.getElementById("phoneNumber").innerHTML=(response[0].phoneNumber);
//2nd row data
document.getElementById("userName1").innerHTML = (response[1].userName);
document.getElementById("email_id1").innerHTML=(response[1].email_id);
document.getElementById("address1").innerHTML=(response[1].address);
document.getElementById("phoneNumber1").innerHTML=(response[1].phoneNumber);
//3rd row data
document.getElementById("userName2").innerHTML = (response[2].userName);
document.getElementById("email_id2").innerHTML = (response[2].email_id);
document.getElementById("address2").innerHTML = (response[2].address);
document.getElementById("phoneNumber2").innerHTML =(response[2].phoneNumber);

},

error: function (jqXHR, textStatus, errorThrown) { // error callback    
console.log("Error Response jqXHR is:" + jqXHR);e

<table class = table2>
<tr>
<th  style="text-align:center">SL.No</th> 
<th style="text-align:center">Purchaser Name</th>
<th style="text-align:center">Email</th> 
<th style="text-align:center">Address</th>
<th style="text-align:center">Phone No</th>
</tr> 
<tr>

<td height="50">1</td>
<td height="50" id="userName"></td>
<td height="50" id="email_id"></td>
<td height="50" id="address"></td>
<td height="50" id="phoneNumber"></td>
<td height="50">Active</td>
</tr> 
<tr>
..
</tr>

Answer 1

如果你可以将id更改为class，那么我建议你尝试这样做:

$.each(response,function(i) {
var tr = $('.table2 tr').eq((i+1));
$(tr).find(".userName").text(response[i].userName)
$(tr).find(".email_id").text(response[i].email_id)
$(tr).find(".address").text(response[i].address)
$(tr).find(".phoneNumber").text(response[i].phoneNumber)
})

注意我不能测试它，因为我没有你的回应。

完整代码

$.ajax({
dataType: "json",
url: "/purchaser/purchasersList",
type: "GET",
global: false,
async: false,
success: function(response) {
$.each(response,function(i) {
var tr = $('.table2 tr').eq((i+1));
$(tr).find(".userName").text(response[i].userName)
$(tr).find(".email_id").text(response[i].email_id)
$(tr).find(".address").text(response[i].address)
$(tr).find(".phoneNumber").text(response[i].phoneNumber)
})
},

error: function(jqXHR, textStatus, errorThrown) { // error callback    
console.log("Error Response jqXHR is:" + jqXHR);
e

<table class=table2>
<tr>
<th style="text-align:center">SL.No</th>
<th style="text-align:center">Purchaser Name</th>
<th style="text-align:center">Email</th>
<th style="text-align:center">Address</th>
<th style="text-align:center">Phone No</th>
</tr>
<tr>
<td height="50">1</td>
<td height="50" class="userName"></td>
<td height="50" class="email_id"></td>
<td height="50" class="address"></td>
<td height="50" class="phoneNumber"></td>
<td height="50">Active</td>
</tr>
<tr>
..
</tr>