%@page import="com.jsrsys.web.*"%>
<%@page import="java.util.*"%>
<%!
JsrUtil u = new JsrUtil();
JsrSQL sql;
String sqlQuery;
String codeWord = "";
String userID = "";
String status = "";
%>
<%
codeWord = request.getParameter("x"); // x = password
if (codeWord == null) codeWord = "";
userID = request.getParameter("u"); // u = UserID
if (userID == null) userID = "";
if (userID.length() == 0)
status = "Please enter LastName and Password:";
else
{
// Who: UserName,FirstName,LastName,CompanyName,InstallationCode,Passcode,email
// Auth: UserName,Authority,Approve_Groups
sql = new JsrSQL("test");
sqlQuery = "Who WHERE LastName='" + userID +"'";
int rowCount = sql.setSelect(sqlQuery);
if (rowCount == 0)
status = "LastName not found";
else
{
status = "***";
sql.setNextRow();
if (!codeWord.equals(sql.getString("Password")))
status = "Password:" + codeWord + " not="
+ sql.getString("Password");
else
{
// Who: UserName,FirstName,LastName,CompanyName,InstallationCode,Passcode,email
user.setValue("WhoID", sql.getString("WhoID"));
user.setValue("FirstName", sql.getString("FirstName"));
user.setValue("LastName", sql.getString("LastName"));
user.setValue("email", sql.getString("email"));
user.setValue("userName", userID);
user.setValue("admin", sql.getString("Admin"));
status = "OK";
}
sql.close();
}
}
if (status.equals("OK"))
{%>
<%
}
%>
Login SHARE JSP Lab
Login SHARE JSP Lab
<%= status %>