updatehairaction.java

理发店网上发型设计预约系统

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package barbershop.struts.action;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.upload.FormFile;

import barbershop.StrFormat;
import barbershop.database.DBSQLManager;
import barbershop.struts.form.UpdateHairForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-17-2008
 * 
 * XDoclet definition:
 * @struts.action path="/admin/addHair" name="addHairForm" input="/admin/addHair.jsp" scope="request" validate="true"
 */
public class UpdateHairAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		UpdateHairForm updateHairForm = (UpdateHairForm) form;// TODO Auto-generated method stub
		String hairID = StrFormat.StrFormat(updateHairForm.getHairID());
		String hairName = StrFormat.StrFormat(updateHairForm.getHairName());
		String hairSex = StrFormat.StrFormat(updateHairForm.getHairSex());
		String hairPrice = StrFormat.StrFormat(updateHairForm.getHairPrice());
		String hairType = StrFormat.StrFormat(updateHairForm.getHairType());
		String modifyFlag = StrFormat.StrFormat(updateHairForm.getModifyFlag());
		FormFile hairPic = updateHairForm.getHairPic();
		FormFile hairSrc = updateHairForm.getHairSrc();
		DBSQLManager dbsm = new DBSQLManager();
		String sql = "";
		try{
		if(modifyFlag.equals("0"))
		{
			InputStream picStr = hairPic.getInputStream();
			InputStream srcStr = hairSrc.getInputStream();
			Connection conn = dbsm.getConn();
			sql = "INSERT INTO tb_hair VALUES(?,?,?,?,?,?,?,'是')";
			PreparedStatement tmt=conn.prepareStatement(sql);
			tmt.setString(1,hairID);
			tmt.setString(2,hairName);
			tmt.setString(3,hairSex);
			tmt.setString(4,hairPrice);
			tmt.setString(5,hairType);
			tmt.setBinaryStream(6,picStr,picStr.available());
			tmt.setBinaryStream(7,srcStr,srcStr.available());
			tmt.execute();
			return mapping.findForward("insert_success");
		}
		else
		{
			sql = "delete from tb_hair where HAIR_ID='"+hairID+"'";
			dbsm.setSqlStr(sql);
			dbsm.executeUpdate();
			
			InputStream picStr = hairPic.getInputStream();
			InputStream srcStr = hairSrc.getInputStream();
			Connection conn = dbsm.getConn();
			sql = "INSERT INTO tb_hair VALUES(?,?,?,?,?,?,?,'是')";
			PreparedStatement tmt=conn.prepareStatement(sql);
			tmt.setString(1,hairID);
			tmt.setString(2,hairName);
			tmt.setString(3,hairSex);
			tmt.setString(4,hairPrice);
			tmt.setString(5,hairType);
			tmt.setBinaryStream(6,picStr,picStr.available());
			tmt.setBinaryStream(7,srcStr,srcStr.available());
			tmt.execute();
			return mapping.findForward("modify_success");
			
		}
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return mapping.findForward("failure");
		}
		finally
		{
			try
			{
				dbsm.close();
			}
			catch(SQLException se)
			{
				se.printStackTrace();
			}
			
		}
	}
}