Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //boto
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- //guargar en variables los datos ingresados por el jtextfield
- int codigo= Integer.parseInt(CODIGO.getText());
- String producto=PRODUCTO.getText();
- String proveedor=PROVEEDOR.getText();
- int costo= Integer.parseInt(COSTO.getText());
- int ganancia =Integer.parseInt(GANANCIA.getText());
- int total_precio=Integer.parseInt(TOTAL_PRECIO.getText());
- //conectar a la bd y insertar datos
- try {
- Class.forName("com.mysql.jdbc.Driver");
- com.mysql.jdbc.Connection conexion = (com.mysql.jdbc.Connection) DriverManager.getConnection("jdbc:mysql://localhost/enterprise", "root", "");
- // Preparamos la consulta
- com.mysql.jdbc.Statement s = (com.mysql.jdbc.Statement) conexion.createStatement();
- int rs = s.executeUpdate("insert into inventario values(null,'" +codigo+ "','" + producto + "','"+proveedor+"','"+costo+"','"+ganancia+"','"+total_precio+"')");
- //insert
- //validacio de registro
- JOptionPane.showMessageDialog(null,"PRODUCTO INGRESADO CON EXITO!");
- } catch (Exception e) {
- e.printStackTrace();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement