?? user.jsp
字號:
<%@page contentType="text/html" import="java.sql.*,com.classmoney.servlet.condb"%><%@page pageEncoding="GB2312"%><% if (session.getAttribute("username")==null) { response.sendRedirect("login.html"); }//判斷session是否為空%><script language="javascript"> function loginout() { if(confirm("系統提示，你確定要退出嗎？")) location.href="login.html"; return false; }</script><style type="text/css"><!--.td_title { BORDER-RIGHT: #e0e0e0 1px solid; BORDER-TOP: #e0e0e0 1px solid; BORDER-LEFT: #e0e0e0 1px solid; COLOR: #666666; BORDER-BOTTOM: #e0e0e0 1px solid; BACKGROUND-COLOR: #f6f6f6}--></style><link href="css/style.css" rel="stylesheet" type="text/css" /><body> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="120" align="center" class="left_1_ArticleTitle">歡迎：<span class="left_2_ArticleTitle"><%=session.getAttribute("username")%> </span> 你唯一能做的事情就是看下總帳了，</td> </tr> </table> <% 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));//string型的轉換為double %> <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> <tr><td colspan="2">沒事情的話就點擊<a href="logout.do" onClick="loginout();" ><span class="left_2_ArticleTitle">退出</span></a>吧,反正你也做不了什么！如果需要做什么，請直接跟生活委員聯系。</td></tr> </table> <% } catch (Exception e) { } %> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="left_2_articles"> <tr> <td height="120"><p>©2007 <STRONG>班級班費管理系統</STRONG> Powered By <A href="mailto:vottot@163.com">vottot</A></p></td> </tr></table></body>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -