%--
* Company : lance
* @Author : xqyu
* Date : 2002-1-15
* @Modifier :
* Date :
--%>
<%@ page import="java.sql.*" contentType="text/html;charset=ISO8859_1"%>
<%// if ((String)fs_com.utils.CookieUtils.getCookie(request,"reg_no")==null || !((String)fs_com.utils.CookieUtils.getCookie(request,"emp_type")).equals("1")) response.sendRedirect("/program/msg.jsp?path=/zh_index.jsp&msg_type=failure&msg_type=failure&msg="+URLEncoder.encode("您的身份标志消失,请重新登录后再试"));%>
<%@ page import="java.util.*,java.net.*,fs_com.utils.*" %>
<%
try{
String sReg_no = "",strsql = "",strName="",strID="",strPhone="";
String strBirthday="",strEmail = "",strSex = "";
Connection conn=null;
PreparedStatement Pres = null;
ResultSet rst=null;
sReg_no=(String)fs_com.utils.CookieUtils.getCookie(request,"reg_no");
sReg_no="0000078342";
conn=CSQL.getConnection();
strsql="select name,sex,id,h_phone,birthday,email from programmer.FS_PERSON_INFO where reg_no = ?";
Pres = conn.prepareStatement(strsql);
Pres.setString(1,sReg_no);
rst = Pres.executeQuery();
//rst = CMedical.GetInfo(sReg_no);
//out.println(rst);
if (rst.next())
{
strName = CTools.code2Html(CTools.toISO(rst.getString("NAME")));
strSex = CTools.code2Html(CTools.toISO(rst.getString("sex")));
strID = CTools.code2Html(CTools.toISO(rst.getString("ID")));
strPhone = CTools.code2Html(CTools.toISO(rst.getString("H_PHONE")));
strBirthday = CTools.code2Html(CTools.toISO(rst.getString("birthday")));
strEmail = CTools.code2Html(CTools.toISO(rst.getString("EMAIL")));
}
rst.close();
Pres.close();
conn.close();
%>
玫瑰俱乐部
<%
}
catch(Exception sqe)
{
throw new Exception(sqe.getMessage());
}
%>