📄 querybankcredit.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="bankCredit" class="src.wuyang.BankCredit" 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>InsertBankCredit</TITLE>
<link rel="stylesheet" href="css.css" type="text/css">
</HEAD>
<%
if (request.getParameter("delete")!=null){ 
	bankCredit.setBankCreditId(Integer.parseInt(request.getParameter("bankCreditId")));
	int rtcode = bankCredit.delete();
	String url="";
	if(rtcode >= 0) 
		url="QueryBankCredit.jsp";
	else
		url="../pub/DBErr.jsp?rtcode=-1";
	
	response.sendRedirect(url);	
}
bankCredit.query("","noteTime DESC");
%>
<BODY bgcolor=#949b93><table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top">
      <blockquote>
          
        <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>
            <td class="text"> 
              <div align="center"><b>贷</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>摘要</b></div>
            </td>
            <td width="1%">&nbsp;</td>
          </tr>
          <%
	while(bankCredit.next()>0){
%>
          <tr> 
            <form method="post" action="QueryBankCredit.jsp">
              <input type="hidden" name="bankCreditId" value="<%=bankCredit.getBankCreditId()%>">
              <td class="textb"> <%=bankCredit.getStringDate(bankCredit.getNoteTime(),0)%> 
              </td>
              <td class="textb" align="right"> <%=bankCredit.doubleFormat(bankCredit.getDebit(),2)%> </td>
              <td class="textb" align="right"> <%=bankCredit.doubleFormat(bankCredit.getLoan(),2)%> </td>
              <td class="textb"> <%=bankCredit.getComment()%> </td>
              <td width="1%" class="textb"> 
                <input type="submit" name="delete" value="删除" />
              </td>
            </form>
          </tr>
          <%
	}
%>
        </table>
      </blockquote>
    </td>
  </tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明

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