<%@ page contentType="text/html;charset=GBK" %>
<% response.setContentType("text/html;charset=GBK");%>
<% request.setCharacterEncoding("GBK"); %>
<%@ page import="java.util.Hashtable" %>
<%@ include file="../inc/connection.jsp" %>
<%! // ===== class =====
class UserInfo
{
public UserInfo(){}
String name = "";
String email = "";
String rid = "";
String verify_code = "";
boolean isValid = false;
}
%>
<%!
UserInfo getUserInfo(Connection con, String rid, String verifyCode)
throws Exception
{
UserInfo objRtn = null;
if (rid==null || "".equals(rid) || verifyCode==null || "".equals(verifyCode))
return objRtn;
PreparedStatement pst = null;
ResultSet rs = null;
String sql = "select * from mois_referral where rid = ? and verify_code = ?";
pst = con.prepareStatement(sql);
pst.setString(1, rid);
pst.setString(2, verifyCode);
rs = pst.executeQuery();
if (rs.next())
{
objRtn = new UserInfo();
objRtn.isValid = true;
objRtn.name = rs.getString("r_name");
objRtn.email = rs.getString("r_email");
objRtn.rid = rid;
objRtn.verify_code = verifyCode;
}
rs.close();
pst.close();
return objRtn;
}
%>
<%
String rid = request.getParameter("rid");
if (rid==null) rid = "";
String verify_code = request.getParameter("verify_code");
if (verify_code==null) verify_code = "";
String refer = request.getHeader("referer");
if (refer==null)
refer = "";
if(verify_code.length() > 1)
refer = "email";
refer = java.net.URLEncoder.encode(refer,"utf-8");
String flash_vars = "";
UserInfo u = getUserInfo(con,rid,verify_code);
if (!con.isClosed())
con.close();
//Remove other source
//TBD
//?name=element&email=element@elementvisual.net&rid=1111&verify_code=29239&source=
if (u!=null && u.isValid)
flash_vars = "refer="+refer+"&username="+u.name+"&referral_email="+u.email+"&referral_id="+u.rid+"&verify_code="+u.verify_code;
else
flash_vars = "refer="+refer;
%>
Clinique倩碧水嫩保湿系列