This week's book giveaway is in the Programmer Certification forum. We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
System.out.println("rs.getString(1)"+rs.getString(1));//prints firstname.lastname@example.org System.out.println("rs.getString(2)"+rs.getString(2));//prints test subject1
System.out.println("rs.getString(3)"+rs.getString(3));//prints test content
Always the best practise is to store the resultsets values to local varibales and use the variables hence forth. This is because ResultSet implementation differs from one driver implementation to another.. and you cannot rely on calling the rs.getString(1) more than once will yeild resultts always..