📄 money_delete_p.jsp

📁 JSP+oracle开发实例精粹》随书光盘
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="qyxx.connectDB" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="../css/style.css" rel="stylesheet" type="text/css">
<title>查看记录</title>
</head>
<%
	ResultSet rs = null;
	String user = (String)session.getAttribute("username");
	try
	{
		String sql = "select * from QYXX_MONEY where money_priority = '1' and money_men = '"+user+"' order by money_time";;
		rs = db.executeQuery(sql);
		if(rs.next())
		{
			%>
			<form name="add_form" action="money_deal.jsp?action=delete" method="post">
			<table width="300">
			<tr>
			<td></td>
			<td align="center">借/贷</td>
			<td align="center">数目</td>
			<td align="center">时间</td>
			</tr>
			<%
				int id = rs.getInt("id");
			%>
			<tr style="cursor:hand">			
			<td><input type="checkbox" name="id" value="<%=id%>"></td>
			<a onclick="javascript:window.open('money_detail.jsp?id=<%=id%>&action=show','查看借贷记录','height=400,width=400')">
			<td align="center"><%=("1".equals(rs.getString("jiedai")) ? "借" : "贷")%></td>
			<td align="center"><%=rs.getString("mount")%></td>
			<td align="center"><%=rs.getString("money_time")%></td></a>			
			</tr>
			<%
				while(rs.next())
				{
					id = rs.getInt("id");
			%>
				<tr style="cursor:hand" >				
				<td><input type="checkbox" name="id" value="<%=id%>"></td>
				<a onclick="javascript:window.open('money_detail.jsp?id=<%=id%>&action=show','查看借贷记录','height=400,width=400')">
				<td align="center"><%=("1".equals(rs.getString("jiedai")) ? "借" : "贷")%></td>
				<td align="center"><%=rs.getString("mount")%></td>
				<td align="center"><%=rs.getString("money_time")%></td></a>				
				</tr>
			<%
				}
			%>
			<tr>
			<td colspan="3" align="center"><input type="submit" value="删除" class="logbutton"></td>
			</tr>
			</table>
			</form>
			<%
		}
		else
		{
			session.setAttribute("error","2");
			response.sendRedirect("error.jsp");
		}
	}
	catch(Exception e)
	{
		session.setAttribute("error","1");
		response.sendRedirect("error.jsp");
	}
	finally
	{
		try
		{
			db.closeDB();
			rs.close();
		}
		catch(Exception ee)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
%>
</html>
⌨️ 快捷键说明

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