Please help with the resultset problem

[Boon Subra]

Hi all ,
I am trying to find if a particular string is available in a String using 'instr' function..I dont get the output.The line rs= pstmt.executeQuery is not functioning.Please help me out

public int checkFiles(int acuserid,String fileid,String files)
{

ResultSet rs = null;
PreparedStatement pstmt = null;

int userid=0;
System.out.println("Hai");
try
{
String sql = "select instr(\'"+files+"\',\'"+fileid+"\',1) from clientinfonew where CL_ACUSERID=\'"+acuserid+"\'";
System.out.println(sql);
// I can execute this output in oracle
conn.prepareStatement(sql);
System.out.println("Hello");//okay
rs = pstmt.executeQuery();

//I cannot get the output from here
System.out.println("Hello1111111");
if(rs.next())
{
userid=rs.getInt(1);
System.out.println(userid);
}
rs.close();
pstmt.close();

}
catch(Exception e)
{
userid=0;
}

finally
{
return userid;
}
}
I put the following code in the main method along with the connection
String fileid ="1";
String files="5,2,1";
int stat = clinfo.checkFiles(4,fileid,files);
System.out.println(stat);

I am not able to proceed further .Please help me out.
Thanks to all,
Bhuvana

[Jan Modaal]

what exception does occeur exactly ?
or you could just try using the following:

/**
* Executes an query; typically a static SQL SELECT statement
*
* @param query the query to be executed
* @return the result of the query or null if something went wrong
*/
public ResultSet execute(String query)
{
if(connection == null)
openConnection();
try
{
Statement stmt = connection.createStatement();
return stmt.executeQuery(query);
}
catch(Exception e){ e.printStackTrace(); }
return null;
}

[darryl nortje]

your code "
String sql = "select instr(\'"+files+"\',\'"+fileid+"\',1) from clientinfonew where CL_ACUSERID=\'"+acuserid+"\'";
System.out.println(sql);
// I can execute this output in oracle
conn.prepareStatement(sql);
System.out.println("Hello");//okay
rs = pstmt.executeQuery();
"
Let me guess, you're getting a NullPointerException
try this
pstmt = conn.prepareStatement(sql);
I think that'll help
cheers
Darryl

[Bear Bibeault]

"darryl the second nortje",
We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
Forum Bartender

[Boon Subra]

Hi Daryl and Jan ,,
Thanks for the prompt response.
pstmt= conn.prepareStatement works. I am v.sorry .it was typo error.

Thanks a lot once again.
Bhuvana