wrong???

Question

没有错。
String sTemp = "select BookNo, Name, EnglishName, Sex, Company, Department, Position, Email, OfficeTel, OfficeFax, Mobile, BP, HomeCountry, HomeCity, HomeDistrict, HomeStreet, HomePostCode, HomeTel1, HomeTel2, Description, Birthday, NativePlace, CompanyCountry, CompanyCity, CompanyDistrict, CompanyStreet, CompanyPostCode, EMPID,OPENFLG from TBL_PERSONALADDRESSBOOK where ( empid = ? ) OR (empid <> ? AND OPENFLG = ? ) order by email";
        try
        {
          preparedstatement = connection.prepareStatement(sTemp);
          preparedstatement.setInt(1, b);//这些你有没有设
          preparedstatement.setInt(2, b);
          preparedstatement.setString(3, "1");
          resultset = preparedstatement.executeQuery();
...........

Answer 1

没错呀!不过你如果只是进行这样定下来的查询的话,建议你还是使用Statement简单!