class User, interface UsersDAO, class UsersDAOImpl

package com.itstep.mvn.app.model;


import java.sql.Timestamp;

import lombok.Data;

@Data
public class User {
    private int id;
    private String name;
    private String lastName;
    private int age;
    private String email;
    private int officeId;
    private int accId;
    private Timestamp createdTs;

    public User(int id, String name, String lastName, int age, String email, int officeId, int accId,
            Timestamp createdTs) {
        super();
        this.id = id;
        this.name = name;
        this.lastName = lastName;
        this.age = age;
        this.email = email;
        this.officeId = officeId;
        this.accId = accId;
        this.createdTs = createdTs;
    }


}


package com.itstep.mvn.app.jdbc.dao;

import java.util.List;

import com.itstep.mvn.app.model.User;

public interface UsersDAO {
    List<User> getAllUsers();
}





package com.itstep.mvn.app.jdbc.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;

import com.itstep.mvn.app.model.User;
import com.itstep.mvn.app.util.DBUtils;

public class UsersDAOImpl implements UsersDAO {

    @Override
    public List<User> getAllUsers() {
        List<User> users = new ArrayList<User>();
        Connection conn = DBUtils.getConnection();
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM test_db.USERS");
            while(rs.next()) {
                int id = rs.getInt(1);
                String name = rs.getString("NAME");
                String lastName = rs.getString("LAST_NAME");
                String email = rs.getString("EMAIL");
                int age = rs.getInt("AGE");
                int officeId = rs.getInt("OFFICE_ID");
                int accId = rs.getInt("acc_id");
                Timestamp createdTs = rs.getTimestamp(8);
                users.add(
                        new User(id, name, lastName, age,
                                email, officeId, accId, createdTs));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.release(conn, stmt, rs);
        }

        return users;
    }

}