goodsarriveaction.java

实现动态加载菜单

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

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

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 com.test.struts.form.GoodsArriveForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-27-2006
 * 
 * XDoclet definition:
 * @struts.action path="/in" name="inForm" scope="request"
 */
public class GoodsArriveAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		GoodsArriveForm in = (GoodsArriveForm) form;
		
		String dri="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=menu";
		String username="sa";
		String pass="";
		
		String wtdh = new String(in.getWtdh().getBytes("ISO-8859-1"),"gb2312"); 
		String kh = new String(in.getKh().getBytes("ISO-8859-1"),"gb2312");
		String khzl = new String(in.getKhzl().getBytes("ISO-8859-1"),"gb2312");
		String sljg = new String(in.getSljg().getBytes("ISO-8859-1"),"gb2312");
		
		String thfs = new String(in.getThfs().getBytes("ISO-8859-1"),"gb2312"); 
		String ysfs = new String(in.getYsfs().getBytes("ISO-8859-1"),"gb2312");
		String fhf = new String(in.getFhf().getBytes("ISO-8859-1"),"gb2312");
		String hycs = new String(in.getHycs().getBytes("ISO-8859-1"),"gb2312");
		
		String hylxr = new String(in.getHylxr().getBytes("ISO-8859-1"),"gb2312"); 
		String hydh = new String(in.getHydh().getBytes("ISO-8859-1"),"gb2312");
		String hydz = new String(in.getHydz().getBytes("ISO-8859-1"),"gb2312");
		String shf = new String(in.getShf().getBytes("ISO-8859-1"),"gb2312");
		
		String mdcs = new String(in.getMdcs().getBytes("ISO-8859-1"),"gb2312"); 
		String mdlxr = new String(in.getMdlxr().getBytes("ISO-8859-1"),"gb2312");
		String mddh = new String(in.getMddh().getBytes("ISO-8859-1"),"gb2312");
		String mddz = new String(in.getMddz().getBytes("ISO-8859-1"),"gb2312");
		
		String sxqs = new String(in.getSxqs().getBytes("ISO-8859-1"),"gb2312"); 
		String sxbz = new String(in.getSxbz().getBytes("ISO-8859-1"),"gb2312");
		String sxjj = new String(in.getSxjj().getBytes("ISO-8859-1"),"gb2312");
		String slrq = new String(in.getSlrq().getBytes("ISO-8859-1"),"gb2312");
		
		String zdjz = new String(in.getZdjz().getBytes("ISO-8859-1"),"gb2312"); 
		String bz = new String(in.getBz().getBytes("ISO-8859-1"),"gb2312");
		
		//String wtdh= new String(in.getWtdh().getBytes("gb2312"),"UTF-8");
		//request.setCharacterEncoding("GBK");
		String str="insert into goodsArrive values( '"+wtdh+"','"+kh+"','"+khzl+"','"+sljg +"','"+thfs+"','"+ysfs+"','"+fhf+"','"+hycs+"','"+hylxr+"','"+hydh+"','"+hydz+"','"+shf+"','"+mdcs+"','"+mdlxr+"','"+mddh+"','"+mddz+"','"+sxqs+"','"+sxbz+"','"+sxjj+"','"+slrq +"','"+zdjz+"','"+bz+"')";
		
		Class.forName(dri);
		Connection con=DriverManager.getConnection(url,username,pass);
		Statement st=con.createStatement();
		
		st.executeUpdate(str);
		
		
		// TODO Auto-generated method stub
		response.setCharacterEncoding("GB2312");
		PrintWriter writer = response.getWriter();
		writer.write("<script languge=javascript>");
		writer.write("window.alert('添加成功');window.close()");
		writer.write("</script>");
		return null;
	}
}