API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
180
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 11.83 KB | None | 0 0
raw download clone embed print report
  1. /*co
  2.  * To change this license header, choose License Headers in Project Properties.
  3.  * To change this template file, choose Tools | Templates
  4.  * and open the template in the editor.
  5.  */
  6. package bdpersona;
  7.  
  8. import com.mysql.jdbc.*;
  9. import java.sql.DriverManager;
  10. import java.sql.ResultSet;
  11. import java.sql.SQLException;
  12.  
  13. /**
  14.  *
  15.  * @author matia
  16.  */
  17. public class jfIngresar extends javax.swing.JFrame {
  18.     private Statement sentencia;
  19.     private Connection conexion;
  20.     private String nomBD="BDPersona";
  21.     private String usuario="root";
  22.     private String password="";
  23.     private String msj;
  24.    
  25.     /**
  26.      * Creates new form jfIngresar
  27.      */
  28.     public jfIngresar() {
  29.         initComponents();
  30.         conectar();
  31.         llenarCombo();
  32.     }
  33.    
  34.     public void llenarCombo(){
  35.         //cmbNombre.removeAllItems();
  36.         try{
  37.         sentencia=(Statement)conexion.createStatement();
  38.         ResultSet lista=sentencia.executeQuery("SELECT nombre FROM persona");
  39.         while(lista.next()){
  40.           cmbNombre.addItem(lista.getString("nombre"));  
  41.         }
  42.         }
  43.         catch(SQLException ed){
  44.                 msj="no se pudo seleccionar";
  45.                 }
  46.     }    
  47.     public void conectar(){
  48.         try{
  49.             Class.forName("com.mysql.jdbc.Driver");
  50.             String url="jdbc:mysql://localHost:3306/"+this.nomBD;
  51.             this.conexion=(Connection)DriverManager.getConnection(url,this.usuario, this.password);
  52.             this.sentencia=(Statement)this.conexion.createStatement();
  53.         }
  54.         catch(Exception e){
  55.             msj="Error al conectar";
  56.         }
  57.     }
  58.  
  59.     /**
  60.      * This method is called from within the constructor to initialize the form.
  61.      * WARNING: Do NOT modify this code. The content of this method is always
  62.      * regenerated by the Form Editor.
  63.      */
  64.     @SuppressWarnings("unchecked")
  65.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  66.     private void initComponents() {
  67.  
  68.         jPanel1 = new javax.swing.JPanel();
  69.         jLabel1 = new javax.swing.JLabel();
  70.         txtNombre = new javax.swing.JTextField();
  71.         jLabel2 = new javax.swing.JLabel();
  72.         txtRut = new javax.swing.JTextField();
  73.         jLabel3 = new javax.swing.JLabel();
  74.         txtEdad = new javax.swing.JTextField();
  75.         cmdGuardar = new javax.swing.JButton();
  76.         cmdSalir = new javax.swing.JButton();
  77.         lblFlag = new javax.swing.JLabel();
  78.         cmbNombre = new javax.swing.JComboBox<>();
  79.  
  80.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  81.         setMinimumSize(new java.awt.Dimension(500, 400));
  82.         setPreferredSize(new java.awt.Dimension(500, 400));
  83.  
  84.         jPanel1.setMinimumSize(new java.awt.Dimension(500, 400));
  85.  
  86.         jLabel1.setText("Nombre: ");
  87.  
  88.         jLabel2.setText("Rut: ");
  89.  
  90.         jLabel3.setText("Edad: ");
  91.  
  92.         txtEdad.addActionListener(new java.awt.event.ActionListener() {
  93.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  94.                 txtEdadActionPerformed(evt);
  95.             }
  96.         });
  97.  
  98.         cmdGuardar.setMnemonic('g');
  99.         cmdGuardar.setText("Guardar");
  100.         cmdGuardar.addActionListener(new java.awt.event.ActionListener() {
  101.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  102.                 cmdGuardarActionPerformed(evt);
  103.             }
  104.         });
  105.  
  106.         cmdSalir.setMnemonic('s');
  107.         cmdSalir.setText("Salir");
  108.         cmdSalir.addActionListener(new java.awt.event.ActionListener() {
  109.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  110.                 cmdSalirActionPerformed(evt);
  111.             }
  112.         });
  113.  
  114.         lblFlag.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
  115.  
  116.         cmbNombre.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
  117.  
  118.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  119.         jPanel1.setLayout(jPanel1Layout);
  120.         jPanel1Layout.setHorizontalGroup(
  121.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  122.             .addGroup(jPanel1Layout.createSequentialGroup()
  123.                 .addComponent(cmdGuardar)
  124.                 .addGap(87, 87, 87)
  125.                 .addComponent(cmdSalir)
  126.                 .addGap(0, 289, Short.MAX_VALUE))
  127.             .addGroup(jPanel1Layout.createSequentialGroup()
  128.                 .addContainerGap()
  129.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  130.                     .addComponent(lblFlag, javax.swing.GroupLayout.PREFERRED_SIZE, 459, javax.swing.GroupLayout.PREFERRED_SIZE)
  131.                     .addGroup(jPanel1Layout.createSequentialGroup()
  132.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  133.                             .addComponent(jLabel1)
  134.                             .addComponent(jLabel2)
  135.                             .addComponent(jLabel3))
  136.                         .addGap(18, 18, 18)
  137.                         .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  138.                             .addComponent(txtNombre)
  139.                             .addComponent(txtRut)
  140.                             .addComponent(txtEdad, javax.swing.GroupLayout.DEFAULT_SIZE, 109, Short.MAX_VALUE))
  141.                         .addGap(71, 71, 71)
  142.                         .addComponent(cmbNombre, javax.swing.GroupLayout.PREFERRED_SIZE, 173, javax.swing.GroupLayout.PREFERRED_SIZE)))
  143.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  144.         );
  145.         jPanel1Layout.setVerticalGroup(
  146.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  147.             .addGroup(jPanel1Layout.createSequentialGroup()
  148.                 .addGap(22, 22, 22)
  149.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  150.                     .addComponent(jLabel1)
  151.                     .addComponent(txtNombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  152.                 .addGap(18, 18, 18)
  153.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  154.                     .addComponent(jLabel2)
  155.                     .addComponent(txtRut, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  156.                 .addGap(18, 18, 18)
  157.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  158.                     .addComponent(jLabel3)
  159.                     .addComponent(txtEdad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  160.                     .addComponent(cmbNombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  161.                 .addGap(55, 55, 55)
  162.                 .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  163.                     .addComponent(cmdGuardar)
  164.                     .addComponent(cmdSalir))
  165.                 .addGap(40, 40, 40)
  166.                 .addComponent(lblFlag, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
  167.                 .addContainerGap(134, Short.MAX_VALUE))
  168.         );
  169.  
  170.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  171.         getContentPane().setLayout(layout);
  172.         layout.setHorizontalGroup(
  173.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  175.                 .addGap(23, 23, 23)
  176.                 .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  177.                 .addContainerGap())
  178.         );
  179.         layout.setVerticalGroup(
  180.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  181.             .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  182.         );
  183.  
  184.         pack();
  185.     }// </editor-fold>                        
  186.  
  187.     private void txtEdadActionPerformed(java.awt.event.ActionEvent evt) {                                        
  188.         // TODO add your handling code here:
  189.     }                                      
  190.  
  191.     private void cmdSalirActionPerformed(java.awt.event.ActionEvent evt) {                                        
  192.         System.exit(0);
  193.         // TODO add your handling code here:
  194.     }                                        
  195.  
  196.     private void cmdGuardarActionPerformed(java.awt.event.ActionEvent evt) {                                          
  197.         String nom,rut;
  198.             nom=txtNombre.getText();
  199.             rut=txtRut.getText();
  200.         byte edad = Byte.parseByte(txtEdad.getText());
  201.         String sql="INSERT INTO persona(rut,nombre,edad)VALUES('" + rut + "','" + nom + "',"+ edad + ")";
  202.         try{
  203.             sentencia.executeUpdate(sql);
  204.             msj="Datos guardados";
  205.             lblFlag.setText(msj);
  206.         }
  207.         catch(SQLException e){
  208.             msj="no ingresado";
  209.             lblFlag.setText(msj);
  210.         }
  211.     }                                          
  212.  
  213.     /**
  214.      * @param args the command line arguments
  215.      */
  216.     public static void main(String args[]) {
  217.         /* Set the Nimbus look and feel */
  218.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  219.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  220.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  221.          */
  222.         try {
  223.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  224.                 if ("Nimbus".equals(info.getName())) {
  225.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  226.                     break;
  227.                 }
  228.             }
  229.         } catch (ClassNotFoundException ex) {
  230.             java.util.logging.Logger.getLogger(jfIngresar.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  231.         } catch (InstantiationException ex) {
  232.             java.util.logging.Logger.getLogger(jfIngresar.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  233.         } catch (IllegalAccessException ex) {
  234.             java.util.logging.Logger.getLogger(jfIngresar.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  235.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  236.             java.util.logging.Logger.getLogger(jfIngresar.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  237.         }
  238.         //</editor-fold>
  239.  
  240.         /* Create and display the form */
  241.         java.awt.EventQueue.invokeLater(new Runnable() {
  242.             public void run() {
  243.                 new jfIngresar().setVisible(true);
  244.             }
  245.         });
  246.     }
  247.  
  248.     // Variables declaration - do not modify                    
  249.     private javax.swing.JComboBox<String> cmbNombre;
  250.     private javax.swing.JButton cmdGuardar;
  251.     private javax.swing.JButton cmdSalir;
  252.     private javax.swing.JLabel jLabel1;
  253.     private javax.swing.JLabel jLabel2;
  254.     private javax.swing.JLabel jLabel3;
  255.     private javax.swing.JPanel jPanel1;
  256.     private javax.swing.JLabel lblFlag;
  257.     private javax.swing.JTextField txtEdad;
  258.     private javax.swing.JTextField txtNombre;
  259.     private javax.swing.JTextField txtRut;
  260.     // End of variables declaration                  
  261. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!