backylhq_qtylcontent1action.java

这个程序是花了好几十万请人开发的

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (Bad file descriptor))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.ResultSet;

import javabean.dbconnect;

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 struts.form.Backylhq_qtylcontent1Form;

/** 
 * Backylhq_qtylcontent1Action.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 10-24-2004
 * 
 * XDoclet definition:
 * @struts:action path="/backylhq_qtylcontent1" name="backylhq_qtylcontent1Form" input="/form/backylhq_qtylcontent1.jsp" validate="true"
 */
public class Backylhq_qtylcontent1Action extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		Backylhq_qtylcontent1Form backylhq_qtylcontent1Form =
			(Backylhq_qtylcontent1Form) form;
			
			ResultSet rs;
			dbconnect db=new dbconnect();
			String sql="";
			String names="";
				names=backylhq_qtylcontent1Form.getNames().trim();
				names=new String(names.getBytes("ISO-8859-1"));
			String types="";
				types=backylhq_qtylcontent1Form.getTypes().trim();
				types=new String(types.getBytes("ISO-8859-1"));
			String market="";
				market=backylhq_qtylcontent1Form.getMarket().trim();
				market=new String(market.getBytes("ISO-8859-1"));
			String areas="";
				areas=backylhq_qtylcontent1Form.getAreas().trim();
				areas=new String(areas.getBytes("ISO-8859-1"));
			String danw="";
				danw=backylhq_qtylcontent1Form.getDanw().trim();
				danw=new String(danw.getBytes("ISO-8859-1"));
			String radio=backylhq_qtylcontent1Form.getradio().trim();
				radio=new String(radio.getBytes("ISO-8859-1"));
		
			if(radio.equalsIgnoreCase("添加"))
			{
				if(names.length()!=0)
				{
					sql="insert into ylhq1_qttitlenames values('"+names+"')";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(types.length()!=0)
				{
					sql="insert into ylhq1_qttitletypes values('"+types+"')";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(market.length()!=0)
				{
					sql="insert into ylhq1titlemarket values('"+market+"')";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(areas.length()!=0)
				{
					sql="insert into ylhq1titleareas values('"+areas+"')";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(danw.length()!=0)
				{
					sql="insert into ylhq1titledanw values('"+danw+"')";
					rs=db.executeQuery(sql);
					rs.close();
				}
				return mapping.findForward("BackSuccess");
			}
			else if(radio.equalsIgnoreCase("删除"))
			{
				if(names.length()!=0)
				{
					sql="delete from ylhq1_qttitlenames where names='"+names+"'";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(types.length()!=0)
				{
					sql="delete from ylhq1_qttitletypes where types='"+types+"'";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(market.length()!=0)
				{
					sql="delete from ylhq1titlemarket where market='"+market+"'";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(areas.length()!=0)
				{
					sql="delete from ylhq1titleareas where areas='"+areas+"'";
					rs=db.executeQuery(sql);
					rs.close();
				}
				else if(danw.length()!=0)
				{
					sql="delete from ylhq1titledanw where danw='"+danw+"'";
					rs=db.executeQuery(sql);
					rs.close();
				}
			}
			request.setAttribute("radio",radio);
			return mapping.findForward("BackSuccess");			
		//throw new UnsupportedOperationException("Generated method 'execute(...)' not implemented.");
	}

}