All pastes #203318 Raw Edit

Unnamed

public java v1 · immutable
#203318 ·published 2006-10-15 01:59 UTC
rendered paste body
     try                {                    //Driver :-)                    DriverManager.registerDriver(new org.gjt.mm.mysql.Driver());                      //conexion de la BD                    Connection conexion = DriverManager.getConnection ("jdbc:mysql://localhost/prueba","spider", "spider");                                         // Preparamos la consulta                    Statement s = conexion.createStatement();                    //ResultSet rs = s.executeQuery ("select * from persona where nombre = ' + unir + ' ");                    ResultSet rs = s.executeQuery ("select * from persona where nombre = ?");                    rs.setString(1, unir);                                        while (rs.next())                    {                        System.out.println (+ rs.getInt (1) + " " + rs.getString (2)+ " " + rs.getString(3) +                                 " " + rs.getString(4) + " " + rs.getString(5));                    }                                //Cerrar la conexion                     conexion.close();                                    }catch (SQLException e)                {                    e.printStackTrace();                }                                //Hacer eco de a información del paquete al cliente                 display.appendText("\n\nDevolviendo datos al cliente...");                sendpacket = new DatagramPacket(data,data.length, receivepacket.getAddress(),5001);                sendsocket.send(sendpacket);                display.appendText("Paquete enviado\n");                                            }catch(IOException exception)            {                display.appendText(exception.toString() + "\n");                exception.printStackTrace();            }