usermoneykouchu.jsp

来自「项目名叫网上图书馆」· JSP 代码 · 共 49 行

<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<jsp:useBean id="data" class="com.yourcompany.struts.datebase.Database" scope="session"/>
<%
String name=request.getParameter("name");
int jk=Integer.parseInt(request.getParameter("jk"));
ResultSet rs=(ResultSet)data.getregister(name);
int select=0;
while(rs.next())
{
	if(Integer.parseInt(rs.getString("money"))>jk)
	{
	select=Integer.parseInt(rs.getString("money"))-jk;
	}
	else
	{
	%>
	<script language="javascript">
	alert('对不起！您的余额不足！请充值！');
	window.location="usermoneyadd.jsp";
	</script>
	<% 
	}
}
if(select>=0)
{
String se=String.valueOf(select);
boolean tag=data.money_update(name,se);
if(tag)
{
%>
<script language="javascript">
	alert('已成功从账户中扣除！');
	window.location="page.jsp";
	</script>
<%
}
else
{
%>
<script language="javascript">
	alert('操作失败！');
	window.location="orderinfo.jsp";
	</script>
<%
}
}
%>