?? allmoney.jsp
字號(hào):
<%@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>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -