Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- //cargar el driver
- Connection myConn = null;
- PreparedStatement myStmt = null;
- // 0. read user input from command line: codigo nombre apellido tlf
- //int id1 = Integer.parseInt(jTextField5.getText());
- String nombre = jTextField6.getText();
- Double peso = Double.parseDouble(jTextField7.getText());
- Double calorias = Double.parseDouble(jTextField8.getText());
- String tipo_alimento = jTextField9.getText();
- String nombre_rec = jTextField10.getText();
- // 1. Get a connection to database
- myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/menu","root","");
- // 2. Create a statement
- String sql = "insert into ingredientes"
- + " (id_ing, nombre_ing, peso_ing, calorias_ing,tipo_alimento_ing,nombre_rec)"
- + " values (null, ?, ?, ?, ?, ?)";
- myStmt = myConn.prepareStatement(sql);
- // set param values
- //myStmt.setInt(1, codigo);
- myStmt.setString(1, nombre);
- myStmt.setDouble(2, peso);
- myStmt.setDouble(3, calorias);
- myStmt.setString(4, tipo_alimento);
- myStmt.setString(5, nombre_rec);
- // 3. Execute SQL query
- myStmt.executeUpdate();
- myStmt.close();
- myConn.close();
- System.out.println("Insert complete.");
- } catch (SQLException exc) {
- System.out.println(exc);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement