public SessionUserVO findUserSessionInfo(String dsName, String dbType, String userLogin) throws DAOException
{
Connection con = null;
PreparedStatement stmt = null;
ResultSet rset = null;
SessionUserVO userSess = new SessionUserVO();
try
{
con = super.createConnection(dsName);
String sql = QueryManager.getInstance().getUserSessionInfoQuery(dbType);
stmt = con.prepareStatement(sql);
stmt.setString(1, userLogin);
rset = stmt.executeQuery();
if (rset.next())
{
userSess = new SessionUserVO();
userSess.setUserId(rset.getString(1));
userSess.setProfileId(rset.getString(2));
userSess.setFirstName(rset.getString(3));
userSess.setMiddleName(rset.getString(4));
userSess.setLastName(rset.getString(5));
userSess.setPosition(rset.getString(6));
userSess.setAgency(rset.getString(7));
userSess.setUserLoginId(rset.getString(8));
userSess.setProfileReportId(rset.getString(9));
userSess.setDefaultPage(rset.getString(10));
userSess.setDefaultMenu(rset.getString(11));
}
}
catch(SQLException se)
{