SentenciaInsert.java

package com.roshka.bootcamp;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class SentenciaInsert {
    static Connection getConnection(){
        Connection con=null;
        try{
            Class.forName("org.postgresql.Driver");
            con= DriverManager.getConnection("jdbc:postgresql://localhost:5432/bootcamp_market",
                    "postgres", "postgres");
        }catch(Exception e){System.out.println(e);}
        return con;
    }

    public static int insertCliente(Cliente cliente){
        int status=0;
        try{
            Connection con=SentenciaInsert.getConnection();
            PreparedStatement ps=con.prepareStatement(
                    "insert into Cliente(nombre,apellido,nro_cedula,telefono) values (?,?,?,?)");
            ps.setString(1,cliente.getName());
            ps.setString(2,cliente.getApellido());
            ps.setInt(3,cliente.getNro_cedula());
            ps.setString(4,cliente.getTelefono());

            status=ps.executeUpdate();

            con.close();
        }catch(Exception ex){ex.printStackTrace();}

        return status;
    }

}