Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Proyecto;
- import java.net.*;
- import java.io.*;
- import java.sql.*;
- class servidor {
- static Connection canal = null;
- static Statement instruccion=null;
- static ResultSet rs;
- static String tt1;
- static String tt2;
- static String libro ;
- static String s;
- static String respuesta;
- static int Contador=0;
- public static void main (String[] args) throws IOException, SQLException {
- System.out.println("Servidor funcionando");
- ServerSocket servSocket = new ServerSocket(9001);
- while (true) {
- Socket socket = servSocket.accept();
- OutputStream salida = socket.getOutputStream();
- DataOutputStream salidaDatos = new DataOutputStream(salida);
- InputStream entrada = socket.getInputStream();
- DataInputStream entradaDatos = new DataInputStream(entrada);
- System.out.println("atendiendo a cliente");
- tt1=entradaDatos.readUTF();
- System.out.println("*"+tt1+"*");
- try {
- Class.forName("com.mysql.jdbc.Driver");
- canal = DriverManager.getConnection("jdbc:mysql://localhost:3306/movil", "root", "silvana");
- // String tt1= "TALA";
- instruccion = canal.createStatement();
- //System.out.println("antes del selec");
- ResultSet rs = instruccion.executeQuery(
- "select * from libro where libro.libro= '"+tt1+"'");
- // System.out.println("despues del selec");
- while (rs.next()) {
- tt2=(rs.getString(1) + " " + rs.getString(2)
- + " " + rs.getString(3)+" "+rs.getString(4));
- System.out.println(""+tt2);
- }
- salidaDatos.writeUTF(tt2);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement