{"id":827,"date":"2020-04-13T13:24:08","date_gmt":"2020-04-13T16:24:08","guid":{"rendered":"https:\/\/micheladrianomedeiros.com.br\/blog\/?p=827"},"modified":"2020-04-13T13:24:10","modified_gmt":"2020-04-13T16:24:10","slug":"web-services-restful-6","status":"publish","type":"post","link":"https:\/\/micheladrianomedeiros.com.br\/blog\/web-services-restful-6\/","title":{"rendered":"Web Services RESTful #6"},"content":{"rendered":"\n

Utilizando o projeto criado nesse artigo<\/a>, vamos conect\u00e1-lo ao banco de dados criado no artigo anterior<\/a>.<\/p>\n\n\n\n

Vou criar um novo pacote na pasta src com o nome de domain.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n

Vou criar uma classe com o nome BaseDAO no pacote domain. Nessa classe digite o seguinte c\u00f3digo:<\/p>\n\n\n\n

package br.com.micheladrianomedeiros.carros.domain;\n\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.SQLException;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class BaseDAO {\n\n    public BaseDAO() {\n        try {\n            Class.forName(\"com.mysql.cj.jdbc.Driver\");\n        } catch (ClassNotFoundException e) {\n            System.out.println(\"ERRO BaseDAO \" + e.getMessage());\n        }\n    }\n\n    protected Connection getConnection() {\n        Connection conn = null;\n        try {\n            String url = \"jdbc:mysql:\/\/localhost\/livro?serverTimezone=America\/Sao_Paulo\";\n            conn = DriverManager.getConnection(url, \"livro\", \"123\");\n        } catch (SQLException e) {\n            System.out.println(\"Erro getConnection \" + e.getMessage());\n        }\n        return conn;\n    }\n\n    public static void main(String[] args) {\n        try {\n            BaseDAO db = new BaseDAO();\n            Connection conn = db.getConnection();\n            System.out.println(conn);\n        } catch (Exception e) {\n            System.out.println(\"Erro main \" + e.getMessage());\n        }\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Modifique o arquivo pom.xml para ser adicionado o drive mysql no projeto.<\/p>\n\n\n\n
<dependencies>\n    <dependency>\n        <groupId>javax<\/groupId>\n        <artifactId>javaee-web-api<\/artifactId>\n        <version>8.0.1<\/version>\n        <scope>provided<\/scope>\n    <\/dependency>\n    <!-- https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java -->\n    <dependency>\n        <groupId>mysql<\/groupId>\n        <artifactId>mysql-connector-java<\/artifactId>\n        <version>8.0.19<\/version>\n    <\/dependency>\n<\/dependencies><\/code><\/pre>\n\n\n\n
Clique com o bot\u00e3o direito do mouse na pasta dependencies e escolha a op\u00e7\u00e3o Download Declared Dependencies, para baixar o drive.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Clique com o bot\u00e3o direito do mouse no arquivo BaseDAO e escolha a op\u00e7\u00e3o Run File. <\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Tentei utilizar o Java 14 mas n\u00e3o funcionou. O Java mais atual que funcionou foi o 9. Ent\u00e3o, utilize o 8 ou o 9 para fazer o projeto.<\/p>\n\n\n\n
Se tudo der certo a resposta no console vai ser parecido com essa.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Crie a classe Carro no pacote domain com o seguinte c\u00f3digo:<\/p>\n\n\n\n
package br.com.micheladrianomedeiros.carros.domain;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class Carro {\n\n    private long id;\n    private String nome;\n    private String descricao;\n    private String urlFoto;\n    private String urlVideo;\n    private String latitude;\n    private String longitude;\n    private String tipo;\n\n    public long getId() {\n        return id;\n    }\n\n    public void setId(long id) {\n        this.id = id;\n    }\n\n    public String getNome() {\n        return nome;\n    }\n\n    public void setNome(String nome) {\n        this.nome = nome;\n    }\n\n    public String getDescricao() {\n        return descricao;\n    }\n\n    public void setDescricao(String descricao) {\n        this.descricao = descricao;\n    }\n\n    public String getUrlFoto() {\n        return urlFoto;\n    }\n\n    public void setUrlFoto(String urlFoto) {\n        this.urlFoto = urlFoto;\n    }\n\n    public String getUrlVideo() {\n        return urlVideo;\n    }\n\n    public void setUrlVideo(String urlVideo) {\n        this.urlVideo = urlVideo;\n    }\n\n    public String getLatitude() {\n        return latitude;\n    }\n\n    public void setLatitude(String latitude) {\n        this.latitude = latitude;\n    }\n\n    public String getLongitude() {\n        return longitude;\n    }\n\n    public void setLongitude(String longitude) {\n        this.longitude = longitude;\n    }\n\n    public String getTipo() {\n        return tipo;\n    }\n\n    public void setTipo(String tipo) {\n        this.tipo = tipo;\n    }\n\n    @Override\n    public String toString() {\n        return \"Carro{\" + \"id=\" + id + \", nome=\" + nome + \", descricao=\"\n                + descricao + \", urlFoto=\" + urlFoto + \", urlVideo=\" + urlVideo\n                + \", latitude=\" + latitude + \", longitude=\" + longitude\n                + \", tipo=\" + tipo + '}';\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Crie um pacote com o nome tools e depois crie uma classe com o nome TratamentoConexao. Nessa classe digite o seguinte c\u00f3digo:<\/p>\n\n\n\n
package br.com.micheladrianomedeiros.carros.domain.tools;\n\nimport java.sql.Connection;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.util.logging.Level;\nimport java.util.logging.Logger;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class TratamentoConexao {\n\n    public static void fecharConexao(Connection con) {\n        if (con != null) {\n            try {\n                con.close();\n            } catch (SQLException ex) {\n                Logger.getLogger(TratamentoConexao.class.getName())\n                        .log(Level.SEVERE, null, ex);\n            }\n        }\n    }\n\n    public static void fecharConexaoEResultSet(Connection con, ResultSet rs) {\n        if (rs != null) {\n            try {\n                rs.close();\n            } catch (SQLException ex) {\n                Logger.getLogger(TratamentoConexao.class.getName())\n                        .log(Level.SEVERE, null, ex);\n            }\n        }\n        fecharConexao(con);\n    }\n\n    public static void fecharConexaoEPreparedStatement(\n            Connection con, PreparedStatement ps) {\n        if (ps != null) {\n            try {\n                ps.close();\n            } catch (SQLException ex) {\n                Logger.getLogger(TratamentoConexao.class.getName())\n                        .log(Level.SEVERE, null, ex);\n            }\n        }\n        fecharConexao(con);\n    }\n\n    public static void fecharConexaoEResultSetEPreparedStatement(\n            Connection con, ResultSet rs, PreparedStatement ps) {\n        if (rs != null) {\n            try {\n                rs.close();\n            } catch (SQLException ex) {\n                Logger.getLogger(TratamentoConexao.class.getName())\n                        .log(Level.SEVERE, null, ex);\n            }\n        }\n        if (ps != null) {\n            try {\n                ps.close();\n            } catch (SQLException e) {\n                Logger.getLogger(TratamentoConexao.class.getName())\n                        .log(Level.SEVERE, null, e);\n            }\n        }\n        fecharConexao(con);\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Crie a classe CarroDAO no pacote domain com o seguinte c\u00f3digo:<\/p>\n\n\n\n
package br.com.micheladrianomedeiros.carros.domain;\n\nimport br.com.micheladrianomedeiros.carros.domain.tools.TratamentoConexao;\nimport java.sql.Connection;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.sql.Statement;\nimport java.util.ArrayList;\nimport java.util.List;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class CarroDAO extends BaseDAO {\n\n    String selectCarroWhere = \"select * from carro where \";\n\n    public Carro createCarro(ResultSet rs) {\n        Carro c = new Carro();\n        try {\n            c.setId(rs.getLong(\"id\"));\n            c.setNome(rs.getString(\"nome\"));\n            c.setDescricao(rs.getString(\"descricao\"));\n            c.setUrlFoto(rs.getString(\"url_foto\"));\n            c.setUrlVideo(rs.getString(\"url_video\"));\n            c.setLatitude(rs.getString(\"latitude\"));\n            c.setLongitude(rs.getString(\"longitude\"));\n            c.setTipo(rs.getString(\"tipo\"));\n        } catch (SQLException e) {\n            System.out.println(\"Erro createCarro \" + e.getMessage());\n        }\n        return c;\n    }\n\n    public Carro getCarroById(long id) {\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        ResultSet rs = null;\n        try {\n            conn = getConnection();\n            stmt = conn.prepareStatement(selectCarroWhere + \"id = ?\");\n            stmt.setLong(1, id);\n            rs = stmt.executeQuery();\n            if (rs.next()) {\n                Carro c = createCarro(rs);\n                return c;\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro getCarroById \" + e.getMessage());\n        } finally {\n            TratamentoConexao\n                    .fecharConexaoEResultSetEPreparedStatement(conn, rs, stmt);\n        }\n        return null;\n    }\n\n    public List<Carro> findByName(String name) {\n        List<Carro> carros = new ArrayList<>();\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        ResultSet rs = null;\n        try {\n            conn = getConnection();\n            stmt = conn.prepareStatement(selectCarroWhere + \"nome like ?\");\n            stmt.setString(1, \"%\" + name + \"%\");\n            rs = stmt.executeQuery();\n            while (rs.next()) {\n                Carro c = createCarro(rs);\n                carros.add(c);\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro findByName \" + e.getMessage());\n        } finally {\n            TratamentoConexao\n                    .fecharConexaoEResultSetEPreparedStatement(conn, rs, stmt);\n        }\n        return carros;\n    }\n\n    public List<Carro> findByTipo(String tipo) {\n        List<Carro> carros = new ArrayList<>();\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        ResultSet rs = null;\n        try {\n            conn = getConnection();\n            stmt = conn.prepareStatement(selectCarroWhere + \"tipo = ?\");\n            stmt.setString(1, tipo);\n            rs = stmt.executeQuery();\n            while (rs.next()) {\n                Carro c = createCarro(rs);\n                carros.add(c);\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro findByTipo \" + e.getMessage());\n        } finally {\n            TratamentoConexao\n                    .fecharConexaoEResultSetEPreparedStatement(conn, rs, stmt);\n        }\n        return carros;\n    }\n\n    public List<Carro> getCarros() {\n        List<Carro> carros = new ArrayList<>();\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        ResultSet rs = null;\n        try {\n            conn = getConnection();\n            stmt = conn.prepareStatement(\"select * from carro\");\n            rs = stmt.executeQuery();\n            while (rs.next()) {\n                Carro c = createCarro(rs);\n                carros.add(c);\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro getCarros \" + e.getMessage());\n        } finally {\n            TratamentoConexao\n                    .fecharConexaoEResultSetEPreparedStatement(conn, rs, stmt);\n        }\n        return carros;\n    }\n\n    public static long getGeneratedId(Statement stmt) {\n        long id = 0L;\n        try {\n            ResultSet rs = stmt.getGeneratedKeys();\n            if (rs.next()) {\n                id = rs.getLong(1);\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro getGeneratedId \" + e.getMessage());\n        }\n        return id;\n    }\n\n    public void save(Carro c) {\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        try {\n            conn = getConnection();\n            if (c.getId() == 0) {\n                stmt = conn.prepareStatement(\"insert into carro \"\n                        + \"values(0,?,?,?,?,?,?,?)\",\n                        Statement.RETURN_GENERATED_KEYS);\n            } else {\n                stmt = conn.prepareStatement(\"update carro set nome = ?, \"\n                        + \"descricao = ?, url_foto = ?, url_video = ?, \"\n                        + \"latitude = ?, longitude = ?, tipo = ? \"\n                        + \"where id = ?\");\n            }\n            stmt.setString(1, c.getNome());\n            stmt.setString(2, c.getDescricao());\n            stmt.setString(3, c.getUrlFoto());\n            stmt.setString(4, c.getUrlVideo());\n            stmt.setString(5, c.getLatitude());\n            stmt.setString(6, c.getLongitude());\n            stmt.setString(7, c.getTipo());\n            if (c.getId() != 0) {\n                stmt.setLong(8, c.getId());\n            }\n            int count = stmt.executeUpdate();\n            if (count == 0) {\n                System.out.println(\"Erro ao inserir o carro\");\n            }\n            if (c.getId() == 0) {\n                long id = getGeneratedId(stmt);\n                c.setId(id);\n            }\n        } catch (SQLException e) {\n            System.out.println(\"Erro save Carro \" + e.getMessage());\n        } finally {\n            TratamentoConexao.fecharConexaoEPreparedStatement(conn, stmt);\n        }\n    }\n\n    public boolean delete(long id) {\n        boolean ok = false;\n        Connection conn = null;\n        PreparedStatement stmt = null;\n        try {\n            conn = getConnection();\n            stmt = conn.prepareStatement(\"delete from carro where id = ?\");\n            stmt.setLong(1, id);\n            int count = stmt.executeUpdate();\n            ok = count > 0;\n        } catch (SQLException e) {\n            System.out.println(\"Erro delete carro \" + e.getMessage());\n        } finally {\n            TratamentoConexao.fecharConexaoEPreparedStatement(conn, stmt);\n        }\n        return ok;\n    }\n}\n<\/code><\/pre>\n\n\n\n
Implementando o Data Access Object no Java EE<\/a><\/p>\n\n\n\n
Crie um pacote com o nome services e dentro desse pacote crie uma classe com o nome CarroService e digite o seguinte comando:<\/p>\n\n\n\n
package br.com.micheladrianomedeiros.carros.domain.services;\n\nimport br.com.micheladrianomedeiros.carros.domain.Carro;\nimport br.com.micheladrianomedeiros.carros.domain.CarroDAO;\nimport java.util.ArrayList;\nimport java.util.List;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class CarroService {\n\n    private final CarroDAO db = new CarroDAO();\n\n    public List<Carro> getCarros() {\n        try {\n            List<Carro> carros = db.getCarros();\n            return carros;\n        } catch (Exception e) {\n            return new ArrayList<>();\n        }\n    }\n\n    public Carro getCarro(long id) {\n        try {\n            return db.getCarroById(id);\n        } catch (Exception e) {\n            return null;\n        }\n    }\n\n    public boolean delete(long id) {\n        try {\n            return db.delete(id);\n        } catch (Exception e) {\n            return false;\n        }\n    }\n\n    public boolean save(Carro carro) {\n        try {\n            db.save(carro);\n            return true;\n        } catch (Exception e) {\n            return false;\n        }\n    }\n\n    public List<Carro> findByName(String name) {\n        try {\n            return db.findByName(name);\n        } catch (Exception e) {\n            return null;\n        }\n    }\n\n    public List<Carro> findByTipo(String tipo) {\n        try {\n            return db.findByTipo(tipo);\n        } catch (Exception e) {\n            return null;\n        }\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Vamos criar alguns testes, para ver se est\u00e1 tudo certo. Para isso, clique com o bot\u00e3o direito do mouse no pacote TestPackages e crie um JUnit Test.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Na pr\u00f3xima tela d\u00ea o nome da classe de CarroTest e no Package digite srctest.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Se voc\u00ea for at\u00e9 o arquivo pom.xml, voc\u00ea ver\u00e1 que tem novas depend\u00eancias adicionadas. Apague todas as depend\u00eancias adicionadas do junit e deixe dessa maneira:<\/p>\n\n\n\n
    <dependencies>\n        <!-- https:\/\/mvnrepository.com\/artifact\/org.junit.jupiter\/junit-jupiter-api -->\n        <dependency>\n            <groupId>org.junit.jupiter<\/groupId>\n            <artifactId>junit-jupiter-api<\/artifactId>\n            <version>5.6.2<\/version>\n            <scope>test<\/scope>\n        <\/dependency>\n        <dependency>\n            <groupId>javax<\/groupId>\n            <artifactId>javaee-web-api<\/artifactId>\n            <version>8.0.1<\/version>\n            <scope>provided<\/scope>\n        <\/dependency>\n        <!-- https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java -->\n        <dependency>\n            <groupId>mysql<\/groupId>\n            <artifactId>mysql-connector-java<\/artifactId>\n            <version>8.0.19<\/version>\n        <\/dependency>\n    <\/dependencies><\/code><\/pre>\n\n\n\n
Deve-se tamb\u00e9m adicionar o plugin maven-surefire-plugin. Veja como ficou os meus plugins:<\/p>\n\n\n\n
        <plugin>\n            <groupId>org.apache.maven.plugins<\/groupId>\n            <artifactId>maven-surefire-plugin<\/artifactId>\n            <version>3.0.0-M4<\/version>\n        <\/plugin>\n\n        <plugin>\n            <groupId>org.apache.maven.plugins<\/groupId>\n            <artifactId>maven-compiler-plugin<\/artifactId>\n            <version>3.8.1<\/version>\n            <configuration>\n                <source>9<\/source>\n                <target>9<\/target>\n                <compilerArguments>\n                    <endorseddirs>${endorsed.dir}<\/endorseddirs>\n                <\/compilerArguments>\n            <\/configuration>\n        <\/plugin>\n        <plugin>\n            <groupId>org.apache.maven.plugins<\/groupId>\n            <artifactId>maven-war-plugin<\/artifactId>\n            <version>3.2.3<\/version>\n            <configuration>\n                <failOnMissingWebXml>false<\/failOnMissingWebXml>\n            <\/configuration>\n        <\/plugin>\n        <plugin>\n            <groupId>org.apache.maven.plugins<\/groupId>\n            <artifactId>maven-dependency-plugin<\/artifactId>\n            <version>3.1.2<\/version>\n            <executions>\n                <execution>\n                    <phase>validate<\/phase>\n                    <goals>\n                        <goal>copy<\/goal>\n                    <\/goals>\n                    <configuration>\n                        <outputDirectory>${endorsed.dir}<\/outputDirectory>\n                        <silent>true<\/silent>\n                        <artifactItems>\n                            <artifactItem>\n                                <groupId>javax<\/groupId>\n                                <artifactId>javaee-endorsed-api<\/artifactId>\n                                <version>7.0<\/version>\n                                <type>jar<\/type>\n                            <\/artifactItem>\n                        <\/artifactItems>\n                    <\/configuration>\n                <\/execution>\n            <\/executions>\n        <\/plugin>\n    <\/plugins>\n<\/build><\/code><\/pre>\n\n\n\n
Vou criar um teste para procurar alguns carros e ver se est\u00e1 tudo certo. O c\u00f3digo ficou assim:<\/p>\n\n\n\n
package srctest;\n\nimport br.com.micheladrianomedeiros.carros.domain.Carro;\nimport br.com.micheladrianomedeiros.carros.domain.services.CarroService;\nimport java.util.List;\nimport static org.junit.jupiter.api.Assertions.assertEquals;\nimport static org.junit.jupiter.api.Assertions.assertNotNull;\nimport static org.junit.jupiter.api.Assertions.assertTrue;\nimport org.junit.jupiter.api.Test;\n\n\/**\n *\n * @author michel adriano medeiros\n *\/\npublic class CarroTest {\n\n    private CarroService carroService = new CarroService();\n\n    @Test\n    public void procurarCarros() {\n        List<Carro> carros = carroService.getCarros();\n        assertNotNull(carros);\n        assertTrue(carros.size() > 0);\n        Carro tucker = carroService.findByName(\"Tucker 1948\").get(0);\n        assertEquals(\"Tucker 1948\", tucker.getNome());\n        Carro ferrari = carroService.findByName(\"Ferrari FF\").get(0);\n        assertEquals(\"Ferrari FF\", ferrari.getNome());\n        Carro bugatti = carroService.findByName(\"Bugatti Veyron\").get(0);\n        assertEquals(\"Bugatti Veyron\", bugatti.getNome());\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
Para executar o teste, clique com o bot\u00e3o direito do mouse no arquivo de teste que se chama CarroTest e escolha a op\u00e7\u00e3o Test File.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Se estiver tudo certo, o resultado ser\u00e1 esse:<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Vamos criar um teste que salve um carro, busque os dados desse carro e modifique os dados, e por fim apague o carro. \u00c9 o famoso CRUD. O m\u00e9todo ficou assim:<\/p>\n\n\n\n
    @Test\n    public void crud() {\n        \/\/Criar carro (fase Create)\n        Carro c = new Carro();\n        c.setNome(\"Teste\");\n        c.setDescricao(\"teste descri\u00e7\u00e3o\");\n        c.setUrlFoto(\"url foto teste\");\n        c.setUrlVideo(\"url v\u00eddeo teste\");\n        c.setLatitude(\"lat teste\");\n        c.setLongitude(\"lon teste\");\n        c.setTipo(\"tipo teste\");\n        carroService.save(c);\n        \/\/Buscar carro salvo (fase Read)\n        long id = c.getId();\n        assertNotNull(id);\n        c = carroService.getCarro(id);\n        assertEquals(\"Teste\", c.getNome());\n        assertEquals(\"teste descri\u00e7\u00e3o\", c.getDescricao());\n        assertEquals(\"url foto teste\", c.getUrlFoto());\n        assertEquals(\"url v\u00eddeo teste\", c.getUrlVideo());\n        assertEquals(\"lat teste\", c.getLatitude());\n        assertEquals(\"lon teste\", c.getLongitude());\n        assertEquals(\"tipo teste\", c.getTipo());\n        \/\/Atualiza dados do carro (fase Upadate)\n        c.setNome(\"Teste UPDATE\");\n        carroService.save(c);\n        \/\/Verificar se realmente os dados foram atualizados\n        c = carroService.getCarro(id);\n        assertEquals(\"Teste UPDATE\", c.getNome());\n        \/\/Deletar o carro (fase Delete)\n        carroService.delete(id);\n        \/\/Buscar o carro para ver se foi realmente removido\n        c = carroService.getCarro(id);\n        \/\/Confirma\u00e7\u00e3o de que o carro foi removido\n        assertNull(c);\n    }<\/code><\/pre>\n\n\n\n
Teste novamente, os dois m\u00e9todos implementados devem estar corretos.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Agora est\u00e1 tudo certo.<\/p>\n\n\n\n
\n