ps=ct.prepareStatement("select*fromuserswhereusernamelike'%%'");ps.setString(1,uname);异常如下：java.sql.SQLException:Parameterindexoutofrange(1>numberofparameters,whichis0).

Question

ps=ct.prepareStatement("select * from users where username like '% % '"); ps.setString(1,uname);
异常如下：
java.sql.SQLException:Parameter index out of range (1 > number of parameters,w
hich is 0).

Answer 1

ps=ct.prepareStatement("select * from users where username like ?");
ps.setString(1,"%"+uname+“%”);