📄 do_add_orderform.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" import="java.util.Date" import="java.util.Random"
import="java.net.URL"%>
<HTML>
<BODY>
<%
String memberno=request.getParameter("memberno");
byte[] get_memberno=memberno.getBytes("ISO-8859-1");
memberno= new String(get_memberno,"GB2312");
String prono=request.getParameter("prono");
byte[] get_prono=prono.getBytes("ISO-8859-1");
prono= new String(get_prono,"GB2312");
String total=request.getParameter("total");
byte[] get_total=total.getBytes("ISO-8859-1");
total= new String(get_total,"GB2312");
int total2=Integer.parseInt(total);
String orderno=request.getParameter("orderno");
byte[] get_orderno=orderno.getBytes("ISO-8859-1");
orderno= new String(get_orderno,"GB2312");
Date Now=new Date();
String date=(Now.getYear()+1900)+"/";
date=date+(Now.getMonth()+1)+"/";
date=date+Now.getDate();
/*数据库连接部分的操作*/
Connection con=null;
ResultSet rs=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con=DriverManager.getConnection ("jdbc:odbc:bookshop","sa","");
String amount=null;
String proprice="";
int x=0;
String SQLstr="select * from product where prono=?";
String SQLstr2="insert into orderform values (?,?,?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(SQLstr);
pstmt.setString(1,prono);
rs=pstmt.executeQuery();
while(rs.next())
{
proprice=rs.getString("proprice");
x=Integer.parseInt(proprice)*total2;}
amount=String.valueOf(x);
pstmt=con.prepareStatement(SQLstr2);
pstmt.setString(1,orderno);
pstmt.setString(2,memberno);
pstmt.setString(3,prono);
pstmt.setString(4,total);
pstmt.setString(5,date);
pstmt.setString(6,amount);
int n= pstmt.executeUpdate();
if(n>0)
{out.print("添加新订单成功");out.print("<br>");
out.print("<a href=login.jsp>返回首页</a>") ;out.print(" ");
out.print("<a href=add_orderform.jsp>继续添加</a>") ;}
pstmt.close();
con.close();
}
catch(SQLException e)
{ out.print(e);
out.print("对不起，添加订单失败，请重新添加新订单。<br>");
out.print("<li><font color=red>可能出错的原因：</font><br>");
out.print("<li>订单已存在：<br>");
out.print("<li>确认您有此权限：<br>");
out.print("<li>没有完整输入订单信息信息：<br><br><br>");
out.print("<a href=login.jsp>返回首页</a>") ;out.print(" ");
out.print("<a href=add_orderform.jsp>重新添加新订单</a>") ;
}
%>
</BODY>
</HTML>
<!--遇到的问题：订单的号码用随机函数产生，订单金额的计算通过查询出所定书籍的价格来计算。
-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -