📄 balance_do.jsp

📁 一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现

💻 JSP

字号:

<script language="JavaScript">
<!--
function CheckForm()
{
   alert("错误！！！");
   return false;
}
// -->
</script>
<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>结算</title>
</head>
<body>
<jsp:useBean id="dbcon" scope="page" class="bb.Dbcon" />
<jsp:useBean id="login" scope="session" class="bb.login" />
<%if(login.dept!=4&&login.dept!=5)
  {
%>
<jsp:forward page="index.jsp"/>
<% 
  }
%>
<%
  String year=request.getParameter("year");
  String month=request.getParameter("month");
  if((year==null||month==null)&&login.dept==4)
  {
%>
<script language="JavaScript">
  CheckForm();
  document.location.href="finance.jsp"
</script>	
<%
  }else if((year==null||month==null)&&login.dept==5)
  {
%> 
<script language="JavaScript">
  CheckForm();
  document.location.href="manager.jsp"
</script>
<%	  
  }   
%>
<div align="center"><span class="style3">结算</span><BR>
</div>
<BR>
<% 
  ResultSet rs=null;
  float income1=0f,payout1=0f,profit=0f;

  Connection con=dbcon.getConn();
  String sql="select * from tpb.income where time like '"+year+"-"+month+"'";
  Statement stmt=con.createStatement();
  rs=stmt.executeQuery(sql);
  while(rs.next())
  {
	  income1+=rs.getFloat("amount");
  }
  String sql1="select * from tpb.payout where time like '"+year+"-"+month+"'";
  Statement stmt1=con.createStatement();
  rs=stmt1.executeQuery(sql1);
  while(rs.next())
  {
	  payout1+=rs.getFloat("amount");
  }
  profit=income1+payout1;
%>
<%=request.getParameter("year")%>年<%=request.getParameter("month")%>月盈利：
<%=profit %>元
<%
  rs.close();
  stmt.close();
  dbcon.Close();
%>
<hr>
<a href="balance.jsp">返回</a>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -