Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. //boto
  2. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  3.  
  4. //guargar en variables los datos ingresados por el jtextfield
  5.  
  6. int codigo= Integer.parseInt(CODIGO.getText());
  7. String producto=PRODUCTO.getText();
  8. String proveedor=PROVEEDOR.getText();
  9. int costo= Integer.parseInt(COSTO.getText());
  10. int ganancia =Integer.parseInt(GANANCIA.getText());
  11. int total_precio=Integer.parseInt(TOTAL_PRECIO.getText());
  12.  
  13.  
  14. //conectar a la bd y insertar datos
  15.  
  16. try {
  17.  
  18. Class.forName("com.mysql.jdbc.Driver");
  19. com.mysql.jdbc.Connection conexion = (com.mysql.jdbc.Connection) DriverManager.getConnection("jdbc:mysql://localhost/enterprise", "root", "");
  20.  
  21. // Preparamos la consulta
  22. com.mysql.jdbc.Statement s = (com.mysql.jdbc.Statement) conexion.createStatement();
  23. int rs = s.executeUpdate("insert into inventario values(null,'" +codigo+ "','" + producto + "','"+proveedor+"','"+costo+"','"+ganancia+"','"+total_precio+"')");
  24. //insert
  25. //validacio de registro
  26. JOptionPane.showMessageDialog(null,"PRODUCTO INGRESADO CON EXITO!");
  27.  
  28. } catch (Exception e) {
  29. e.printStackTrace();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement