delordercartaction.java~6~

来自「采用web2.0技术,采用动态标签,sql语句全部存储在数据库里面.开发速度快.」· JAVA~6~ 代码 · 共 106 行

package com.sztheater.biz.order;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
import java.sql.*;
import com.sztheater.framework.web.*;
import com.sztheater.framework.util.*;
import java.util.*;
import javax.servlet.http.*;
public class DelOrderCartAction extends Action {

    public ActionForward execute(ActionMapping mapping,
                                 ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) throws
            IOException, ServletException {
        int iSuccFlag = 0;
        int iExistsNum = 0;
        String strMsg = "";
        String strSQL = "";
        String target = "";
        String username = "";
        String ProgramID = "";
        String ID = "";
        String SeatID = "";
        boolean flag = true;

        ResultSet rs = null;
        Statement st = null;
        Connection conn = null;

        username 	= ((DelOrderCartForm)form).getUsername();
        ID       	= ((DelOrderCartForm)form).getID();
        ProgramID	= ((DelOrderCartForm)form).getProgramID();
        SeatID      = ((DelOrderCartForm)form).getSeatID();
        System.out.println("*************\n");
        System.out.println("*************\n");
        try{

			  try{
				conn        = DbFunc.getConnection(false);
			    }catch(Exception e){
			    iSuccFlag = -90102;
				if(conn!=null) DbFunc.free(conn,iSuccFlag);
				conn = null;
				strMsg    = "服务取数据库连接异常"+e.getMessage();
				System.out.println("strMsg"+strMsg);
		       }
			    //取得执行数据库操作Statement
				st   = conn.createStatement();

			  strSQL =
	                    "update T_TicketingSeat set StatusID = 0 where SeatID='" +
	                    SeatID + "' and programid=" + ProgramID;

	            System.out.println("strSQLUp["+strSQL+"]\n");
	            flag = ModifyData.ModifyTicketingSeat(strSQL);

				if (flag){

				strSQL  = "delete from t_order_cart where ID="+ID;
			     iSuccFlag = DbFunc.runsql(strSQL);
				}
			     System.out.println("strSQL="+strSQL);
				//插入T_customer表成功
				if (iSuccFlag>0){
				   target = "success";
				   System.out.println("success");

				}else{
					target="failure";
					System.out.println("failure");
					return mapping.findForward(target);

					}
				rs.close();
				rs = null;
			} catch(Exception e){

		    iSuccFlag = 20102005;
			strMsg = e.getMessage();
			strMsg = "失败！";
		}finally{
                       request.setAttribute("username", username);
			try{
				if(rs!=null) rs.close();
			}catch(Exception e1){
			}
			try{
				if(st!=null) st.close();
				if(conn!=null) conn.close();
			}catch(Exception e1){
			}
			}
        return (mapping.findForward(target));
    }

}