mx.com.pixup.portal.dao.FormaPagoDaoJdbc.java Source code

Introduction

Here is the source code for mx.com.pixup.portal.dao.FormaPagoDaoJdbc.java

Source

/*
 * 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 mx.com.pixup.portal.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import mx.com.pixup.portal.model.FormaPago;
import org.apache.commons.dbcp.BasicDataSource;

/**
 *
 * @author JAVA-07
 */
public class FormaPagoDaoJdbc implements FormaPagoDao {

    private DataSource dataSource;

    public FormaPagoDaoJdbc() {
        BasicDataSource dataSource = new BasicDataSource();

        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUsername("root");
        dataSource.setPassword("admin");
        //dataSource.setPassword("mysqlroot");
        dataSource.setUrl("jdbc:mysql://localhost:3306/pixup");
        this.dataSource = dataSource;
    }

    @Override
    public FormaPago insertFormaPago(FormaPago formaPago) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        String sql = "insert into forma_pago (descripcion) values (?)";

        try {
            connection = dataSource.getConnection();

            connection.setAutoCommit(false);

            preparedStatement = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            preparedStatement.setString(1, formaPago.getDescripcion());

            preparedStatement.execute();

            connection.commit();
            resultSet = preparedStatement.getGeneratedKeys();

            resultSet.next();
            formaPago.setId(resultSet.getInt(1));

            return formaPago;
        } catch (Exception e) {

        } finally {
            if (preparedStatement != null) {
                try {
                    preparedStatement.close();
                } catch (Exception e) {
                }
            }
            if (connection != null) {
                try {
                    connection.close();
                } catch (Exception e) {
                }
            }

        }
        return null;
    }

    @Override
    public List<FormaPago> findAllFormaPagos() {

        String sql = "select * from forma_pago";
        List<FormaPago> formaPagos = new ArrayList<FormaPago>();

        try (Connection connection = dataSource.getConnection();
                PreparedStatement preparedStatement = connection.prepareStatement(sql);
                ResultSet resultSet = preparedStatement.executeQuery();) {

            while (resultSet.next()) {
                FormaPago temp = new FormaPago();
                temp.setId(resultSet.getInt("id"));
                temp.setDescripcion(resultSet.getString("descripcion"));
                formaPagos.add(temp);
            }

        } catch (Exception e) {
            return null;
        }
        return formaPagos;

    }

    @Override
    public FormaPago findById(Integer id) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public FormaPago updateFormaPago(FormaPago formaPago) {
        String sql = "update forma_pago set descripcion = ? where id = ?";
        try (Connection connection = dataSource.getConnection();
                PreparedStatement preparedStatement = connection.prepareStatement(sql);) {
            preparedStatement.setInt(2, formaPago.getId());
            preparedStatement.setString(1, formaPago.getDescripcion());

            preparedStatement.execute();

        } catch (Exception e) {
            return null;
        }
        return formaPago;

    }

    @Override
    public void deleteFormaPago(FormaPago formaPago) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        String sql = "delete from forma_pago where id = ?";

        try {
            connection = dataSource.getConnection();

            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1, formaPago.getId());

            preparedStatement.execute();

        } catch (Exception e) {

        } finally {
            if (preparedStatement != null) {
                try {
                    preparedStatement.close();
                } catch (Exception e) {
                }
            }
            if (connection != null) {
                try {
                    connection.close();
                } catch (Exception e) {
                }
            }

        }

    }

}