UserDatabaseAdapter

package database;

import java.sql.SQLException;

import model.User;
import model.UserList;
import utils.ListADT;

public class UserDatabaseAdapter implements UserPersistence {
    private static final String SCHEMA = "viachat";
    private static final String DRIVER = "org.postgresql.Driver";
    private static final String URL = "jdbc:postgresql://localhost:5432/postgres?currentSchema=" + SCHEMA;
    private static final String USER = "postgres";
    private static final String PASSWORD = "1234";
    private MyDatabase db;

    public UserDatabaseAdapter() throws ClassNotFoundException {
        this.db = new MyDatabase(DRIVER, URL, USER, PASSWORD);
    }

    @Override
    public UserList loadUsers() throws SQLException {
        ListADT<Object[]> list = this.db.query("SELECT * FROM \"user\";");

        UserList userList = new UserList();

        for (int i = 0; i < list.size(); i++) {
            User user = new User().setUserID((int) list.get(i)[0])
                    .setUserType((String) list.get(i)[1])
                    .setUserName((String) list.get(i)[2])
                    .setPassword((String) list.get(i)[3])
                    .setEmail((String) list.get(i)[4])
                    .setGroupID((int) list.get(i)[5])
                    .setFullName((String) list.get(i)[6]);

            userList.addUser(user);
        }

        return userList;
    }

    @Override
    public int saveUser(User user) throws SQLException {
        return this.db.update("INSERT INTO \"user\" (usertype, username, password, email, group_id, fullname) VALUES (?, ?, ?, ?, ?, ?);"
                , user.getUserType(), user.getUserName(), user.getPassword(), user.getEmail(), user.getGroupID(), user.getFullName());
    }
}