action.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*,java.text.*"%>
<%
	com.util.DealString ds = new com.util.DealString();

	String actionflg = ds.toString(request.getParameter("actionflg")) ;//新增 修改标志
	String id = ds.toString(request.getParameter("id")) ;//记录id 修改用
	String backid = "";
	String sql = "" ;
    Vector vect = new Vector();
//新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增新增
//新增横纵向项目
    if(actionflg!=null && actionflg.equals("add1"))
	{
		com.db.CommonBean myBean = new com.db.CommonBean();
		myBean.init("kjc2_crossproject","id desc","id#NUM#1#djh#CHAR#0#hth#CHAR#0#xmmc#CHAR#0#zy#CHAR#0#nr#CHAR#0#xmlx#NUM#0#xmlx_name#CHAR#0#ktlyd#CHAR#0#xy#CHAR#0#xy_name#CHAR#0#xmfzr#CHAR#0#xmfzr_name#CHAR#0#zywcr#CHAR#0#zywcr_name#CHAR#0#wcrxh#CHAR#0#yjscjr#NUM#0#hzdw#CHAR#0#hzdwlxr#CHAR#0#lxdh#CHAR#0#lxdz#CHAR#0#yb#CHAR#0#dzxx#CHAR#0#hte#CHAR#0#kssj#CHAR#0#jtsj#CHAR#0#xmzt#CHAR#0#bz#CHAR#0#hzbz#CHAR#0#toall");
		
		String []str = new String[28];
		str[0] = ds.toString((String)request.getParameter("txt_djh"));
		str[1] = ds.toString((String)request.getParameter("txt_hth"));
		str[2] = ds.toString((String)request.getParameter("txt_xmmc"));
		str[3] = ds.toString((String)request.getParameter("txt_summary"));
		//str[4] = ds.toString((String)request.getParameter("strfile"));
		str[5] = ds.toString((String)request.getParameter("sel_xmlx"));
		str[6] = ds.toString((String)request.getParameter("txt_from"));
		str[7] = ds.toString((String)request.getParameter("txt_xybh"));
		str[8] = ds.toString((String)request.getParameter("txt_rybh"));
		str[9] = ds.toString((String)request.getParameter("txt_zyrymc"));
		str[10] = ds.toString((String)request.getParameter("txt_zyrybh"));
		str[11] = ds.toString((String)request.getParameter("txt_no"));
		str[12] = ds.toString((String)request.getParameter("txt_hzdw"));
		str[13] = ds.toString((String)request.getParameter("txt_hzdwlxr"));
		str[14] = ds.toString((String)request.getParameter("txt_lxdh"));
		str[15] = ds.toString((String)request.getParameter("txt_lxdz"));
		str[16] = ds.toString((String)request.getParameter("txt_yb"));
		str[17] = ds.toString((String)request.getParameter("txt_email"));
		str[18] = ds.toString((String)request.getParameter("txt_hte"));
		str[19] = ds.toString((String)request.getParameter("begintime"));
		str[20] = ds.toString((String)request.getParameter("endtime"));
		str[21] = ds.toString((String)request.getParameter("sel_xmzt"));
		str[22] = ds.toString((String)request.getParameter("sel_xmbz"));
		str[23] = ds.toString((String)request.getParameter("txt_memo"));
		
		str[24] = ds.toString((String)request.getParameter("txt_xmlxname"));
		str[25] = ds.toString((String)request.getParameter("txt_xymc"));
		str[26] = ds.toString((String)request.getParameter("txt_rymc"));
		if(!str[26].equals(""))
		{
			str[26] = (str[26].split(" "))[0];
		}
		str[27] = ds.toString((String)request.getParameter("txt_zyryno"));
		String wcrname = str[27];
		str[27]="";
		if(!wcrname.equals(""))
		{
			for(int j=0;j<(wcrname.split(",")).length;j++)
			{
				if(!str[27].equals(""))
			        str[27] = str[27] + "," + (((wcrname.split(","))[j]).split(" "))[0];
				else
					str[27] = (((wcrname.split(","))[j]).split(" "))[0];
			}
		}
		//查询登记号的唯一性
		myBean.setTabName("kjc2_crossproject");
		myBean.setOrderBy("djh");
		vect = myBean.getAllData(" djh='"+str[0]+"'");
		if(vect.size()!=0)
			response.sendRedirect("err.jsp?errcode=1");
        else
		{
			Hashtable hash = new Hashtable();
			hash.put ( "djh" , str[0] );
			hash.put ( "hth" , str[1] );
			hash.put ( "xmmc" , str[2] );
			hash.put ( "zy" , str[3] );
			hash.put ( "xmlx" , str[5] );
			hash.put ( "ktlyd" , str[6] );
			hash.put ( "xy" , str[7] );
			hash.put ( "xmfzr" , str[8] );
			hash.put ( "zywcr" , str[9] );
			hash.put ( "wcrxh" , str[10] );
			hash.put ( "yjscjr" , str[11] );
			hash.put ( "hzdw" , str[12] );
			hash.put ( "hzdwlxr" , str[13] );
			hash.put ( "lxdh" , str[14] );
			hash.put ( "lxdz" , str[15] );
			hash.put ( "yb" , str[16] );
			hash.put ( "dzxx" , str[17] );
			hash.put ( "hte" , str[18] );
			hash.put ( "kssj" , str[19] );
			hash.put ( "jtsj" , str[20] );
			hash.put ( "xmzt" , str[21] );
			hash.put ( "hzbz" , str[22] );
			hash.put ( "bz" , str[23] );

			hash.put ( "xmlx_name" , str[24] );
			hash.put ( "xy_name" , str[25] );
			hash.put ( "xmfzr_name" , str[26] );
			hash.put ( "zywcr_name" , str[27] );
			backid = "" + myBean.add ( hash ) ;

			//附件表
			String strfile = ds.toString(request.getParameter("strfile"));
			String strname = ds.toString(request.getParameter("strname"));
			//strfile = new String( strfile.getBytes("GBK"),"ISO-8859-1");
			//strname = new String( strname.getBytes("GBK"),"ISO-8859-1");
			String strsize = ds.toString(request.getParameter("strsize"));
			String upmonth = ds.toString(request.getParameter("upmonth"));
			String cursize = "0" ;
			String froms = ds.toString((String)session.getAttribute("ID"));
			//填写附件表
			String t_strfile[] = ds.splitStr ( strfile , ',' ) ;
			String t_strname[] = ds.splitStr ( strname , ',' ) ;
			String t_strsize[] = ds.splitStr ( strsize , ',' ) ;
			for(int i = 0 ; i < t_strfile.length; i++ )
			{	
				if(t_strfile[i].equals(""))continue;
				sql="insert into kjc2_crossprojectfile(objectid,oldname,newname,size,updatetime,upman,isattach) "
					+"values("+backid+",'"+t_strfile[i]+"','"+t_strname[i]+"','"+t_strsize[i]+"','"+ds.getDateTime().substring(0,10)+"',"+froms+",1)";
				myBean.executeUpdate(sql);
			}
			out.println("<script>alert('成功提交!');</script>");
			myBean.closeConn ( ) ;
			response.sendRedirect("success.jsp");
			//response.sendRedirect("add1.jsp?id="+backid+"&actionflg=mod1");
		}
	}
