Jefferson Chaves jeffersonchaves

😎

Focusing

jeffersonchaves / buscando_valor_emL_lista_sorteada.por

Created August 11, 2023 17:19

	programa
	{
	inclua biblioteca Util



	funcao inicio()
	{
	inteiro lista[30]
	inteiro num_elementos = Util.numero_elementos(lista)

jeffersonchaves / dados-iniciais.sql

Created May 22, 2023 14:00

	insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
	values (1, 'Fiat', 'Toro', 2020, 2020, 107000);

	insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
	values (2, 'Ford', 'Fiesta', 2019, 2019, 42000);

	insert into Veiculo (codigo, fabricante, modelo, anoFabricacao, anoModelo, valor)
	values (3, 'Renault', 'Clio', 2013, 2013, 20000);

jeffersonchaves / SellerRepository (delete).java

Created May 8, 2023 14:07

-package br.edu.ifpr.persistproject.repository;
-import br.edu.ifpr.persistproject.connection.ConnectionFactory;
-import br.edu.ifpr.persistproject.exception.DatabaseIntegrityException;
-import br.edu.ifpr.persistproject.model.Seller;
-import java.sql.*;
-import java.text.SimpleDateFormat;
-public class SellerRepository {

jeffersonchaves / SellerRepository (update).java

Created May 8, 2023 13:54

	package br.edu.ifpr.persistproject.repository;

	import br.edu.ifpr.persistproject.connection.ConnectionFactory;
	import br.edu.ifpr.persistproject.model.Seller;

	import java.sql.*;
	import java.text.SimpleDateFormat;

	public class SellerRepository {

jeffersonchaves / SellerRepository (insert with generated keys).java

Created May 8, 2023 13:44

+public class SellerRepository {
+    private Connection conn;
+    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
+    public SellerRepository(){
+        ConnectionFactory connectionFactory = new ConnectionFactory();
+        conn = connectionFactory.getConnection();
+    }

jeffersonchaves / SellerRepository (with insert).java

Last active May 8, 2023 13:43

+public class SellerRepository {
+    private Connection conn;
+    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
+    public SellerRepository(){
+        ConnectionFactory connectionFactory = new ConnectionFactory();
+        conn = connectionFactory.getConnection();
+    }

jeffersonchaves / SellerRepository.java

Last active May 8, 2023 23:48

	public class SellerRepository {

	private Connection conn;

	public SellerRepository(){
	ConnectionFactory connectionFactory = new ConnectionFactory();
	conn = connectionFactory.getConnection();
	}

	public List<Seller> getSellers(){

jeffersonchaves / Seller.java

Created May 8, 2023 12:09

	public class Seller {

	private String Id;
	private String name;
	private String email;
	private LocalDate birthDate;
	private Double BaseSalary;
	//private Department department;

	public String getId() {

jeffersonchaves / ConnectionFactory.java

Last active July 29, 2024 20:02

	public class ConnectionFactory {

	public Connection getConnection(){

	String database = "";
	String user = "";
	String pass = ""

	try {

jeffersonchaves / ifpr_store_sellers.sql

Last active July 29, 2024 20:51

	CREATE TABLE department (
	Id int(11) NOT NULL AUTO_INCREMENT,
	Name varchar(60) DEFAULT NULL,
	PRIMARY KEY (Id)
	);

	CREATE TABLE seller (
	Id int(11) NOT NULL AUTO_INCREMENT,
	Name varchar(60) NOT NULL,
	Email varchar(100) NOT NULL,