Getting column name instead of values in prepared statement

Question

I am getting column name instead of values in prepared statement. here is my piece of code:
string q="select ? from EMPLOYEE where salary>?";
prepared pst=connectionobject.preparedstatement(q);
pst.setstring(1,"FIRST_NAME");
pst.setint(2,10000);

please help

Answer 1

I want to set values, I figured out a way using string concatenation but I wonder why set doesn't work properly....

Answer 2

sorry I meant get...

Answer 3

I don't want to get the name from resultset containing other columns instead I want the resultset to contain only the name without any other column,... if that makes sense

Answer 4

just tell me how to set first "?" value correctly(that is select ? from employee where salary>?)

I am saying this because actually in my program I set the column name dynamically from jcombobox

Answer 5

thanks for the reply.
by the way that's what I did string concatenation...
so you are saying there is no way we can set ? using setxxx() method

Answer 6

do you want to get or set the values? I would do it ways different

Answer 7

you need 'pst.executeUpdate()' in the end, and maybe a commit

Answer 8

statement st= st.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM EMPLOYEE WHERE salary>10000");
while(rs.hasnext())
{
string name = rs.getString("name");
.....
}

kind of this, you are trying to set the values in your code..

Answer 9

working now?

Answer 10

yeah Just change the select statement to: SELECT name FROM ..then you get just the name, but you still should use the while loop

Answer 11

easiest way is: st.executeQuery("SELECT " +column name+ " FROM EMPLOYEE WHERE salary > " + salary);

Answer 12

yes you can set values with the set method but you need to execute the set commands with executeUpdate() method in the end, but then you set the value in the database