Passing the Values

[Lagarto]

Hello all

I'm trying to do an INSERT using Netbeans as my IDE, and SQL server 2005 Express as my DB engine.

When i compile my code its error free, but when i execute it wont do what its supposed to do.. Its not doing the insert.. i don't know exactly how to pass the values. Here's the code:

Thanks!

private void IngresarActionPerformed(java.awt.event.ActionEvent evt) {                                         
    Connection conexion;
    Statement sentencia;
    
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
     catch (Exception e){
    System.out.println("No se pudo conectar con el JDBC-ODBC");      
     return;
    }  
    
    try{
        conexion = DriverManager.getConnection("jdbc:odbc:con_sql","",""  );
        sentencia = conexion.createStatement();
        PreparedStatement insertar = conexion.prepareStatement("EXECUTE dbo.insertar " );
        
       
        
         
     
         
         String Nom = ("Nombre");
         String Ape = ("Apellido");
         String Ced = ("Cedula");
         String FechaN = ("Fecha_Nacimiento");
         String Sueldo = ("Sueldo");
         String TPrimario = ("Telefono_Primario");
         String TSecundario = ("Telefono_Secundario");
         String Movil = ("Movil");
         String Direccion = ("Direccion");
         
         
         
         
         
         
         
        
    }   
catch( Exception e ) {
         System.out.println( e );
         return;
         }
    }

[boy22]

check this code:

private void IngresarActionPerformed(java.awt.event.ActionEvent evt) {                                         
    Connection conexion;
    Statement sentencia;
    
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
     catch (Exception e){
    System.out.println("No se pudo conectar con el JDBC-ODBC");      
     return;
    }  
    
    try{
PreparedStatement insertar= con.prepareStatement("insert into table values( ? , ?,?,?,?,?,?)");
insertar.setString(1,"Marito");
insertar.setString(2,"Rojas");
insertar.setInt(3,45123145);
insertar.setDate(4,2007/5/2);
insertar.setDouble(5,1800.2);
insertar.executeUpdate();
    }   
catch( Exception e ) {
         System.out.println( e );
         return;
         }
    }