如何检索表中的数据?PostgreSQL， AngularJS1， Spring， Hibernate.

Question

在我的数据库中，我有姓氏和名字。我将它们收集在一个数组中;我的变量 lastAndFirstNameList 包含：例如：[name, first name] => ( ["WOOD", "Robin"])

然后，我尝试使用变量 lastname 和 firstname 分别检索姓氏和名字。我得到的结果«姓氏未定义»和«名字未定义»。我不明白为什么！你能帮我吗？

enter code here : //controller.js
Employee.getFirstAndLastName().$promise.then(function(result) {
var lastAndFirstNameList = result.list; 
var lastname = lastAndFirstNameList.lastName;
var firstname = lastAndFirstNameList.firstName;
for(var k = 0; k < lastAndFirstNameList.length; k++)
{
console.log("lastname", lastname);
console.log("firstname", firstname);
}

console.log("lastAndFirstNameList", lastAndFirstNameList);
}

....

enter code here daoImpl.java
@SuppressWarnings("unchecked")
@Override
public List<Object> getFirstAndLastName() {
SQLQuery querySQL = sessionFactory.getCurrentSession().createSQLQuery("select last_name, first_name from employee");
List<Object> firstAndLastNameList = querySQL.list();
return firstAndLastNameList;
}

Answer 1

这能给你带来什么？ 我不认为"名字"和"姓氏"会给你任何东西，因为它们没有正确引用。

Employee.getFirstAndLastName().$promise.then(function(result) {
var lastAndFirstNameList = result.list; 
var lastname = lastAndFirstNameList.lastName;
var firstname = lastAndFirstNameList.firstName;
console.log("lastname ", lastname);
console.log("firstname ", firstname);
console.log("lastAndFirstNameList", lastAndFirstNameList);
}

将上面的引用变量更改为如下所示：

var lastname = lastAndFirstNameList[0].lastName;
var firstname = lastAndFirstNameList[0].firstName;

如果从服务器正确传递，这应该为您提供第一个值。

然后，您的循环应如下所示：

for(var k = 0; k < lastAndFirstNameList.length; k++){
console.log("lastname", lastAndFirstNameList[k].lastName);
console.log("firstname", firstname[k].firstName);
}