/** Creates new form PrincipalCliente */ public ModificarAdmin() { initComponents(); conexioninicio ci = new conexioninicio(); ci.conectar(); this.setSize(470, 650); this.setLocationRelativeTo(null); // Centra la ventana Splash try { Connection con = DriverManager.getConnection(ci.getURl(), ci.getLogin(), ci.getPassword()); // System.out.println("Conexion a la base de datos cliente realizada con exito! "); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM tienda.estado ;"); // obteniendo la informacion de las columnas que estan siendo consultadas ResultSetMetaData rsMd = rs.getMetaData(); // La cantidad de columnas que tiene la consulta int cantidadColumnas = rsMd.getColumnCount(); // Establecer como cabezeras el nombre de las columnas // Creando las filas para el Jtable while (rs.next()) { Object[] fila = new Object[cantidadColumnas]; for (int i = 1; i < cantidadColumnas; i++) { jComboBox1.addItem(rs.getObject(i + 1)); } } rs.close(); con.close(); } catch (Exception e) { JOptionPane.showMessageDialog(null, e.getMessage(), "Error", JOptionPane.ERROR_MESSAGE); } }
private void jButton1ActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed conexioninicio ci = new conexioninicio(); Connection con = null; try { Class.forName("org.gjt.mm.mysql.Driver"); con = DriverManager.getConnection(ci.getURl(), ci.getLogin(), ci.getPassword()); Statement stmt = con.createStatement(); String cadenasql = "select nombre,apPat,apMat,calle,numExt,colonia,municipio,cp,email,numTel,curp,idadmon,contraseña,nombreest from persona natural join admin natural join estado where idadmon=" + "'" + User + "'"; ResultSet rs = stmt.executeQuery(cadenasql); while (rs.next()) { nombre.setText(rs.getString("nombre")); apPat.setText(rs.getString("apPat")); apMat.setText(rs.getString("apMat")); calle.setText(rs.getString("calle")); num.setText(rs.getString("numExt")); colonia.setText(rs.getString("colonia")); municipio.setText(rs.getString("municipio")); cp.setText(rs.getString("cp")); email.setText(rs.getString("email")); telefono.setText(rs.getString("numTel")); curp.setText(rs.getString("curp")); idamin.setText(rs.getString("idadmon")); contraseñaactual.setText(rs.getString("contraseña")); this.jComboBox1.setSelectedItem(rs.getString("nombreest")); } } catch (Exception e) { System.out.println(e.getMessage()); } // TODO add your handling code here: } // GEN-LAST:event_jButton1ActionPerformed
/** @param args */ public static void main(String[] args) { try { // dyn init of array of emps Emp[] e = { new Emp(101, "abc", 2400, "23-12-2013"), new Emp(23, "abc1", 20000, "1-1-2013"), new Emp(56, "def", 40000, "20-3-2013") }; // Create empty ArrayList of emps ArrayList<Emp> emps = new ArrayList<>(); // populate AL using array data for (Emp e1 : e) // e1=e[0].... emps.add(e1); // display list contents System.out.println("emps via " + emps); Scanner sc = new Scanner(System.in); System.out.println("Enter emp id & inc to update"); Emp e1 = new Emp(sc.nextInt()); int index = emps.indexOf(e1); if (index == -1) throw new EmpNotFoundException( "Emp with ID " + e1.getId() + " Not found: Updation failed "); double inc = sc.nextDouble(); Emp e2 = emps.get(index); e2.setSal(e2.getSal() + inc); System.out.println("Updated List " + emps); } catch (Exception e) { System.out.println(e.getMessage()); } }
private void jButton3ActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed conexioninicio ci = new conexioninicio(); Connection con = null; Connection con1 = null; try { Class.forName("org.gjt.mm.mysql.Driver"); con = DriverManager.getConnection(ci.getURl(), ci.getLogin(), ci.getPassword()); con1 = DriverManager.getConnection(ci.getURl(), ci.getLogin(), ci.getPassword()); Statement stmt = con.createStatement(); Statement stmts = con1.createStatement(); String cadenasql = "UPDATE persona SET nombre=" + "'" + nombre.getText().toUpperCase() + "'" + "," + "apPat=" + "'" + apPat.getText().toUpperCase() + "'" + "," + "apMat=" + "'" + apMat.getText().toUpperCase() + "'" + "," + "calle=" + "'" + calle.getText().toUpperCase() + "'" + "," + "colonia=" + "'" + colonia.getText().toUpperCase() + "'" + "," + "numExt=" + num.getText() + "," + "municipio=" + "'" + municipio.getText().toUpperCase() + "'" + "," + "numTel=" + "'" + telefono.getText() + "'" + "," + "cp=" + "'" + cp.getText() + "'," + "curp=" + "'" + curp.getText().toUpperCase() + "'," + "idestado=" + "'" + jComboBox1.getSelectedIndex() + "'," + "email=" + "'" + email.getText() + "' where curp = '" + curp.getText() + "'"; String cadenasql2 = "UPDATE admin SET idadmon=" + "'" + idamin.getText() + "',curp=" + "'" + curp.getText().toUpperCase() + "' where curp = '" + curp.getText() + "'"; stmt.executeUpdate(cadenasql); stmts.executeUpdate(cadenasql2); // System.out.print("Se han borrado todos los datos"); JOptionPane.showMessageDialog(this, "ActualizaCION Exitosa"); } catch (Exception e) { System.out.println(e.getMessage()); } // TODO add your handling code here: } // GEN-LAST:event_jButton3ActionPerformed