This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
System.out.println("rs.getString(1)"+rs.getString(1));//prints email@example.com 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..