search

Scarpah600 / BIBLIOTECA-BACKUP-JAVA

0 stars 0 forks source link

bibilioteca (bean,dao,domain,factory,util) #1

Open Scarpah600 opened 5 years ago

Scarpah600 commented 5 years ago

SELECT UPDATE DELETE ETC.. SQL

package br.com.Filmes.DAO;

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

import br.com.Filmes.domain.Filmes; import br.com.Filmes.factory.ConexaoFactory;

public class FilmesDao {

public void salvar(Filmes f) throws SQLException {
    StringBuilder sql = new StringBuilder();
    sql.append("INSERT INTO db_filmes ");
    sql.append("(NOME_FILMES, GENERO_FILMES, DATA_FILMES, DESCRICAO_FILMES)");
    sql.append("VALUES (?,?,?,?) ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setString(1, f.getN_FILMES());
    comando.setString(2, f.getGENE_FILMES());
    comando.setString(3, f.getData_Filmes());
    comando.setString(4, f.getDesc_Filmes());
    comando.executeUpdate();

}

public void alterar(Filmes f) throws SQLException {
    StringBuilder sql = new StringBuilder();
    sql.append("UPDATE db_filmes ");
    sql.append("SET NOME_FILMES = ? , GENERO_FILMES = ? , DATA_FILMES = ? , DESCRICAO_FILMES = ? ");
    sql.append("WHERE ID = ? ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setLong(5, f.getID_FILMES());
    comando.setString(1, f.getN_FILMES());
    comando.setString(2, f.getGENE_FILMES());
    comando.setString(3, f.getData_Filmes());
    comando.setString(4, f.getDesc_Filmes());
    comando.executeUpdate();
}

// DELETE FROM `dtb_filmes`.`db_filmes` WHERE (`ID` = '5');

public void deletar(Filmes f) throws SQLException {
    StringBuilder sql = new StringBuilder();
    sql.append("DELETE FROM  db_filmes ");
    sql.append("WHERE ID = ? ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setLong(1, f.getID_FILMES());

    comando.executeUpdate();
}

public Filmes BuscarFilmes(Filmes f) throws SQLException {
    StringBuilder sql = new StringBuilder();
    sql.append("SELECT ID, NOME_FILMES ");
    sql.append("FROM db_filmes ");
    sql.append("WHERE ID = ? ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setLong(1, f.getID_FILMES());

    ResultSet resultado = comando.executeQuery();
    Filmes retorno = null;

    if (resultado.next()) {
        retorno = new Filmes();
        retorno.setID_FILMES(resultado.getLong("ID"));
        retorno.setN_FILMES(resultado.getString("NOME_FILMES"));
    }

    return retorno;

}

public ArrayList<Filmes>buscarPorNome(Filmes f) throws SQLException
{
    StringBuilder sql = new StringBuilder();
    sql.append("SELECT ID, NOME_FILMES ");
    sql.append("FROM db_filmes ");
    sql.append("WHERE NOME_FILMES LIKE ? ");
    sql.append("ORDER BY NOME_FILMES ASC ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());

    comando.setString(1, "%" + f.getN_FILMES() + "%");
    ResultSet resultado = comando.executeQuery();
    ArrayList<Filmes> lista = new ArrayList<Filmes>();

    while (resultado.next()) {
        Filmes filme = new Filmes();
        filme.setID_FILMES(resultado.getLong("ID"));
        filme.setN_FILMES(resultado.getString("NOME_FILMES"));

        lista.add(filme);
    }
   return lista;
}

public ArrayList<Filmes> listar() throws SQLException {
    StringBuilder sql = new StringBuilder();
    sql.append("SELECT ID, NOME_FILMES, GENERO_FILMES, DATA_FILMES, DESCRICAO_FILMES ");
    sql.append("FROM db_filmes ");
    sql.append("ORDER BY NOME_FILMES ASC ");

    Connection conexao = ConexaoFactory.Conexao();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());

    ResultSet resultado = comando.executeQuery();

    ArrayList<Filmes> lista = new ArrayList<Filmes>();

    while (resultado.next()) {
        Filmes f = new Filmes();
        f.setID_FILMES(resultado.getLong("ID"));
        f.setN_FILMES(resultado.getString("NOME_FILMES"));
        f.setGENE_FILMES(resultado.getString("GENERO_FILMES"));
        f.setData_Filmes(resultado.getString("DATA_FILMES"));
        f.setDesc_Filmes(resultado.getString("DESCRICAO_FILMES"));

        lista.add(f);
    }
    return lista;
}

}

Scarpah600 commented 5 years ago

DOMAIN

package br.com.Filmes.domain;

public class Filmes {

private Long ID_FILMES;
private String N_FILMES;
private String GENE_FILMES;
private String Desc_Filmes;
private String Data_Filmes;
public Long getID_FILMES() {
    return ID_FILMES;
}
public void setID_FILMES(Long iD_FILMES) {
    ID_FILMES = iD_FILMES;
}
public String getN_FILMES() {
    return N_FILMES;
}
public void setN_FILMES(String n_FILMES) {
    N_FILMES = n_FILMES;
}
public String getGENE_FILMES() {
    return GENE_FILMES;
}
public void setGENE_FILMES(String gENE_FILMES) {
    GENE_FILMES = gENE_FILMES;
}
public String getDesc_Filmes() {
    return Desc_Filmes;
}
public String getData_Filmes() {
    return Data_Filmes;
}
public void setData_Filmes(String data_Filmes) {
    Data_Filmes = data_Filmes;
}
public void setDesc_Filmes(String desc_Filmes) {
    Desc_Filmes = desc_Filmes;
}

}

Scarpah600 commented 5 years ago

Conexao com o banco de dados

package br.com.Filmes.factory;

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;

public class ConexaoFactory {

public static final String USUARIO = "root";
public static final String SENHA = "asmn*pozx80";
private static final String URL = "jdbc:mysql://localhost:3306/dtb_filmes";

public static Connection Conexao() throws SQLException {
    Connection conexao = DriverManager.getConnection(URL, USUARIO, SENHA);
    return conexao;
}

public static void main(String[] args) throws SQLException {
    try {
        @SuppressWarnings("unused")
        Connection conexao = ConexaoFactory.Conexao();
        System.out.println("Conectado com sucesso!!");

    } catch (SQLException ex) {
        ex.printStackTrace();
        System.out.println("Conexao Falhou");
    }

}

}

Scarpah600 commented 5 years ago

web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">

Projeto 
<welcome-file-list>
    <welcome-file>pages/filmes.xhtml</welcome-file>
</welcome-file-list>

<context-param>
    <param-name>javax.faces.PROJECT_STAGE</param-name>
    <param-value>Development</param-value>
</context-param>
<context-param>
    <param-name>primefaces.THEME</param-name>
    <param-value>#{LayoutBean.applicationTheme}</param-value>
</context-param>

<context-param>
    <param-name>primefaces.THEME</param-name>
    <param-value>rocket</param-value>
</context-param>

<context-param>
    <param-name>com.sun.faces.writeStateAtFormEnd</param-name>
    <param-value>false</param-value>
</context-param>

<context-param>
    <param-name>javax.faces.DATETIMECONVERTER_DEFAULT_TIMEZONE_IS_SYSTEM_TIMEZONE</param-name>
    <param-value>true</param-value>
</context-param>

<context-param>
    <param-name>javax.faces.INTERPRET_EMPTY_STRING_SUBMITTED_VALUES_AS_NULL</param-name>
    <param-value>true</param-value>
</context-param>

<context-param>
    <param-name>javax.faces.STATE_SAVING_METHOD</param-name>
    <param-value>server</param-value>
</context-param>
<context-param>
    <param-name>primefaces.FONT_AWESOME</param-name>
    <param-value>true</param-value>
</context-param>

<context-param>
    <param-name>primefaces.TRANSFORM_METADATA</param-name>
    <param-value>true</param-value>
</context-param>

<servlet>
    <servlet-name>Faces Servlet</servlet-name>
    <servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
    <servlet-name>Faces Servlet</servlet-name>
    <url-pattern>*.xhtml</url-pattern>
</servlet-mapping>

Scarpah600 commented 5 years ago

pom.xml NÃO ESQUECER DO FINALNAME FINAL DO CODIGO DO POM <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

4.0.0 
<groupId>Projeto</groupId>
<artifactId>Projeto</artifactId>
<version>1.0</version>
<packaging>war</packaging>
<dependencies>
    <dependency>
        <groupId>com.sun.xml.ws</groupId>
        <artifactId>jaxws-rt</artifactId>
        <version>2.1.3</version>
        <scope>compile</scope>
    </dependency>
    <dependency>
        <!-- Hibernate -->
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-entitymanager</artifactId>
        <version>4.3.11.Final</version>
        <scope>provided</scope>
        <exclusions>
            <exclusion>
                <artifactId>antlr</artifactId>
                <groupId>antlr</groupId>
            </exclusion>
        </exclusions>
    </dependency>
    <!-- LOG -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
        <scope>provided</scope>
    </dependency>
    <!-- Dependência da especificação do JBOSS -->
    <dependency>
        <groupId>javax</groupId>
        <artifactId>javaee-api</artifactId>
        <version>7.0</version>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>axis</groupId>
        <artifactId>axis</artifactId>
        <version>1.4</version>
    </dependency>
    <dependency>
        <!-- Java Commons Lang -->
        <groupId>commons-lang</groupId>
        <artifactId>commons-lang</artifactId>
        <version>2.5</version>
    </dependency>
    <dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-lang3</artifactId>
        <version>3.7</version>
    </dependency>
    <dependency>
        <groupId>com.google.code.gson</groupId>
        <artifactId>gson</artifactId>
        <version>2.8.2</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.5</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.17</version>
    </dependency>
    <dependency>
        <groupId>com.sun.faces</groupId>
        <artifactId>jsf-api</artifactId>
        <version>2.2.16</version>
    </dependency>
    <dependency>
        <groupId>com.sun.faces</groupId>
        <artifactId>jsf-impl</artifactId>
        <version>2.2.16</version>
    </dependency>
    <dependency>
        <groupId>org.primefaces</groupId>
        <artifactId>primefaces</artifactId>
        <version>6.2</version>
    </dependency>
    <dependency>
        <groupId>org.primefaces.extensions</groupId>
        <artifactId>primefaces-extensions</artifactId>
        <version>6.2</version>
    </dependency>
    <dependency>
        <groupId>org.quartz-scheduler</groupId>
        <artifactId>quartz</artifactId>
        <version>2.2.2</version>
    </dependency>
    <dependency>
        <groupId>javax.interceptor</groupId>
        <artifactId>javax.interceptor-api</artifactId>
        <version>1.2</version>
    </dependency>
    <dependency>
        <groupId>org.apache.deltaspike.modules</groupId>
        <artifactId>deltaspike-jsf-module-api</artifactId>
        <version>1.8.0</version>
        <scope>compile</scope>
    </dependency>
    <dependency>
        <groupId>org.apache.deltaspike.modules</groupId>
        <artifactId>deltaspike-jsf-module-impl</artifactId>
        <version>1.8.0</version>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.primefaces.extensions</groupId>
        <artifactId>all-themes</artifactId>
        <version>1.0.8</version>
        <scope>compile</scope>
    </dependency>
</dependencies>

<build>
    <sourceDirectory>src</sourceDirectory>
    <plugins>
        <plugin>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.5.1</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
            </configuration>
        </plugin>
        <plugin>
            <artifactId>maven-war-plugin</artifactId>
            <version>3.0.0</version>
            <configuration>
                <warSourceDirectory>WebContent</warSourceDirectory>
            </configuration>
        </plugin>
    </plugins>
    <finalName>Projeto</finalName>
</build>