السلام عليكم ورحمة الله وبركاته
كيف أستطيع ارجاع results إلى client لكي يعرض الجدول في client
class server:
import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.Properties;
import javax.swing.JOptionPane;
class DataServer
{
static String query="";
static ResultSet rs;
static Statement st;
static Connection con;
static String result="";
private static Connection on;
public static void main(String args[]) throws Exception
{
try
{
ServerSocket datasersoc = new ServerSocket(4444);
Socket datasoc = datasersoc.accept();
System.out.println("connection client : "+(datasoc.getInetAddress().getHostName()));
ObjectOutputStream oos = new ObjectOutputStream(datasoc.getOutputStream());
ObjectInputStream ois = new ObjectInputStream(datasoc.getInputStream());
query = ois.readObject()+"";
System.out.println(query);
// String s="ok client send database" ;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/tp_hicahm","root", "root");
System.out.println("the connection set");
Statement stat = conn.createStatement();
//String selectQuery = "Select * from hicham";
ResultSet results = stat.executeQuery(query);
System.out.println("the reslut as the follwoing : ");
System.out.println( "id " + "\t" + "user"+"\t"+"email");
System.out.println("----" +"\t" + "----"+ "\t" +"---");
while (results.next())
{
System.out.println(results.getInt("id") +"\t" +results.getString("user")+"\t" +results.getString("email") );
}
oos.writeObject(results);
}
catch (Exception e) {
JOptionPane.showMessageDialog(null,e.getMessage());
System.exit(0);
}}
}class client:
import java.net.*;
import java.io.*;
import java.sql.*;
class client
{
public static void main(String arg[])
{
String query="";
String result ="";
try
{
Socket Soc = new Socket("127.0.0.1",4444);
ObjectOutputStream oos = new ObjectOutputStream(Soc.getOutputStream());
ObjectInputStream ois = new ObjectInputStream(Soc.getInputStream());
BufferedInputStream in = new BufferedInputStream(ois);
/**************************************************************************************/
BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); //reader consol
query = br.readLine();
// System.out.println(query);
/*****************************************************************************************/
oos.writeObject(query);
result = ois.readObject()+"";
System.out.println(result);
}
catch(Exception e)
{
System.out.println("Connection Closed client ");
}
}
}:sad: :sad: