Guest User

Untitled

a guest
Apr 25th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.92 KB | None | 0 0
  1. public DialogoInserccion(String[] columnas, Object[] filas, String tabla, String BD){
  2. super((JFrame) null, true);
  3. this.filas = filas;
  4. this.columnas = columnas;
  5. this.tabla = tabla;
  6. this.BD = BD;
  7.  
  8. this.conexion = conexion;
  9.  
  10. etiquetas = new JLabel[columnas.length];
  11. campos = new JTextField[columnas.length];
  12.  
  13. for(int i=0; i<columnas.length;i++){
  14. JLabel etiqueta = new JLabel(columnas[i]);
  15. JTextField campo = new JTextField();
  16. etiquetas[i] = etiqueta;
  17. campos[i] = campo;
  18. this.add(etiqueta);
  19. this.add(campo);
  20. }
  21.  
  22. btInsertar = new JButton("Insertar");
  23.  
  24. this.add(btInsertar);
  25.  
  26. btInsertar.addActionListener(new ActionListener() {
  27. @Override
  28. public void actionPerformed(ActionEvent e) {
  29. try {
  30. MySQL.conecta("jdbc:mysql://localhost:3306/" + BD, "pepe", "pepa");
  31. PreparedStatement prst = null;
  32.  
  33. for(int i=0; i<etiquetas.length;i++){
  34. // System.out.println(etiquetas[i].getText());
  35.  
  36. }
  37. MySQL.ejecutaConsulta("SELECT * FROM " + tabla);
  38. ResultSet rs = MySQL.getRs();
  39. String[] columnas = new String[rs.getMetaData().getColumnCount()];
  40.  
  41.  
  42. for(int i=0; i<columnas.length;i++){
  43. columnas[i] = rs.getMetaData().getColumnName(i);
  44. System.out.println("columnas: " + columnas[i]);
  45. }
  46.  
  47.  
  48. for(int i=0; i<columnas.length;i++){
  49. MySQL.ejecutaConsultaAccion("INSERT INTO " +tabla+"("+columnas[i]+")" +
  50. " VALUES("+campos[i].getText()+")");
  51. System.out.println("Tabla: " + columnas[i]);
  52. }
  53.  
  54.  
  55. } catch (ClassNotFoundException ex) {
  56. JOptionPane.showMessageDialog(null, "Clase no encontrada");
  57. } catch (SQLException ex) {
  58. JOptionPane.showMessageDialog(null, "Problema al ejecutar la consulta en diálogo " + ex.getMessage());
  59. }
  60. }
  61. });
  62.  
  63. this.setLayout(new GridLayout(0, 2, 0, 10));
  64. pack();
  65. this.setVisible(true);
  66. }
  67.  
  68. btInsertar.addActionListener(new ActionListener() {
  69. @Override
  70. public void actionPerformed(ActionEvent e) {
  71. try {
  72. MySQL.conecta("jdbc:mysql://localhost:3306/" + BD, "pepe", "pepa");
  73. MySQL.ejecutaConsulta("SELECT * FROM " + tabla);
  74.  
  75. for(int i=0; i<campos.length; i++){
  76. MySQL.ejecutaConsultaAccion("INSERT INTO "+ tabla +"("+etiquetas[i].getText()+")" +
  77. " values("+campos[i].getText()+")");
  78. }
  79.  
  80. } catch (ClassNotFoundException ex) {
  81. JOptionPane.showMessageDialog(null, "Clase no encontrada");
  82. } catch (SQLException ex) {
  83. System.out.println(ex.getMessage() + "n");
  84. }
  85. }
  86. });
Add Comment
Please, Sign In to add comment