Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- Connection conectar = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conectar = (Connection) DriverManager.getConnection("jdbc:mysql://127.0.0.1/proyecto", "root", "");
- } catch (ClassNotFoundException ex) {
- Logger.getLogger(datos.class.getName()).log(Level.SEVERE, null, ex);
- } catch (SQLException ex) {
- Logger.getLogger(datos.class.getName()).log(Level.SEVERE, null, ex);
- }
- try{
- String id=this.jTextField9.getText();
- Statement s=conectar.createStatement();
- ResultSet rs=s.executeQuery("SELECT id,Nombre,Apellido,Email,Telefono,Compañia,Posicion,Foto,Ruta,Nota FROM datos WHERE id='"+id+"'");
- if(rs.next()){
- jTextField1.setText(rs.getString(1));
- jTextField2.setText(rs.getString(2));
- jTextField3.setText(rs.getString(3));
- jTextField4.setText(rs.getString(4));
- jTextField5.setText(rs.getString(5));
- jTextField6.setText(rs.getString(6));
- jTextField7.setText(rs.getString(7));
- jTextField8.setText(rs.getString(8));
- Image i=null;
- Blob blob=rs.getBlob("Foto");
- i=javax.imageio.ImageIO.read(blob.getBinaryStream());
- ImageIcon image=new ImageIcon(i);
- jLabel10.setIcon(image);
- jTextField10.setText(rs.getString(10));
- }
- else{
- JOptionPane.showMessageDialog(null,"El contacto" +id+ "no se encuentra");
- }
- } catch (SQLException ex) {
- Logger.getLogger(datos.class.getName()).log(Level.SEVERE, null, ex);
- } catch (IOException ex) {
- Logger.getLogger(datos.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
Add Comment
Please, Sign In to add comment