USers

package org.bildit.dao.dto;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.bildit.dao.ConnectionManager;

public class UsersDaoImpl implements UserDao {

	Connection con = ConnectionManager.getInstance().getConnection();

	@Override
	public boolean create(Users user) throws SQLException {
		String query = "insert into person(username, password, role) values (?,?,?) ";

		try (PreparedStatement statement = con.prepareStatement(query)) {
			statement.setString(1, user.getUsername());
			statement.setString(2, user.getPassword());
			statement.setString(3, user.getRole());

			statement.executeUpdate();
		}
		return false;
	}

	@Override
	public Users read(int id) throws SQLException {
		Users users = null;

		String query = "select * from person where id = ?";

		ResultSet res = null;

		try (PreparedStatement statement = con.prepareStatement(query)) {
			statement.setInt(1, id);

			res = statement.executeQuery();

			if (res.next()) {
				users = new Users(res.getInt("id"), res.getString("username"), res.getString("password"),
						res.getString("role"));
			}

			res.close();

		}

		return users;
	}

	@Override
	public List<Users> readAll() throws SQLException {
		List<Users> users = new ArrayList<>();

		String query = "select * from person";

		ResultSet res = null;

		try(PreparedStatement statement = con.prepareStatement(query)){

			res = statement.executeQuery();

			while(res.next()){

				users.add(new Users(res.getInt("id"), res.getString("username"), res.getString("password"),
						res.getString("role")));


			}
			res.close();
		}

		return users;
	}

	@Override
	public boolean update(Users user) throws SQLException {
		String query = "Update person set username = ?, password = ?, role = ? where id = ?";

		try(PreparedStatement statement = con.prepareStatement(query)){
			statement.setString(1, user.getUsername());
			statement.setString(2, user.getPassword());
			statement.setString(3, user.getRole());
			statement.setInt(4, user.getId());

			statement.executeUpdate();
		}
		return true;
	}

	@Override
	public boolean delate(Users user) throws SQLException {
		String query = "DELETE FROM person WHERE id = ?";

		try(PreparedStatement statement = con.prepareStatement(query)){
			statement.setInt(1, user.getId());

			statement.executeUpdate();

		}
		return true;
	}

}