when i compile this code it gives the following error:
abc.java:52: incompatible types
found : boolean
required: java.sql.ResultSet
ResultSet rsB=stB.execute(sqlB);
^
1 error
STRANGE!!!help me please!!!
import java.io.*;
import java.net.*;
import java.sql.*;
class A
{
public static void main(
String str[])
{
new B("POST");
}
}
class B extends
Thread {
String job;
Connection con;
B(String job)
{
this.job=job;
this.start();
}
public void run()
{
if(job.equals("POST"))
{
try
{
new C();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc
dbc:ForestDev","forestdev","forestdev");
Socket sB=new Socket("localhost",9090);
PrintWriter outB=new PrintWriter(sB.getOutputStream(),true);
BufferedReader brB=new BufferedReader(new InputStreamReader(sB.getInputStream()));
Statement stB=con.createStatement();
String sqlB="select * from transfer";
ResultSet rsB=stB.execute(sqlB);
while(rsB.next())
{
String sqlTemp=rsB.getString(2);
outB.println(sqlTemp);
String status=brB.readLine();
System.out.println(status);
}
rsB.close();
stB.close();
sB.close();
con.close();
outB.close();
brB.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
}
class C
{
Connection con;
C()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc
dbc:ForestDev","forestdev","forestdev");
ServerSocket ssC=new ServerSocket(9090);
Socket sC=null;
sC=ssC.accept();
PrintWriter outC=new PrintWriter(sC.getOutputStream(),true);
BufferedReader brC=new BufferedReader(new InputStreamReader(sC.getInputStream()));
while(true)
{
String sqlC=brC.readLine();
Statement stC=con.createStatement();
stC.execute(sqlC);
outC.println("done");
stC.close();
}
/* con.close();
sC.close();
ssC.close();
outC.close();
brC.close();*/
}
catch(Exception e)
{
System.out.println(e);
}
}
}