Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package br.com.fiap.tds.ltp.nac2.questao1.model;
- import java.io.Serializable;
- @SuppressWarnings("serial")
- public class Veiculo implements Serializable{
- //JavaBeans
- private int id_veiculo;
- private String modelo;
- private String placa;
- private String ano;
- private double motor;
- private String placaN;
- //Getterss e Setter's
- public int getId_veiculo() {
- return id_veiculo;
- }
- public void setId_veiculo(int id_veiculo) {
- this.id_veiculo = id_veiculo;
- }
- public String getModelo() {
- return modelo;
- }
- public void setModelo(String modelo) {
- this.modelo = modelo;
- }
- public String getPlaca() {
- return placa;
- }
- public void setPlaca(String placa) {
- this.placa = placa;
- }
- public String getAno() {
- return ano;
- }
- public void setAno(String ano) {
- this.ano = ano;
- }
- public double getMotor() {
- return motor;
- }
- public void setMotor(double motor) {
- this.motor = motor;
- }
- public String getPlacaN() {
- return placaN;
- }
- public void setPlacaN(String placaN) {
- this.placaN = placaN;
- }
- }
- ==
- package br.com.fiap.tds.ltp.nac2.questao1.fabrica;
- import java.sql.*;
- public class ConnectionFactory {
- protected static Connection conn = null;
- //FABRICA DE CONEXOES
- public void abrirBanco() {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- conn = DriverManager.getConnection("jdbc:oracle:thin:@oracle.fiap.com.br:1521:ORCL","OPS$RM75044","071293");
- //System.out.println("Conexao efetuada com sucesso!");
- } catch (Exception e) {
- // TRATAMENTO DO ERRO
- System.out.println("Erro ao abrir conexao com o banco: console->"+e.getMessage());
- }
- }
- public void fecharBanco() {
- try {
- conn.close();
- System.out.println("Conexao encerrada com sucesso.");
- } catch (Exception e) {
- System.out.println("Erro ao encerrar conexao com o banco: console-> "+e.getMessage());
- }
- }
- }
- ==
- package br.com.fiap.tds.ltp.nac2.questao1.dao;
- import java.sql.*;
- import java.util.*;
- import br.com.fiap.tds.ltp.nac2.questao1.fabrica.ConnectionFactory;
- import br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo;
- public class VeiculoDAO extends ConnectionFactory{
- static String sql = null;
- static PreparedStatement stmt;
- //CRUD
- //INSERIR
- public void inserirVeiculo(Veiculo veiculo) {
- try {
- abrirBanco();
- sql = "INSERT INTO TB_LTP_VEICULO (ID_VEICULO, MODELO, PLACA, ANO, MOTOR) VALUES (SQ_LTP_VEICULO.nextval,?,?,?,?)";
- stmt = conn.prepareStatement(sql);
- //Setar os parametros
- stmt.setString(1, veiculo.getModelo());
- stmt.setString(2, veiculo.getPlaca());
- stmt.setString(3, veiculo.getAno());
- stmt.setDouble(4, veiculo.getMotor());
- stmt.execute();//Executar a linha de comando
- fecharBanco();
- } catch (SQLException e) {
- System.out.println("Erro ao inserir o Veiculo: ");
- e.printStackTrace();
- }
- }
- //DELETAR
- public void deletarVeiculo(Veiculo veiculo) {
- try {
- abrirBanco();
- sql = "DELETE FROM TB_LTP_VEICULO WHERE PLACA = ?";
- stmt = conn.prepareStatement(sql);
- stmt.setString(1, veiculo.getPlaca());
- stmt.execute();
- fecharBanco();
- } catch (SQLException e) {
- System.out.println("Erro ao deletar o Veiculo: ");
- e.printStackTrace();
- }
- //setar parametros
- }
- public void alterarVeiculo(Veiculo veiculo) {
- try {
- abrirBanco();
- sql = "UPDATE TB_LTP_VEICULO set PLACA = ? WHERE PLACA = ?";
- stmt = conn.prepareStatement(sql);
- stmt.setString(1, veiculo.getPlacaN());
- stmt.setString(2, veiculo.getPlaca());
- stmt.execute();
- fecharBanco();
- } catch (SQLException e) {
- System.out.println("Erro ao alterar o Veiculo: ");
- e.printStackTrace();
- }
- }
- public ArrayList<Veiculo> getVeiculos() throws SQLException {
- String query = "SELECT * FROM TB_LTP_VEICULO";
- ArrayList<Veiculo> veiculos = new ArrayList<Veiculo>();
- abrirBanco();
- Statement stmt = conn.createStatement();
- ResultSet res = stmt.executeQuery(query);
- while (res.next()) {
- Veiculo veiculo = new Veiculo();
- veiculo.setModelo(res.getString("MODELO"));
- veiculo.setPlaca(res.getString("PLACA"));
- veiculo.setAno(res.getString("ANO"));
- veiculo.setMotor(res.getDouble("MOTOR"));
- veiculos.add(veiculo);
- }
- fecharBanco();
- return veiculos;
- }
- }
- ==
- package br.com.fiap.tds.ltp.nac2.questao1.controller;
- import java.io.IOException;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO;
- import br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo;
- /**
- *
- * @author Modesto
- */
- @WebServlet(name = "VeiculoController", urlPatterns = {"/VeiculoController"})
- public class VeiculoController extends HttpServlet {
- private static final long serialVersionUID = 1L;
- private static String insert_or_edit = "/incluir.jsp";
- private static String list_veiculos = "/listar.jsp";
- private VeiculoDAO veiculodao;
- @SuppressWarnings("unused")
- private String forward = "";
- public VeiculoController() {
- super();
- veiculodao = new VeiculoDAO();
- }
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String action = request.getParameter("action");
- if (action.equalsIgnoreCase("excluir")) {
- } else if (action.equalsIgnoreCase("exportar")) {
- } else if (action.equalsIgnoreCase("alterar")) {
- } else if (action.equalsIgnoreCase("listVeiculos")) {
- forward = list_veiculos;
- } else {
- forward = insert_or_edit;
- }
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- Veiculo veiculo = new Veiculo();
- String valida_placa = request.getParameter("placa");
- if (valida_placa == null || valida_placa.isEmpty()) {
- response.sendRedirect(request.getContextPath() + "/incluir.jsp");
- } else {
- //Dados para inserir
- veiculo.setModelo(request.getParameter("modelo"));
- veiculo.setPlaca(request.getParameter("placa"));
- veiculo.setAno(request.getParameter("ano"));
- //PARSE
- String motor_s = request.getParameter("motor");
- double motor = Double.parseDouble(motor_s);
- veiculo.setMotor(motor);
- veiculodao.inserirVeiculo(veiculo);
- response.sendRedirect(request.getContextPath() + "/listar.jsp");
- }
- }
- }
- ==
- <%@page import="org.apache.jasper.tagplugins.jstl.core.ForEach"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo"%>
- <%@page import="java.sql.*"%>
- <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
- <!doctype html>
- <html lang="pt-br">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta content="width=device-width, initial-scale=1, maximum-scale=1" name="viewport">
- <title>Lista de Veiculos</title>
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="./bootstrap/css/font-awesome.min.css">
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.css">
- <link rel="stylesheet" href="./bootstrap/css/style2.css">
- </head>
- <body>
- <script type="text/javascript" src="./bootstrap/js/jquery.js"></script>
- <script type="text/javascript" src="./bootstrap/js/jquery.maskedinput.js"></script>
- <script type="text/javascript">
- jQuery(function($){
- $("#Aplaca").mask("***-9999");
- $("#Nplaca").mask("***-9999");
- });
- </script>
- <div class="container">
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="row">
- <div role="main">
- <div class="row">
- <div class="col-sm-6 col-lg-4">
- <div class="form-group">
- <form action="daoalterar.jsp" method="GET">
- <label for="Aplaca" class="col-md-4 control-label">Placa atual:</label>
- <div class="form-group">
- <input data-mask="***-9999" maxlength="8" id="Aplaca" class="form-control" type="text" name="Aplaca" value="<c:out value="${veiculo.placa}" />" />
- </div>
- <label for="Nplaca" class="col-md-4 control-label">Placa nova:</label>
- <div class="form-group">
- <input data-mask="***-9999" maxlength="8" id="Nplaca" class="form-control" type="text" name="Nplaca" value="<c:out value="${veiculo.placa}" />" />
- </div>
- <div class="col-md-8">
- <input class="btn btn-info btn-large btn-primary" type="submit" value="Alterar" />
- </div>
- </form>
- </div>
- </div><!-- /.row this actually does not appear to be needed with the form-horizontal -->
- </div>
- </div>
- </div>
- </div><!-- /.container -->
- </body>
- </html>
- ==
- <%@page import="org.apache.jasper.tagplugins.jstl.core.ForEach"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo"%>
- <%@page import="java.sql.*"%>
- <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
- <!doctype html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta content="width=device-width, initial-scale=1, maximum-scale=1" name="viewport">
- <title>Lista de Veiculos</title>
- <!-- Latest compiled and minified CSS -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="bootstrap/css/style2.css">
- <!-- Optional theme -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
- <link href="bootstrap.css" rel="stylesheet">
- </head>
- <body>
- <div class="container">
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="row">
- <div role="main">
- <!-- conteudo principal -->
- <section>
- <div class="span12 pagination-centered">
- <div class="clear"><br><br><br><br><br><br></div>
- <div class="alert alert-danger">
- A placa <%= request.getParameter("Aplaca")%> foi alterada com <strong>sucesso </strong>para <%= request.getParameter("Nplaca")%>
- </div>
- <%
- VeiculoDAO veiculoDAO = new VeiculoDAO();
- Veiculo veiculo = new Veiculo();
- veiculo.setPlaca(request.getParameter("Aplaca"));
- veiculo.setPlacaN(request.getParameter("Nplaca"));
- veiculoDAO.alterarVeiculo(veiculo);
- %>
- </div>
- </section>
- </div>
- </div>
- <footer class="row">
- </footer>
- </div>
- <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
- <script src="http://netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
- </body>
- </html>
- ==
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo"%>
- <%@page import="java.sql.*"%>
- <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
- <!doctype html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta content="width=device-width, initial-scale=1, maximum-scale=1" name="viewport">
- <title>Lista de Veiculos</title>
- <!-- Latest compiled and minified CSS -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="bootstrap/css/style2.css">
- <!-- Optional theme -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
- <link href="bootstrap.css" rel="stylesheet">
- </head>
- <body>
- <div class="container">
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="row">
- <div role="main">
- <!-- conteudo principal -->
- <section>
- <div class="span12 pagination-centered">
- <div class="clear"><br><br><br><br><br><br></div>
- <div class="alert alert-danger">
- A placa <%= request.getParameter("placa")%> foi excluida com <strong>sucesso </strong>
- </div>
- <%
- String cod = request.getParameter("placa");
- VeiculoDAO veiculoDAO = new VeiculoDAO();
- Veiculo veiculo = new Veiculo();
- veiculo.setPlaca(cod);
- veiculoDAO.deletarVeiculo(veiculo);
- %>
- </div>
- </section>
- </div>
- </div>
- <footer class="row">
- </footer>
- </div>
- <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
- <script src="http://netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
- </body>
- </html>
- ==
- <%@page import="org.apache.jasper.tagplugins.jstl.core.ForEach"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo"%>
- <%@page import="java.sql.*"%>
- <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>Lista de Veiculos</title>
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="./bootstrap/css/font-awesome.min.css">
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.css">
- <link rel="stylesheet" href="./bootstrap/css/style2.css">
- </head>
- <body>
- <script type="text/javascript" src="./bootstrap/js/jquery.js"></script>
- <script type="text/javascript" src="./bootstrap/js/jquery.maskedinput.js"></script>
- <script type="text/javascript">
- jQuery(function($){
- $("#placa").mask("***-9999");
- $("#ano").mask("9999");
- $("#motor").mask("9.9");
- });
- </script>
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="row">
- <div role="main">
- <!-- conteudo principal -->
- <section>
- <div class="span12 pagination-centered">
- <form action="daoexcluir.jsp" method="GET">
- <div class="form-group">
- <label for="placa">
- Digite a placa do veiculo a ser apagado:
- <input data-mask="***-9999" maxlength="8" id="placa" class="form-control" type="text" name="placa"/>
- </label>
- </div>
- <input type="submit" value="Excluir" class="btn btn-info btn-large btn-primary" />
- </form>
- </div>
- </section>
- </div>
- </div>
- </body>
- </html>
- ==
- <%@ page language="java" contentType="text/html; charset=UTF-8"
- pageEncoding="UTF-8"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>NAC2 - Incluir</title>
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="./bootstrap/css/font-awesome.min.css">
- <link rel="stylesheet" href="./bootstrap/css/bootstrap.css">
- <link rel="stylesheet" href="./bootstrap/css/style2.css">
- </head>
- <body>
- <script type="text/javascript" src="./bootstrap/js/jquery.js"></script>
- <script type="text/javascript" src="./bootstrap/js/jquery.maskedinput.js"></script>
- <script type="text/javascript">
- jQuery(function($){
- $("#placa").mask("***-9999");
- $("#ano").mask("9999");
- $("#motor").mask("9.9");
- });
- </script>
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="container">
- <div class="row">
- <div role="main">
- <form method="POST" action='VeiculoController' name="frmAddVeiculo" role="form">
- <div class="form-group">
- <label for="modelo">
- Modelo:<input maxlength="20" class="form-control" type="text" id="modelo" name="modelo" value="<c:out value="${veiculo.modelo}" />" />
- </label>
- </div>
- <div class="form-group">
- <label for="placa">
- Placa: <input data-mask="***-9999" maxlength="8" id="placa" class="form-control" type="text" name="placa" value="<c:out value="${veiculo.placa}" />" />
- </label>
- </div>
- <div class="form-group">
- <label for="ano">
- Ano: <input maxlength="4" data-mask="9999" id="ano" class="form-control" type="text" name="ano" value="<c:out value="${veiculo.ano}" />" />
- </label>
- </div>
- <div class="form-group">
- <label for="motor">
- Motor: <input maxlength="3" data-mask="9.9" id="motor" class="form-control" type="text" id="motor" name="motor" value="<c:out value="${veiculo.motor}" />" />
- </label>
- </div>
- <input type="submit" value="Incluir" class="btn btn-info" />
- </form>
- </div>
- </div></div>
- </body>
- </html>
- ==
- <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.dao.VeiculoDAO"%>
- <%@page import="br.com.fiap.tds.ltp.nac2.questao1.model.Veiculo"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
- <!doctype html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta content="width=device-width, initial-scale=1, maximum-scale=1" name="viewport">
- <title>Lista de Veiculos</title>
- <!-- Latest compiled and minified CSS -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
- <link rel="stylesheet" href="bootstrap/css/style2.css">
- <!-- Optional theme -->
- <link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
- <link href="bootstrap.css" rel="stylesheet">
- </head>
- <body>
- <div class="container">
- <header class="row">
- <%@include file="menu.jsp"%>
- </header>
- <div class="row">
- <div role="main">
- <div class="clear"><br><br><br><br><br><br></div>
- <div class="alert alert-danger">
- <br>
- <strong>Anote os dados dos alunos:</strong>
- <br>
- <br>
- <br>+------------------------------------------+
- <br>| Artur Modesto - RM75044 - 1TDSR |
- <br>+------------------------------------------+
- <br>
- <br>* Isso mesmo fiz sozinho =)
- <br>
- <br>
- </div>
- </div>
- </div>
- <footer class="row">
- </footer>
- </div>
- <script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
- <script src="http://netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement