public Utente doRetrieveByIdPwd(String id, String pwd) throws PersistenceException { Utente utente = null; DataSource ds = new DataSource(); Connection connection = null; PreparedStatement statement = null; ResultSet result = null; try { connection = ds.getConnection(); String retrieve = "SELECT utente, pwd, isadmin,id FROM utenze WHERE utente=? and pwd=?"; statement = connection.prepareStatement(retrieve); statement.setString(1, id); statement.setString(2, pwd); result = statement.executeQuery(); if (result.next()) { utente = new Utente(); utente.setUser(id); utente.setPwd(result.getString("pwd")); utente.setIsAdmin(result.getBoolean("isadmin")); utente.setId(result.getInt("id")); utente.setNome(new ClienteDAOImpl().getClienteById(utente.getId()).getNome()); } } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } finally { try { if (result != null) result.close(); if (statement != null) statement.close(); if (connection != null) connection.close(); } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } } return utente; }
private void doInsert(Utente utente) throws PersistenceException { DataSource ds = new DataSource(); Connection connection = ds.getConnection(); PreparedStatement statement = null; try { String update = "insert into utenze (isadmin,pwd,utente,id) values (?,?,?,?)"; statement = connection.prepareStatement(update); statement.setBoolean(1, utente.getIsAdmin()); statement.setString(2, utente.getPwd()); statement.setString(3, utente.getUser()); statement.setInt(4, utente.getId()); statement.executeUpdate(); } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } finally { try { if (statement != null) statement.close(); if (connection != null) connection.close(); } catch (SQLException e) { throw new PersistenceException(e.getMessage()); } } }