<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*, users.databases.*"
%>
<%
/***** VARIABLE DECLARATION and INITIALIZATION *****/
String strMainDB = "product_pgpClientInfoDB";
String strLogName = "", strTitle = "", strCompanyNames = "";
String [] arrCompanyID, arrCompanyName;
int ctr = 0;
int intUserID = Integer.parseInt(request.getParameter("uid"));
int intCompanyID = Integer.parseInt(request.getParameter("cid"));
byte bytDeptID = Byte.parseByte(request.getParameter("did"));
/***** END OF VARIABLE DECLARATION *****/
String SQLstmt = "SELECT Usr_LogName FROM tblUserPwd WHERE Pwd_ID=" + intUserID + ";";
users.connect(strMainDB);
ResultSet rs = users.listQuery(SQLstmt);
while (rs.next()) {
strLogName = rs.getString("Usr_LogName");
}
SQLstmt = "SELECT Co_Name, Co_ID FROM tblCompanyInfo WHERE Usr_ID=" + intUserID + ";";
rs = users.listQuery(SQLstmt);
while (rs.next()) {
ctr++; // TO GET TOTAL APPROVED (ON-LINE) ACCT OF THE USER (M-USER), USE FOR DEFINING ARRAY
}
arrCompanyID = new String[ctr];
arrCompanyName = new String[ctr];
rs.beforeFirst();
ctr = 0;
while (rs.next()) { // WHILE THERE EXISTS AN APPROVED (ON-LINE) ACCT, GET THE NAME AND ID NUMBER
arrCompanyID[ctr] = rs.getString("Co_ID");
arrCompanyName[ctr] = rs.getString("Co_Name");
ctr++;
}
users.disconnect();
if (ctr<=1) { // USER HAS ONLY ONE ACCT ON-LINE
strTitle = "";
} else { // USER HAS MORE THAN ONE ACCT ON-LINE
if (ctr==2) { // USER HAS TWO ACCTS ON-LINE
strTitle = "OTHER COMPANY";
} else if (ctr>2) { // USER MORE THAN TWO ACCTS ON-LINE
strTitle = "OTHER COMPANIES";
}
for (int i=0; i17) { // SHORTENS COMPANY NAME IF IT'S MORE THAN 17 CHAR
strCoName = strCoName.substring(0,15) + "...";
}
strCompanyNames += "
" + strCoName + "";
}
}
}
/***** MERGING WITH HTML CODES STARTS HERE *****/
%>
USER PROFILE
User: <%= strLogName %>
Change Password
Change e-mail address
View Profile
<%= strTitle %>
<%= strCompanyNames %>