Projeto Java Web Servelest

Scarpah600 commented 5 years ago

<?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>paginas/index.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>bootstrap</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

4.0.0

<groupId>Projeto</groupId>
<artifactId>Projeto</artifactId>
<version>1.0</version>
<packaging>war</packaging>

com.sun.xml.ws jaxws-rt 2.1.3 compile org.hibernate hibernate-entitymanager 4.3.11.Final provided antlr antlr log4j log4j 1.2.17 provided javax javaee-api 7.0 provided axis axis 1.4 commons-lang commons-lang 2.5 org.apache.commons commons-lang3 3.7 com.google.code.gson gson 2.8.2 commons-io commons-io 2.5 org.apache.poi poi 3.17 com.sun.faces jsf-api 2.2.16 com.sun.faces jsf-impl 2.2.16 org.primefaces primefaces 6.2 org.primefaces.extensions primefaces-extensions 6.2 org.primefaces.themes bootstrap 1.0.10 org.quartz-scheduler quartz 2.2.2 javax.interceptor javax.interceptor-api 1.2 org.apache.deltaspike.modules deltaspike-jsf-module-api 1.8.0 compile org.apache.deltaspike.modules deltaspike-jsf-module-impl 1.8.0 runtime

<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>
</build>
<repositories>
    <repository>
        <id>prime-repo</id>
        <name>Prime Repo</name>
        <url>http://repository.primefaces.org</url>
    </repository>
</repositories>

Scarpah600 commented 5 years ago

package br.com.Jc1.DAO;

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

import java.sql.PreparedStatement;

import br.com.Jc1.domain.Filmes; import br.com.Jc1.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)");
    sql.append("(CATEGORIA_FILMES)");
    sql.append("(DATA_FILMES)");

    sql.append("(DESCRICAO_FILMES)");
    sql.append("VALUES(?,?,?,?)");

    Connection conexao = ConexaoFactory.conectar();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setString(1, f.getFilmes());
    comando.setString(2, f.getGenero_f());
    comando.setString(3, f.getDatfilmes());
    comando.setString(4, f.getDescri());
    comando.executeUpdate();

}

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

    Connection conexao = ConexaoFactory.conectar();

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

}

public void consultarNome(Filmes f) throws SQLException 
{
   StringBuilder sql = new StringBuilder();
   sql.append("SELECT NOME_FILMES");
   sql.append("FROM db_filmes");

}

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

    Connection conexao = ConexaoFactory.conectar();

    PreparedStatement comando = conexao.prepareStatement(sql.toString());
    comando.setLong(1, f.getId());
    comando.setString(2, f.getFilmes());
    comando.setString(3, f.getGenero_f());
    comando.setString(4, f.getDatfilmes());
    comando.setString(5, f.getDescri());
    comando.executeUpdate();

}

public static void main(String[] args) {

}

}

Scarpah600 / JavaWeb

Projeto Java Web Servelest #1