modicartaction.java

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

package com.sztheater.biz.order;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable up-and-up
 * @version 1.0
 */
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 ModiCartAction 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 ClassID = "";
        String ClassName = "";
        String TicketNum = "";
        String RefPrice = "";
        String ProgramID = "";
        String discount = "";
        String progstartdate = "";
        String contentname = "";
        String progstarttime = "";
        String DisCount = "";
        int TruePrice = 0;
        int ref = 0;
        ResultSet rs = null;
        Statement st = null;
        Connection conn = null;
        HttpSession _httpsession = null;
        _httpsession = request.getSession();

        ClassID = request.getParameter("ClassId");
        ClassName = request.getParameter("classname");
        TicketNum = request.getParameter("TicketNum");
        DisCount = request.getParameter("DisCount");
        RefPrice = request.getParameter("RefPrice");

        ref = Integer.parseInt(RefPrice);
        TruePrice = ref * (100 - Integer.parseInt(DisCount)) / 100; //得到实际价格
        System.out.println("TruePrice=" + TruePrice);

        ProgramID = request.getParameter("programid");
        progstartdate = request.getParameter("progstartdate");
        contentname = request.getParameter("contentname");
        progstarttime = request.getParameter("progstarttime");
        UserName = request.getParameter("UserName");

        System.out.println("**ProgramID=" + ProgramID);
        request.setAttribute("programid", ProgramID);
        request.setAttribute("progstartdate", progstartdate);
        request.setAttribute("contentname", contentname);
        request.setAttribute("progstarttime", progstarttime);

        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 =
                    "delete from tsm_OrderCart where ";
            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 {
            try {
                if (rs != null) {
                    rs.close();
                }
            } catch (Exception e1) {
            }
            try {
                if (st != null) {
                    st.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception e1) {
            }
        }

        System.out.println("TicketNum[" + request.getParameter("TicketNum") +
                           "]\n");
        System.out.println("ClassId[" + request.getParameter("ClassId") + "]\n");

        return (mapping.findForward(target));
    }

}