Код: Выделить всё
@Override
public List getAllUsers() {
User user = new User();
List ulist = new ArrayList();
String query = "select * from user";
try {
dataBaseConnection.pstmt = dataBaseConnection.conn.prepareStatement(query);
dataBaseConnection.rs = dataBaseConnection.pstmt.executeQuery();
while ( dataBaseConnection.rs.next() ) {
ulist.add(new User(dataBaseConnection.rs.getInt(1),
dataBaseConnection.rs.getString(2),
dataBaseConnection.rs.getString(3),
dataBaseConnection.rs.getString(4),
dataBaseConnection.rs.getString(5),
dataBaseConnection.rs.getString(6),
dataBaseConnection.rs.getInt(7),
dataBaseConnection.rs.getInt(8)
));
}
System.out.println("getting all users successfully...");
} catch (Exception e) {
e.printStackTrace();
}
return ulist;
}
Код: Выделить всё
@GetMapping("/get-all-user")
public List fetchUsers() {
List users = new ArrayList();
users = this.userService.getAllUsers();
return users;
}
он выдает следующий результат:
Код: Выделить всё
[
{
"userName": null,
"userEmail": null,
"userPassword": null,
"userState": null,
"userCity": null,
"userId": 0,
"userAge": 0,
"userMobile": 0
},
{
"userName": null,
"userEmail": null,
"userPassword": null,
"userState": null,
"userCity": null,
"userId": 0,
"userAge": 0,
"userMobile": 0
}
]
Подробнее здесь: https://stackoverflow.com/questions/785 ... sql-im-cre