package desguace;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

import desguaceForms.registroVehiculosForm;


public class registrarVehicDAO {
   public void registrarVehic(registroVehiculosForm rvehiculosForm){

	 try {
		 Class.forName("oracle.jdbc.OracleDriver");
	     Connection conexion = DriverManager.getConnection(
	     "jdbc:oracle:thin:@127.0.0.1:1521:TALLER","TALLER","TALLER");
	     String insertar = ("INSERT INTO COCHE (matricula, id_modelo, id_entrada, id_salida) values (?,?,?,?)");
	     PreparedStatement pst =conexion.prepareStatement(insertar);

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

	     Date entrada = sdf.parse(rvehiculosForm.getId_entrada());
	     Date salida = sdf.parse(rvehiculosForm.getId_salida());

	     java.sql.Date entradaS = new java.sql.Date(entrada.getTime());
	     java.sql.Date salidaS = new java.sql.Date(salida.getTime());

	     pst.setString(1, rvehiculosForm.getMatricula());
	     pst.setInt(2, Integer.parseInt(rvehiculosForm.getId_modelo()));
	     pst.setDate(3, entradaS);
	     pst.setDate(4, salidaS);

	     pst.executeUpdate(insertar);

	     pst.close();
	     conexion.close();
	 }catch (Exception e){
		 e.printStackTrace();
     }
   }

//fin clase
}