bg_orderupdate.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class BG_orderupdate {

    int c=0;
    SQL_execute exe;


    public int update(HttpServletRequest request, HttpServletResponse response)
    {
        exe=new SQL_execute();
        String Order_id=request.getParameter("orderid");
        String status=request.getParameter("order_state");
        String sql="update Shop_Order_R_Info set Status='"+status+"'  where Order_id='"+Order_id+"'";
        String sql2="update Shop_Order_main set order_state='"+status+"' where R_info_id='"+Order_id+"'";
        try {
            c = exe.update(sql);
            if(c>0)
            {
                c=exe.update(sql2);
            }
            this.colse();
        } catch (Exception ex) {
            this.colse();
        }
        return c;
    }
    public int del(HttpServletRequest request, HttpServletResponse response)
    {
        exe=new SQL_execute();
        String orderid=request.getParameter("orderid");
        String sql="delete from Shop_Order_R_Info where Order_id='"+orderid+"'";
        String sql2="delete from Shop_Order_main where R_info_id='"+orderid+"'";
        try {
            c=exe.update(sql);
            if(c>0)
            {
                c = exe.update(sql2);
            }
            this.colse();
        } catch (Exception ex) {
            System.out.println("进行订单删除时出现错误");
            this.colse();
        }
        return c;
    }
    public void colse()
    {
        exe.close();
    }
}