//新增奖励项目
	if(actionflg!=null && actionflg.equals("add2"))
	{
		com.db.CommonBean myBean = new com.db.CommonBean();
    	myBean.init("kjc2_prizeproject","id desc","id#NUM#1#bh#CHAR#0#xy#CHAR#0#xy_name#CHAR#0#jljb#NUM#0#jljb_name#CHAR#0#jllx#CHAR#0#sjbm#CHAR#0#jlmc#NUM#0#jlmc_name#CHAR#0#jz#NUM#0#jz_name#CHAR#0#jldj#NUM#0#jldj_name#CHAR#0#xmmc#CHAR#0#zy#CHAR#0#nr#CHAR#0#wcr#CHAR#0#wcrxh#CHAR#0#wcdw#CHAR#0#sfwcr#CHAR#0#sfwcdw#CHAR#0#bz#CHAR#0#toall");
		
		String []str = new String[21];
		str[0] = ds.toString((String)request.getParameter("txt_xmbh"));
		str[1] = ds.toString((String)request.getParameter("txt_xmmc"));
		str[2] = ds.toString((String)request.getParameter("txt_xybh"));
		str[3] = ds.toString((String)request.getParameter("sel_jllx"));
		str[4] = ds.toString((String)request.getParameter("sel_jljb"));
		str[5] = ds.toString((String)request.getParameter("sel_jlmc"));
		str[6] = ds.toString((String)request.getParameter("sel_jz"));
		str[7] = ds.toString((String)request.getParameter("sel_jldj"));
		str[8] = ds.toString((String)request.getParameter("txt_sjbm"));
		str[9] = ds.toString((String)request.getParameter("txt_summary"));
		str[10] = ds.toString((String)request.getParameter("txt_zyrymc"));
		str[11] = ds.toString((String)request.getParameter("txt_zyrybh"));
		str[12] = ds.toString((String)request.getParameter("txt_wcdw"));
		str[13] = ds.toString((String)request.getParameter("txt_memo"));
		str[14] = ds.toString((String)request.getParameter("sel_sfdywcr"));
		str[15] = ds.toString((String)request.getParameter("sel_sfdywcdw"));

		str[16] = ds.toString((String)request.getParameter("txt_xymc"));
		str[17] = ds.toString((String)request.getParameter("txt_jljbname"));
		str[18] = ds.toString((String)request.getParameter("txt_jlmcname"));
		str[19] = ds.toString((String)request.getParameter("txt_jzname"));
		str[20] = ds.toString((String)request.getParameter("txt_jldjname"));

		//查询项目编号的唯一性
		myBean.setTabName("kjc2_prizeproject");
		myBean.setOrderBy("bh");
		vect = myBean.getAllData(" bh='"+str[0]+"'");
		if(vect.size()!=0)
			response.sendRedirect("err.jsp?errcode=2");
        else
		{
			Hashtable hash = new Hashtable();
			hash.put ( "bh" , str[0] );
			hash.put ( "xmmc" , str[1] );
			hash.put ( "xy" , str[2] );
			hash.put ( "jllx" , str[3] );
			hash.put ( "jljb" , str[4] );
			hash.put ( "jlmc" , str[5] );
			hash.put ( "jz" , str[6] );
			hash.put ( "jldj" , str[7] );
			hash.put ( "sjbm" , str[8] );
			hash.put ( "zy" , str[9] );
			hash.put ( "wcr" , str[10] );
			hash.put ( "wcrxh" , str[11] );
			hash.put ( "wcdw" , str[12] );
			hash.put ( "bz" , str[13] );
			hash.put ( "sfwcr" , str[14] );
			hash.put ( "sfwcdw" , str[15] );

			hash.put ( "xy_name" , str[16] );
			hash.put ( "jljb_name" , str[17] );
			hash.put ( "jlmc_name" , str[18] );
			hash.put ( "jz_name" , str[19] );
			hash.put ( "jldj_name" , str[20] );
			backid = "" + myBean.add ( hash ) ;

			//附件表
			String strfile = ds.toString(request.getParameter("strfile"));
			String strname = ds.toString(request.getParameter("strname"));
			//strfile = new String( strfile.getBytes("GBK"),"ISO-8859-1");
			//strname = new String( strname.getBytes("GBK"),"ISO-8859-1");
			String strsize = ds.toString(request.getParameter("strsize"));
			String upmonth = ds.toString(request.getParameter("upmonth"));
			String cursize = "0" ;
			String froms = ds.toString((String)session.getAttribute("ID"));
			//填写附件表
			String t_strfile[] = ds.splitStr ( strfile , ',' ) ;
			String t_strname[] = ds.splitStr ( strname , ',' ) ;
			String t_strsize[] = ds.splitStr ( strsize , ',' ) ;
			for(int i = 0 ; i < t_strfile.length; i++ )
			{	
				if(t_strfile[i].equals(""))continue;
				sql="insert into kjc2_prizeprojectfile(objectid,oldname,newname,size,updatetime,upman,isattach) "
					+"values("+backid+",'"+t_strfile[i]+"','"+t_strname[i]+"','"+t_strsize[i]+"','"+ds.getDateTime().substring(0,10)+"',"+froms+",1)";
				myBean.executeUpdate(sql);
			}
			out.println("<script>alert('成功提交!');</script>");
			myBean.closeConn ( ) ;
			response.sendRedirect("success.jsp");
			//response.sendRedirect("add2.jsp?id="+backid+"&actionflg=mod2");
		}
	}
	if(actionflg!=null && actionflg.equals("add3"))//新增鉴定项目
	{
		com.db.CommonBean myBean = new com.db.CommonBean();
		myBean.init("kjc2_checkupproject","id desc","id#NUM#1#bh#CHAR#0#jdzsh#CHAR#0#xy#CHAR#0#xy_name#CHAR#0#xmmc#CHAR#0#zy#CHAR#0#nr#CHAR#0#xmly#CHAR#0#wcr#CHAR#0#wcr_name#CHAR#0#wcrxh#CHAR#0#wcdw#CHAR#0#jdbm#CHAR#0#jdsj#CHAR#0#jdjl#CHAR#0#bz#CHAR#0#toall");
		
		String []str = new String[16];
		str[0] = ds.toString((String)request.getParameter("txt_xmbh"));
		str[1] = ds.toString((String)request.getParameter("txt_jszsh"));
		str[2] = ds.toString((String)request.getParameter("txt_xmmc"));
		str[3] = ds.toString((String)request.getParameter("txt_xybh"));
		str[4] = ds.toString((String)request.getParameter("txt_summary"));
		//str[5] = ds.toString((String)request.getParameter("strfile"));
		str[6] = ds.toString((String)request.getParameter("txt_xmly"));
		str[7] = ds.toString((String)request.getParameter("txt_zyrymc"));
		str[8] = ds.toString((String)request.getParameter("txt_zyrybh"));
		str[9] = ds.toString((String)request.getParameter("txt_wcdw"));
		str[10] = ds.toString((String)request.getParameter("txt_jdbm"));
		str[11] = ds.toString((String)request.getParameter("jdtime"));
		str[12] = ds.toString((String)request.getParameter("txt_jdjl"));
		str[13] = ds.toString((String)request.getParameter("txt_memo"));
        
		str[14] = ds.toString((String)request.getParameter("txt_xymc"));
		str[15] = ds.toString((String)request.getParameter("txt_zyryno"));
		String strwcrname = str[15];
		str[15]="";
		if(!strwcrname.equals(""))
		{
			for(int j=0;j<(strwcrname.split(",")).length;j++)
			{
				if(!str[15].equals(""))
			        str[15] = str[15] + "," + (((strwcrname.split(","))[j]).split(" "))[0];
				else
					str[15] = (((strwcrname.split(","))[j]).split(" "))[0];
			}
		}
		//查询项目编号的唯一性
		myBean.setTabName("kjc2_checkupproject");
		myBean.setOrderBy("bh");
		vect = myBean.getAllData(" bh='"+str[0]+"'");
		if(vect.size()!=0)
			response.sendRedirect("err.jsp?errcode=3");
        else
		{
			Hashtable hash = new Hashtable();
			hash.put ( "bh" , str[0] );
			hash.put ( "jdzsh" , str[1] );
			hash.put ( "xmmc" , str[2] );
			hash.put ( "xy" , str[3] );
			hash.put ( "zy" , str[4] );
			hash.put ( "xmly" , str[6] );
			hash.put ( "wcr" , str[7] );
			hash.put ( "wcrxh" , str[8] );
			hash.put ( "wcdw" , str[9] );
			hash.put ( "jdbm" , str[10] );
			hash.put ( "jdsj" , str[11] );
			hash.put ( "jdjl" , str[12] );
			hash.put ( "bz" , str[13] );
		
			hash.put ( "xy_name" , str[14] );
			hash.put ( "wcr_name" , str[15] );

			backid = "" + myBean.add ( hash ) ;

			//附件表
			String strfile = ds.toString(request.getParameter("strfile"));
			String strname = ds.toString(request.getParameter("strname"));
			//strfile = new String( strfile.getBytes("GBK"),"ISO-8859-1");
			//strname = new String( strname.getBytes("GBK"),"ISO-8859-1");
			String strsize = ds.toString(request.getParameter("strsize"));
			String upmonth = ds.toString(request.getParameter("upmonth"));
			String cursize = "0" ;
			String froms = ds.toString((String)session.getAttribute("ID"));
			//填写附件表
			String t_strfile[] = ds.splitStr ( strfile , ',' ) ;
			String t_strname[] = ds.splitStr ( strname , ',' ) ;