Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package br.edu.ifms.vendas.DAO;
- import br.edu.ifms.vendas.modelo.Vendas;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import java.util.List;
- /**
- *
- * @author famil
- */
- public class VendasDAO {
- public static void inserir(Vendas venda){
- String sql = "INSERT INTO vendas (tipopag,id,codigo,descricao,qtd,precou) "
- + "VALUES (?,?,?,?)";
- try{
- PreparedStatement pstm =
- new Conexao().fazerConexao().prepareStatement(sql);
- pstm.setObject(1, venda.getTipopag());
- pstm.setObject(2, venda.getId());
- pstm.setObject(3, venda.getCodigo());
- pstm.setObject(4, venda.getDescricao());
- pstm.setObject(5, venda.getQtd());
- pstm.setObject(6, venda.getPrecou());
- pstm.executeQuery();
- pstm.close();
- System.out.println("Venda Inserida com sucesso!!");
- }catch(SQLException ex){
- System.out.println("Problemas ao inserir informações da sua venda");
- System.out.println(ex.getMessage());
- }
- }
- public static List<Vendas> buscarVendas(){
- List<Vendas> vendas = new ArrayList();
- String sql = "SELECT * FROM vendas";
- try{
- PreparedStatement pstm =
- new Conexao().fazerConexao().prepareStatement(sql);
- ResultSet rs = pstm.executeQuery();
- while(rs.next()){
- Vendas venda = new Vendas();
- venda.setTipopag(rs.getInt("tipopag"));
- venda.setId(rs.getInt("id"));
- venda.setCodigo(rs.getInt("codigo"));
- venda.setDescricao(rs.getString("descricao"));
- venda.setQtd(rs.getInt("qtd"));
- venda.setPrecou(rs.getDouble("precou"));
- vendas.add(venda);
- }
- rs.close();
- }catch(SQLException ex){
- System.out.println("Problemas ao ler informação do banco");
- }
- return vendas;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement