个人理财系统界面设计登入界面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" % ><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>个人理财系统</title></head><body background="1.jpg"><center><form method="get" action="2.jpg"><br><br><br><br><br><br><table width="281" border="2" bgcolor="#D0FFFC"><tr><td width="269" align="right"><br><h2 align="center">欢迎进入个人理财系统</h2></td></tr><tr><td><br>用户账号<input name="usename" type="text" size="26"><br><br>用户密码<input name="usepass" type="password" size="28" ><br><br><br><br ><input type="submit" name="sub" value="登录"> <input type="reset" name="res" value="取消" ></td></tr></table></form></center></body></html>主页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>JSP Page</title></head><body background="file:///d|/我的文档/web1/1.jpg"></body></html><%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page</title></head><body background="file:///d|/我的文档/未命名站点1/1.jpg"></body></html><%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page</title></head><body background="file:///d|/我的文档/web1/1.jpg"></body></html><%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page</title></head><body background="file:///d|/我的文档/web1/1.jpg"></body></html>收入页面查询收入页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><% Connection con=null;Statement st=null;ResultSet rs=null;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con=DriverManager.getConnection("jdbc:odbc:ch08"); st=con.createStatement();String sql="selcet * from shouru;rs=st.executeQuery(sql);%><table align="center" width="1000"><tr><td>查看收入信息</td><td><a href="addshouru.jsp">增加收入信息</a></td><td><a href="deleteshouru.jsp">删除收入信息</a></td> <td><a href="ymodifshouru.jsp">修改收入信息</a></td> </tt></table><br><hr><br><table align="center" border="1" width="400"><tr><th colspon="2">查看收入信息</th></tr><tr><td>收入编号</td><td><%=rs.GetString("IncomeID")%></td></tr><td>收入来源</td><td><%=rs.GetString("IncomeID")%></td></tr><td>收入物资</td><td><%=rs.GetString("InKind")%></td></tr><td>收入类型</td><td><%=rs.GetString("InKind")%></td></tr><td>收入时间</td><td><%=rs.GetString("InTime")%></td></tr><td>收入金额</td><td><%=rs.GetString("InTime")%></td></tr><td>备注</td><td><%=rs.GetString("Remark")%></td></tr></table><%}%></form><%rs.close();st.close();con.close();%></body></html>增加收入页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312 " /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="addshouru.jsp"><table align="center" width="1000"><tr><td ><a href="shouru.jsp">查看收入信息</a></td><td>增加收入信息<</td><td><a href="deleteshouru.jsp">删除收入信息</a></td><td><a href="ymodifshouru.jsp">修改收入信息</a></td></tt></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> 增加收入信息</th></tr><tr><td>收入编号</td><td width="255"><input name="IncomeID" type="text" /></td></tr> <tr> <td>收入来源</td><td><input name="IncomeSource" type="text" /></td></tr><tr> <td>收入物资</td><td><input name="IncomeKind" type="text" /></td></tr><tr> <td>收入类型</td><td><input name="InType" type="text" /></td></tr><tr> <td>收入时间</td><td><input name="InTime" type="text" /></td></tr><tr> <td>收入金额</td><td><input name="InAcount" type="text" /></td></tr><tr> <td>备注</td><td><input name="Remark" type="text" /></td></tr><tr align="center"><td colspan="2"><input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>修改收入信息<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="modifyshouru.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankanshouruxinxi.jsp">查看收入信息</td><td><a href="file:///d|/我的文档/未命名站点1/addshouru.jsp">增加收入信息</td><td><a href="shanchushouru">删除收入信息</a></td><td>修改收入信息</td></tt></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> 修改收入信息</th></tr><tr><td>收入编号</td><td width="255"><input name="IncomeID" type="text" /></td></tr> <tr> <td>收入来源</td><td><input name="IncomeSource" type="text" /></td></tr><tr> <td>收入物资</td><td><input name="IncomeKind" type="text" /></td></tr><tr> <td>收入类型</td><td><input name="InType" type="text" /></td></tr><tr> <td>收入时间</td><td><input name="InTime" type="text" /></td></tr><tr> <td>收入金额</td><td><input name="InAcount" type="text" /></td></tr><tr> <td>备注</td><td><input name="Remark" type="text" /></td></tr><tr align="center"><td colspan="2"><input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>删除收入信息<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="deleteshouru.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankanshouruxinxi.jsp">查看收入信息</td><td><a href="file:///d|/我的文档/未命名站点1/addshouru.jsp">增加收入信息</td><td>删除收入信息</td><td><a href="file:///d|/我的文档/未命名站点1/modifyshouru.jsp">修改收入信息</td></tr></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> <p>删除收入信息</p></tr><tr><td align="center" >收入编号<input name="IncomeID" type="text" />输入要删除的收入编号</td></tr><tr><td colspan="2"> <input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>支出页面增加支出<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312 " /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="addzhichu.jsp"><table align="center" width="1000"><tr><td ><a href="zhichu.jsp">查看支出信息</a></td><td>增加支出信息</td><td><a href="deletezhichu.jsp">删除支出信息</a></td><td><a href="ymodifzhichu.jsp">修改支出信息</a></td></tt></table><p> </p><p><br></p><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> 增加支出信息</th></tr><tr><td>支出编号</td><td width="255"><input name="OutID" type="text" /></td> </tr><tr><td>支出原因</td><td><input name="OutReason" type="text" /></td></tr><tr><td>支出物资</td><td><input name="OutKind" type="text" /></td></tr><tr><td>支出类型</td><td><input name="OutType" type="text" /></td><td><select name="select 1" size="1"><option value="1">交通支出</option><option value="2">交通支出</option><option value="3">购物支出</option><option value="4">居家支出</option><option value="5">娱乐支出</option><option value="6">医教支出</option><option value="7">餐饮支出</option><option value="8">其他支出</option></select></td></tr><tr><td>支出时间</td><td><input name="OutTime" type="text" /></td></tr><tr><td>支出金额</td><td><input name="OutAcount" type="text" /></td></tr><tr><td>备注</td><td><input name="Remark" type="text" /></td></tr><tr align="center"><td colspan="2"><input name="sure" type="submit" value="确认" /> <input name="clear" type="submit" value="取消" /></td></tr></table></form></body></html>修改支出页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312 " /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="modifyzhichu.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankanshouruxinxi.jsp">查看收入信息</td><td><a href="file:///d|/我的文档/未命名站点 1/addshouru.jsp">增加收入信息</td><td><a href="shanchuzhichu">删除支出信息</a></td><td>修改支出信息</td></tt></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> 修改支出信息</th></tr><tr><td>支出编号</td><td width="255"><input name="OutID" type="text" /></td></tr><tr> <td>支出原因</td><td><input name="OutReason" type="text" /></td></tr><tr> <td>支出物资</td><td><input name="OutKind" type="text" /></td></tr><tr> <td>支出类型</td><td><input name="OutType" type="text" /></td><td><select name="select 1" size="1"><option value="1">交通支出</option><option value="1">交通支出</option><option value="1">购物支出</option><option value="1">居家支出</option><option value="1">娱乐支出</option><option value="1">医教支出</option><option value="1">餐饮支出</option><option value="1">其他支出</option></select></td></tr><tr> <td>支出时间</td><td><input name="OutTime" type="text" /></td></tr> <tr> <td>支出金额</td><td><input name="OutAcount" type="text" /></td></tr> <tr> <td>备注</td><td><input name="Remark" type="text" /></td></tr><tr align="center"><td colspan="2"><input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>查看支出页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><% Connection con=null;Statement st=null;ResultSet rs=null;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con=DriverManager.getConnection("jdbc:odbc:ch08");st=con.createStatement();String sql="selcet * from zhichu;rs=st.executeQuery(sql);%><table align="center" width="1000"><tr><td>查看支出信息</td><td><a href="addzhichu.jsp">增加支出信息</a></td><td><a href="deletezhichu.jsp">删除支出信息</a></td><td><a href="modifzhichu.jsp">修改支出信息</a></td></tt></table><br><hr><br><table align="center" border="1" width="400"><tr><th colspon="2">查看支出信息</th></tr><tr><td>支出编号</td><td><%=rs.GetString("OutID")%></td></tr><td>支出原因</td><td><%=rs.GetString("OutReason")%></td></tr><td>支出物资</td><td><%=rs.GetString("OutKind")%></td></tr><td>支出类型</td><td><%=rs.GetString("OutKind")%></td></tr><td>支出时间</td><td><%=rs.GetString("IOutTime")%></td></tr><td>支出金额</td><td><%=rs.GetString("IOutTime")%></td></tr><td>备注</td><td><%=rs.GetString("Remark")%></td></tr></table><%}%></form><%rs.close();st.close();con.close();%></body></html>删除支出页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="deletezhichu.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankanzhhichu.jsp">查看支出信息</td><td><a href="file:///d|/我的文档/未命名站点1/addzhichu.jsp">增加支出信息</td> <td>删除支出信息</td><td><a href="file:///d|/我的文档/未命名站点1/modifyzhichu.jsp">修改支出信息</td></tr></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> <p>删除支出信息</p></tr><tr><td align="center" >支出编号<input name="IncomeID" type="text" />输入要删除的支出编号</td></tr><tr><td colspan="2"> <input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>统计页面删除统计信息<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="modifyshouru.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankantongji .jsp">查看统计信息</td><td><a href="file:///d|/我的文档/未命名站点1/addtongji.jsp">增加统计信息</td> <td><a href="shanchutongji">删除统计信息</a></td><td>修改统计信息</td></tr></table><br><hr><br><table align="center" width="400"><tr><th width="105" colspon="2"> 修改统计信息</th></tr><tr><td>统计编号</td><td width="195"><input name="SumID" type="text" /></td></tr> <tr> <td>统计类型</td><td><input name="SumType" type="text" /></td><td width="84"><select name="select2" size="1"><option value="1">支出统计</option><option value="2">收入统计</option><option value="3">日期统计</option></select></td></tr><tr> <td>统计时间</td><td><input name="SumTime" type="text" /></td></tr><tr> <td>统计金额</td><td><input name="SumAcount" type="text" /></td></tr><tr> <td>说明</td><td><input name="Remark" type="text" /></td></tr><tr align="center"><td colspan="2"><input name="sure" type="submit" value="确认"> <input name="clear" type="submit" value="取消"></td></tr></table></form></body></html>删除统计信息页面<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>JSP Page/title></head><body bgcolor="pink"><form method="post" action="deletetongji.jsp"><table align="center" width="1000"><tr><td ><a href="file:///d|/我的文档/未命名站点1/chankantongji.jsp">查看统计信息</td><td><a href="file:///d|/我的文档/未命名站点1/addtongji.jsp">增加统计信息</td> <td>删除统计信息</td><td><a href="file:///d|/我的文档/未命名站点1/modifytongji.jsp">修改统计信息</td></tr></table><br><hr><br><table align="center" width="400"><tr><th width="133" colspon="2"> <p>删除统计信息</p></tr><tr><td align="center" >统计编号。