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;
	}

}