Hi,
I am using at session state throughout my application but in one class it
does not seem to be setting/getting the user in one class?
Any idea's?
public class JoinLeague {
private Connection conn;
private PreparedStatement prep;
@Property
@SessionState
private User user;
private PrivateLeague temp;
private String user2;
private String user3;
private String user4;
private String user5;
private String user6;
private String user7;
private String user8;
private String user9;
private String user10;
public JoinLeague() throws Exception {
createDb();
conn.close();
}
public void createDb() throws Exception {
Handler handler = new Handler();
conn = handler.getConnection();
prep = handler.getPreparedStatement();
}
public void assignUsers() throws Exception {
try {
createDb();
String statement = "select * from private";
prep = conn.prepareStatement(statement);
ResultSet rs = (ResultSet) prep.executeQuery();
while(rs.next()) {
temp = new PrivateLeague();
temp.setMem2(rs.getString("user2"));
user2 = temp.getMem2();
temp.setMem3(rs.getString("user3"));
user3 = temp.getMem3();
temp.setMem4(rs.getString("user4"));
user4 = temp.getMem4();
temp.setMem5(rs.getString("user5"));
user5 = temp.getMem5();
temp.setMem6(rs.getString("user6"));
user6 = temp.getMem6();
temp.setMem7(rs.getString("user7"));
user7 = temp.getMem7();
temp.setMem8(rs.getString("user8"));
user8 = temp.getMem8();
temp.setMem9(rs.getString("user9"));
user9 = temp.getMem9();
temp.setMem10(rs.getString("user10"));
user10 = temp.getMem10();
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void updateUsers() throws Exception {
createDb();
if(user2 == null) {
String statement1 = "Update private set user2=?;";
prep = conn.prepareStatement(statement1);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user3 == null){
String statement2 = "Update private set user3=?;";
prep = conn.prepareStatement(statement2);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user4 == null){
String statement3 = "Update private set user4=?;";
prep = conn.prepareStatement(statement3);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user5 == null){
String statement4 = "Update private set user5=?;";
prep = conn.prepareStatement(statement4);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user6 == null){
String statement5 = "Update private set user6=?;";
prep = conn.prepareStatement(statement5);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user7 == null){
String statement6 = "Update private set user7=?;";
prep = conn.prepareStatement(statement6);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user8 == null){
String statement7 = "Update private set user8=?;";
prep = conn.prepareStatement(statement7);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user9 == null){
String statement8 = "Update private set user9=?;";
prep = conn.prepareStatement(statement8);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
else if(user10 == null){
String statement9 = "Update private set user10=?;";
prep = conn.prepareStatement(statement9);
prep.setString(1, user.getUsername());
prep.executeUpdate();
}
}
}
--
View this message in context:
http://tapestry.1045711.n5.nabble.com/Session-State-not-setting-user-tp3698456p3698456.html
Sent from the Tapestry - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
