if (username != null && username != \ String sql = \ ResultSet rs = conn.executeQuery(sql); int id = -1; String truename = \ String PWD = \ String city = \ String address = \ String postcode = \ String cardNO = \ String cardType = \ String tel = \ String email = \ if (rs.next()) { id = rs.getInt(1); truename = rs.getString(3); PWD = rs.getString(4); city = rs.getString(5); address = rs.getString(6); postcode = rs.getString(7); cardNO = rs.getString(8); cardType = rs.getString(9); tel = rs.getString(12); email = rs.getString(13); } %>