📄 do_join_m.jsp
字号:
<html>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>添加回款信息</title>
</head>
<jsp:useBean id="db" scope="page" class="sale.dbBean" />
<body>
<p align="center"><font size="6" color="#000080">添加回款信息</font></p>
<hr>
<%
String id=new String();
id=(String)session.getAttribute("id");
if(id==null)
{
response.sendRedirect("index.htm");
}
%>
<%
String m_id=new String(request.getParameter("m_id"));
String date=new String(request.getParameter("date"));
String d_id=new String(request.getParameter("d_id"));
String arr=new String(request.getParameter("arr"));
String money=new String(request.getParameter("money"));
String cuid=new String(request.getParameter("cuid"));
String sql=new String();
String url=new String();
ResultSet rs=null;
String errorcode="";
sql="select * from money where id='"+m_id+"'";
rs=db.executeQuery(sql);
if(rs.next())
{
rs.close();
%>
<p align="center">该回款编号已经存在</p>
<p align="center"><a href="join_m.jsp"><font color="#000080">请重新输入</font></a></p>
<%
}
else
{
sql="insert into money (id,cuid,money1,arr,date1,did) values('"+m_id+"','"+cuid+"','"+money+"','"+arr+"','"+date+"','"+d_id+"')";
db.executeInsert(sql);
%>
<p align="center">您已经成功添加该信息！</p>
<div align="center">
<table border="0" width="60%">
<tr>
<td width="50%">
<p align="center">回款编号</td>
<td width="50%">
<%=m_id%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">回款金额</td>
<td width="50%">
<%=money%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">总欠款</td>
<td width="50%">
<%=arr%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">回款日期</td>
<td width="50%">
<%=date%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">片区编号</td>
<td width="50%">
<%=d_id%>
</td>
</tr>
<tr>
<td width="50%">
<p align="center">客户编号</td>
<td width="50%">
<%=cuid%>
</td>
</tr>
</table>
</div>
<p align="center"><a href="money.jsp"><font color="#000080">返回</font></a>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -