/*
 * 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 consulta;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author syd
 */
public class ConsultaV2 {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        int input;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String connectionUrl = "jdbc:sqlserver://DESKTOP-NFDQP8C;databaseName=projectBD;user=sa;password=123qwe;";

           Connection con = DriverManager.getConnection(connectionUrl);

            do {

                System.out.println("\n*** O que pretende fazer? ***\n1-Consultar dados das Consultas\n2-Marcar nova Consulta\n3-Sair");
                input = Ler.umInt();
                Statement stmt = null;
                ResultSet rs = null;
                switch (input) {
                    case 1: {
                        System.out.println("Insira ID do utente");
                        int idUtente= Ler.umInt();
                        String SQL = "Select *\n"
                                + "From Consulta\n"
                                +"Where UtenteID="+idUtente+"\n";

                        stmt = con.createStatement();
                        rs = stmt.executeQuery(SQL);
                        while (rs.next()) {
                            System.out.println("ConsultaID: " + rs.getString(1) + " Anotação: " + rs.getString(2) + " MedicoID: " + rs.getString(3)+ " UtenteID: " + rs.getString(4)+ " CentroID: " + rs.getString(5) );
                        }

                    }
                    continue;
                    case 2: {
            System.out.println(“———Marcar Nova Consulta————”);

            System.out.println(“Insira o ID do Utente:”);
            utenteID = Ler.umInt();
            System.out.println(“Insira o ID do Médico:”);
            medicoID = Ler.umInt();
            System.out.println(“Insira o ID do Centro: (1;2-Centro de Saude) (3-Centro de Análises)”);
            centroID = Ler.umInt();
            System.out.println(“Insira as anotações necessárias:”);
            anot = Ler.next();


                         rs = con.prepareStatement(
                                "INSERT INTO Consulta(Anotacao,MedicoID,UtenteID,CentroID)  values(anot,medicoID,utenteID,cdntroID)”);

                        rs.executeUpdate();
                        rs.close();

            System.out.println(“Consulta agendada”);


                    }
                    continue;

                }
            } while (input != 3);

        } catch (SQLException e) {
            System.out.println("SQL Exception: " + e.toString());
        } catch (ClassNotFoundException cE) {
            System.out.println("Class Not Found Exception: " + cE.toString());
        }

    }
}