Java

Java RSS

help! - illegal state of expression

•

Join Date: Aug 2009

Posts: 2

Reputation: mithunthakkar is an unknown quantity at this point

Solved Threads: 0

mithunthakkar mithunthakkar is offline

Offline

Newbie Poster

help! - illegal state of expression

Aug 21st, 2009

hey friends,
im getting this error illegal state of expression
plz help me wid this

Connection db = DriverManager.getConnection(connectURL);
Statement stmt = db.createStatement();
String c = request.getParameter("criteria");
String a = request.getParameter("value");
ResultSet rs;
if(c.equals("BillNo")){
--error-- rs = stmt.executeQuery("select * from orders where billNo="+a+);
}else if(c.equals("UserId")){
--error-- rs = stmt.executeQuery("select * from orders where userid="+a+);
}
else if(c.equals("ProductId")){
--error-- rs = stmt.executeQuery("select * from orders where productid="+a+);
}

•

Join Date: Jul 2007

Posts: 1,175

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 125

stephen84s stephen84s is offline

Offline

Veteran Poster

Re: help! - illegal state of expression

Aug 21st, 2009

This is just plain old Java syntax error, the operator "+" in Java is used to concatenate String objects, remove the extra plus after "a" in all the three statements and you should be good to go,

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
if(c.equals("BillNo")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where billNo="+a+);
}else if(c.equals("UserId")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where userid="+a+);
}
else if(c.equals("ProductId")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where productid="+a+);
}
if(c.equals("BillNo")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where billNo="+a+);
}else if(c.equals("UserId")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where userid="+a+);
}
else if(c.equals("ProductId")){
/*--error--*/ rs = stmt.executeQuery("select * from orders where productid="+a+);
}

Also just a point to remember next time wrap your code inside code tags as shown below it will give you syntax highlighting as shown above.

[code=java]
// Your code here
[/code]

Last edited by stephen84s; Aug 21st, 2009 at 3:06 am.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"