%@page contentType="text/html;charset=gb2312" errorPage="isErrorPage.jsp"
import="java.sql.*,java.util.Date,java.math.*,java.util.*"%>
<%
String applicantId = null;
applicantId = (String)session.getAttribute("applicantId");
String userId = (String)session.getAttribute("userId");
String LoginId= (String)session.getAttribute("userName");
//ResultSet rs = null;
if(applicantId == null||userId == null)
{
response.sendRedirect(response.encodeRedirectURL("../register/Login.jsp?"+request.getRequestURI()+"?"+request.getQueryString()));
}
String ColumnId ="102";
String applicant = request.getParameter("applicant");
String Rights = "";
Rights = (String)session.getAttribute("Rights");
try{
if(Rights==null)
response.sendRedirect(response.encodeRedirectURL("./noauth.jsp"));
if(Rights==null)
response.sendRedirect(response.encodeRedirectURL("./noauth.jsp"));
if(Rights.indexOf("102;") < 0)
{
response.sendRedirect(response.encodeRedirectURL("./noauth.jsp"));
}
}
catch(IllegalStateException e){}
%>
网上政务
<%
String company1 = "";
String company2 ="";
String address ="";
String name1 ="";
String name2 ="";
String name3 ="";
String name4 ="";
String name5 ="";
String gender1 ="";
String gender2 ="";
String gender3 ="";
String gender4 ="";
String gender5 ="";
String nationality1 ="";
String nationality2 ="";
String nationality3 ="";
String nationality4 ="";
String nationality5 ="";
String duty1 ="";
String duty2 ="";
String duty3 ="";
String duty4 ="";
String duty5 ="";
String enter_date ="";
String validity_date ="";
String validity_num ="";
String stay ="";
String destination ="";
String visa_place ="";
String reason ="";
String comment1 ="";
String comment2 ="";
String unit1 ="";
String unit2 ="";
String link ="";
String phone ="";
int readonly = 1;
//out.print("==============="+LoginId);
//ResultSet rs =null;
try
{
String sn = "";
// rs = dbean.executeQuery("select * from application where ApplicantId='"+applicantId+"' order by AppTime desc");
ResultSet rs = dbean.executeQuery("select * from [foreign] where app_serialnum = (select top 1 serialnum from Application where ApplicantId='"+ LoginId +"' order by apptime desc)");
if(rs.next())
{ %>
<%
company1 = rs.getString("company1");
company2 =rs.getString("company2");
address =rs.getString("address");
name1 =rs.getString("name1");
name2 =rs.getString("name2");
name3 =rs.getString("name3");
name4 =rs.getString("name4");
name5 =rs.getString("name5");
gender1 =rs.getString("gender1");
gender2 =rs.getString("gender2");
gender3 =rs.getString("gender3");
gender4 =rs.getString("gender4");
gender5 =rs.getString("gender5");
nationality1 =rs.getString("nationality1");
nationality2 =rs.getString("nationality2");
nationality3 =rs.getString("nationality3");
nationality4 =rs.getString("nationality4");
nationality5 =rs.getString("nationality5");
duty1 =rs.getString("duty1");
duty2 =rs.getString("duty2");
duty3 =rs.getString("duty3");
duty4 =rs.getString("duty4");
duty5 =rs.getString("duty5");
enter_date =rs.getString("enter_date");
validity_date =rs.getString("validity_date");
validity_num =rs.getString("validity_num");
stay =rs.getString("stay");
destination =rs.getString("destination");
visa_place =rs.getString("visa_place");
reason =rs.getString("reason");
comment1 =rs.getString("comment1");
comment2 =rs.getString("comment2");
unit1 =rs.getString("unit1");
unit2 =rs.getString("unit2");
link =rs.getString("link");
phone =rs.getString("phone");
}
}
catch(SQLException e)
{
//e.printStackTrace();
}
//catch(ArrayIndexOutOfBoundsException e){}
%>
 |
 |
外国人商务签证及工作签证申请 |
|
[相关下载] |
[申请商务签证]
[申请工作签证]
|
 |
外国人商务签证及工作签证通知表申请流程
广州市各区外经贸局联络电话
|
越秀区:37663658
|
海珠区:84247507
|
|
荔湾区:81406826
|
天河区:38622695
|
|
白云区:86579545
|
黄埔区:82378702
|
|
花都区:36913298
|
番禺区:84690917
|
|
南沙区:84986051
|
萝岗区:82111517
|
|
从化市:37903800
|
增城市:82751160
|
| 业务咨询电话:38920415, 38920416 |
|
|
|
 |
| |
[联系我们]
[ 网站地图]
[ 关于我们]
广州市对外贸易经济合作局主办 广州市电子数据交换中心协办
Copyright © 2004 未经允许 不得转载
|
|