Difference between revisions of "Password protecting pages"
From MyWiki
| Line 4: | Line 4: | ||
String getIt = "SELECT user from sessions where session = '"+session.getId()+"'"; | String getIt = "SELECT user from sessions where session = '"+session.getId()+"'"; | ||
stmt = conn.createStatement(); | stmt = conn.createStatement(); | ||
| + | rs = stmt.executeQuery(getIt); | ||
| + | |||
| + | if ( rs.next() ) { | ||
| + | USERNAME = rs.getString("user") ; | ||
| + | out.println("Your username is : "+USERNAME); | ||
| + | int length = USERNAME.length(); | ||
| + | } | ||
| + | else response.sendRedirect("login.jsp"); | ||
</source> | </source> | ||
Revision as of 09:48, 4 November 2014
A working example from GetNewUser, needs improving :
1. Look up the session information
String getIt = "SELECT user from sessions where session = '"+session.getId()+"'"; stmt = conn.createStatement(); rs = stmt.executeQuery(getIt); if ( rs.next() ) { USERNAME = rs.getString("user") ; out.println("Your username is : "+USERNAME); int length = USERNAME.length(); } else response.sendRedirect("login.jsp");
