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);

            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);

            }
        } catch (Exception e) {
            e.printStackTrace();
        }
         salidaDatos.writeUTF(tt2);

            }

   }
}