allmoney.jsp

来自「一个简单的班费管理系统」· JSP 代码 · 共 46 行

JSP
46
字号
<%@page contentType="text/html" import="java.sql.*,com.classmoney.servlet.condb"%><%@page pageEncoding="GB2312"%><%    if (session.getAttribute("admin")==null)        {            response.sendRedirect("index.html");        }%><link href="css/style.css" rel="stylesheet" type="text/css" /><body>     <%                    try                    {                    Connection conn = condb.getConnection();                     Statement stmt=conn.createStatement();                    String sql="select sum(cmoney) from smoney where moneytype=1";                    String sql1="select sum(cmoney) from smoney where moneytype=2";                    ResultSet rs=stmt.executeQuery(sql);                   // ResultSet rs1=stmt.executeQuery(sql1);                    rs.next();                    double shouru=Double.parseDouble(rs.getString(1));                                        %>	<table width="100%" border="0" cellspacing="10" cellpadding="10">                <tr><td>总共收入:</td><td><%=shouru%>元</td></tr>                <%                    ResultSet rs1=stmt.executeQuery(sql1);                                       rs1.next();                    double zhichu=Double.parseDouble(rs1.getString(1));                %>                <tr><td>总共支出:</td><td><%=zhichu%>元</td></tr>                 <tr><td>剩下余额:</td><td><%=shouru-zhichu%>元</td></tr>                </table>                                  <%                                        }                     catch (Exception e) {    }                                                                      %></body>

⌨️ 快捷键说明

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