jeffersonchaves

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

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

public class SellerRepository {

    private Connection conn;
    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");

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

jeffersonchaves

public class SellerRepository {

    private Connection conn;
    private SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");

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

jeffersonchaves

public class SellerRepository {

    private Connection conn;

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

    public List<Seller> getSellers(){

jeffersonchaves

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

public class ConnectionFactory {

    public Connection getConnection(){
        
        String database = "";
        String user = "";
        String pass = ""

        try {
            

jeffersonchaves

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

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

jeffersonchaves

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

jeffersonchaves

programa
{
	inclua biblioteca Util

	inteiro listaSorteados[50] //maior numero de dezenas possível
	
	funcao inicio()
	{
		mega()