public boolean findUser(String un, String pwd) {

    Connection con = null;
    try {
      con = DBConnectionFactory.getConnection();
      String sql =
          "select count(uname) from user_details"
              + " where uname='"
              + un
              + "' and pass='******'";
      PreparedStatement st = con.prepareStatement(sql);
      ResultSet rs = st.executeQuery();
      rs.next();
      int count = rs.getInt(1);
      return (count == 1);
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      try {
        con.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    } // finally
    return false;
  }