mi da questo errore:
"java.net.ConnectException: Connection refused: connect"
Il server è cosi'..anche qui nn so se ho fatto giusto..anzi!
La cosa che mi da da pensare è il collegamento al database..ho provato a fare come si fa nella servlet ma nn so se vada bene lo stesso.
GRAZIE MILLE!!!
codice:import java.net.*; import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class Server{ public static void main(String args[]){ Socket cs = null; ServerSocket ss = null; String dbUrl="jdbc:odbc:Cucina"; String user="laurafranca"; String password="dory"; String[] ingy; float[] qtyy; String[] ingout; float[] qtyout; try{ ss = new ServerSocket(2222); while(true){ cs=ss.accept(); ObjectOutputStream os1= new ObjectOutputStream(cs.getOutputStream()); // ObjectOutputStream os2= new ObjectOutputStream(cs.getOutputStream()); ObjectInputStream is1= new ObjectInputStream(cs.getInputStream()); DataInputStream is2= new DataInputStream(cs.getInputStream()); DataOutputStream os3 = new DataOutputStream(cs.getOutputStream()); ingy = (String[])is1.readObject(); //array ricetta qtyy = (float[])is1.readObject(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c = DriverManager.getConnection(dbUrl,user,password); Statement s = c.createStatement(); ResultSet r = s.executeQuery("SELECT * FROM Dispensa"); int i=0; int x=0; while(r.next()){ x++; } String[] ingd = new String[x]; //array dispensa float[] qtyd = new float[x]; int h=0; ingout = new String[h]; //array output spesa qtyout = new float[h]; while(r.next()){ ingd[i] = r.getString("Ingredienti"); qtyd[i] = r.getFloat("Quantità"); i++; } for(int j=0; j<ingy.length; j++){ for(int k=0; k<ingd.length; k++){ if (ingy[j]==ingd[k]){ float q = qtyy[j] - qtyd[k]; if (q>0){ ingout[h] = ingy[j]; qtyout[h] = q; h++; } } } } os3.write(h); for(int a=0; a<h; a++){ os1.writeObject(ingout[a]); os3.writeFloat(qtyout[a]); } os1.close(); os3.close(); is1.close(); is2.close(); } } catch(UnknownHostException e){ System.err.println("Host Unknown"); } catch(Exception e){ System.err.println(e); } } }


Rispondi quotando