package prova;

import java.sql.Connection;
import java.util.Date ;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;


public class DAO {

	private Connection conn = null;

	public void criarServico(int codigo_animal, String descricao, double valor) throws ClassNotFoundException, SQLException{
		Calendar cal = Calendar.getInstance();
		Date dt = cal.getTime();
		SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String entrada = sdf.format(dt);
		Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:8889/prova?" + "user=root&password=root&");
        Statement statement = conn.createStatement();
        statement.executeUpdate("INSERT INTO servico"
        		+ " (codigo_animal,descricao, valor, entrada)"
                + "VALUES (" + "'" + codigo_animal + "'" + "," + "'" + descricao + "'" + "," + "'"
        		+ valor+ "'" + ","+ "'" + entrada + "'" + ")");
        conn.close();
	}

	public void updateServico(int codigo, String saida) throws ClassNotFoundException, SQLException{
		Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:8889/prova?" + "user=root&password=root&");
        Statement statement = conn.createStatement();
        statement.executeUpdate("UPDATE servico set saida = "
                 + "'" + saida + "'" + "WHERE codigo = " + "'" + codigo + "';");
        conn.close();
	}
}