modicartaction.java~2~

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

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  = "insert into tsm_OrderCart(UserName,ContentName,ProgramID,ClassID,ClassName,\n"
                                        +"TicketNum,RefPrice,TruePrice) \n"
                                        + "values('"+UserName+"','"+contentname+"','"+ProgramID+"','"+ClassID+"','"+ClassName+"',\n"
                                        + " '"+TicketNum+"',"+ref+","+TruePrice+")";
                             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));
    }

}