PreparedStatement 命名参数 查询
网上找到的都有错,我改良了其中一个,可以正常使用!!
如下:
调用方法:
String query = "select * from people where (first_name = :name or last_name
= :name) and address = :address");
NamedParameterStatement p = new NamedParameterStatement(con, query);
p.setString("name", name);
p.setString("address", address);
ResutlSet rs=p.executeQuery();
。。。。。。。。