companyaccountlist.jsp

(Java+SQL)-大型企业JAVA的ERP系统

<jsp:useBean id="account" class="src.wuyang.CompanyAccount" scope="page"/>
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
%>

<%!String companyId;%>
<%!int num;%>
<%
	companyId = request.getParameter("companyId");
	num = account.query("companyId='" + companyId.trim()+"'","");
	if (num == 0){
%> <span class="title">无帐号信息</span> <%
	} else {
%> 
          <table border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" width="88%" cellpadding="0" cellspacing="0">
            <tr bgcolor="#949b93"> 
              <td class="text"> 
                <div align="center"><b>开户银行</b></div>
              </td>
              <td class="text"> 
                <div align="center"><b>银行帐号</b></div>
              </td>
            </tr>
            <%
	while(account.next()>0){
%>
            <tr class="textb"> 
              <td><%= account.getBank() %></td>
              <td><%= account.getBankAccount()%></td>
            </tr>
<%
	}
%>
          </table>
<%
	}
%>