checkaccount.jsp

来自「运输模块代码」· JSP 代码 · 共 49 行

<%--
  Created by IntelliJ IDEA.
  User: Ligang Wu
  Date: 2006-5-20
  Time: 18:14:57
  To change this template use File | Settings | File Templates.
--%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
	//定义变量
	String account = "";
    String subacct = "";
    String sql = "";
    ASResultSet Rs = null;
    int flag = 0;
	//获得组件参数

	//获得页面参数
	account = DataConvert.toRealString(iPostChange,(String)request.getParameter("Account"));
    subacct = DataConvert.toRealString(iPostChange,(String)request.getParameter("Subacct"));
    System.out.println("account:"+account);
    System.out.println("subacct"+subacct);
   //选择customer表
    sql = " select * from customer where account ='" +account+ "' and subacct='"+subacct+"'";
    System.out.println("accountSql:"+sql);
    Rs = Sqlca.getASResultSet(sql);
    if(Rs.next()) {
        //如果存在
        flag = 2;
  %>
<script language=javascript>
	self.returnValue = "<%=flag%>";
	self.close();
</script>
<%
    }
     else{
          //记录不存在
          flag = 1;
%>
 <script language=javascript>
	self.returnValue = "<%=flag%>";
	self.close();
</script>
<%
        }
%>

<%@ include file="/IncludeEnd.jsp"%>