⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 companyaccountupdate.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="account" class="src.wuyang.CompanyAccount" scope="page"/>
<jsp:useBean id="company" class="src.wuyang.Company" 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>
<%	}
%>

<html>
<head>
<title>CompanyAccountList</title>
<script language ="javascript" src='../pub/pub.js' type=text/javascript></script>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<%!String companyId;%>
<%!String companyName;%>
<%!int rtcode;%>

<%!int num;%>
<%
	String mode = request.getParameter("mode");
	companyId = request.getParameter("companyId");

	if (request.getParameter("submit2")!=null && !mode.equals("ok")){ 
		account.setGlobal(global);	
	
%>
<jsp:setProperty name="account" property="*" />
<%
	if (mode.equals("update")) 		
		rtcode = account.update();
	else if (mode.equals("insert"))
		rtcode = account.insert();	

	if(rtcode >= 0) {
%>
<jsp:forward page="CompanyAccountUpdate.jsp" > 
	<jsp:param name="mode" value="ok" />
	<jsp:param name="companyId" value="<%=companyId%>" />
</jsp:forward>

<% 	
	}else {  
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="<%=rtcode%>" />
</jsp:forward>
<%
	}
      }
%>

<body bgcolor=#949b93 topmargin="0">
<table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top">
      <blockquote> <%
	int count = company.load(companyId);
	companyName = company.getCompanyName();
	
	if (count>0){
		account.query("companyId='"+companyId+"'","");
%> 
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93"> 
            <td class="text" width="42%"> 
              <div align="center"><b>公司名称</b></div>
            </td>
            <td class="text" width="24%"> 
              <div align="center"><b>开户银行</b></div>
            </td>
            <td class="text" width="25%"> 
              <div align="center"><b>银行帐号</b></div>
            </td>
            <td class="text" width="9%"> 
              <div align="center"><b>&nbsp;</b></div>
            </td>
          </tr>
          <%
	while(account.next()>0){
%> 
          <form method="post" action="CompanyAccountUpdate.jsp">
            <input type="hidden" name="mode" value="update">
            <input type="hidden" name="companyId" value="<%=companyId%>"/>
            <tr> 
              <td class="textb" width="42%"> 
                <div align="center"> 
                  <input type="hidden" name="id" value="<%= account.getId()%>">
                  <%=companyName%></div>
              </td>
              <td width="24%"> 
                <div align="center"> 
                  <input type="text" name="bank" value="<%= account.getBank()%>">
                </div>
              </td>
              <td width="25%"> 
                <div align="center"> 
                  <input type="text" name="bankAccount" value="<%= account.getBankAccount()%>">
                </div>
              </td>
              <td width="9%"> 
                <div align="center"> 
                  <input type="submit" name="submit2" value="修改">
                </div>
              </td>
            </tr>
          </form>
          <%
	}
%> 
          <tr> 
            <form method="post" action="CompanyAccountUpdate.jsp">
              <input type="hidden" name="mode" value="insert">
              <input type="hidden" name="companyId" value="<%=companyId%>"/>
              <td class="textb" width="42%"> <%=companyName%> 
                <div align="center"></div>
              </td>
              <td width="24%"> 
                <div align="center"> 
                  <input type="text" name="bank">
                </div>
              </td>
              <td width="25%"> 
                <div align="center"> 
                  <input type="text" name="bankAccount">
                </div>
              </td>
              <td width="9%"> 
                <div align="center"> 
                  <input type="submit" name="submit2" value="新增">
                </div>
              </td>
            </form>
          </tr>
        </table>
      </blockquote></tr>	
        </table>

        <%
	}
%>
      
    
  

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -