Advertisement
Guest User

Untitled

a guest
Jan 29th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. try {
  2. //cargar el driver
  3.  
  4. Connection myConn = null;
  5. PreparedStatement myStmt = null;
  6.  
  7. // 0. read user input from command line: codigo nombre apellido tlf
  8. //int id1 = Integer.parseInt(jTextField5.getText());
  9. String nombre = jTextField6.getText();
  10. Double peso = Double.parseDouble(jTextField7.getText());
  11. Double calorias = Double.parseDouble(jTextField8.getText());
  12. String tipo_alimento = jTextField9.getText();
  13. String nombre_rec = jTextField10.getText();
  14.  
  15. // 1. Get a connection to database
  16. myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/menu","root","");
  17.  
  18. // 2. Create a statement
  19. String sql = "insert into ingredientes"
  20. + " (id_ing, nombre_ing, peso_ing, calorias_ing,tipo_alimento_ing,nombre_rec)"
  21. + " values (null, ?, ?, ?, ?, ?)";
  22.  
  23. myStmt = myConn.prepareStatement(sql);
  24.  
  25. // set param values
  26. //myStmt.setInt(1, codigo);
  27. myStmt.setString(1, nombre);
  28. myStmt.setDouble(2, peso);
  29. myStmt.setDouble(3, calorias);
  30. myStmt.setString(4, tipo_alimento);
  31. myStmt.setString(5, nombre_rec);
  32.  
  33. // 3. Execute SQL query
  34. myStmt.executeUpdate();
  35. myStmt.close();
  36. myConn.close();
  37. System.out.println("Insert complete.");
  38. } catch (SQLException exc) {
  39. System.out.println(exc);
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement