WebRoot/dingdando.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>

<%
/*
订单添加后台
*/
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
	String keyid =(String)request.getParameter("keyid");
String sj=StaticMethod.getStringDate();
String yh=(String)request.getParameter("yh");
String zt="未处理";
String dz=(String)request.getParameter("dz");
String dh=(String)request.getParameter("dh");
String bz=(String)request.getParameter("bz");
String zj=(String)request.getParameter("zj");
String sql="";
 sql="insert into dingdan(sj,yh,zt,dz,dh,bz,zj) values('"+sj+"','"+yh+"','"+zt+"','"+dz+"','"+dh+"','"+bz+"','"+zj+"')";
//订单SQL 语句
int row=1;
		
try{

		db.open();
		//int row =0;
		row=db.update(sql);
		
			db.open();
		sql="select max(ddid) as ddid from dingdan ";
		rs=db.query(sql);
		
		String ddid="";
		if(rs.next()){
		ddid=rs.getString("ddid");
		}
			db.open();
			System.out.println("update ddmx set zt='已处理',dd='"+ddid+"' where yh='"+yh+"' and zt='未处理'");
			
		db.update("update ddmx set zt='已处理' , dd='"+ddid+"' where yh='"+yh+"' and zt='未处理'");
		
		
		
		
		
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('操作成功');");
out.println("window.location='orders.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('操作失败');");
out.println("window.location='buy.jsp'");
out.println("</script>");
}
db.close();