📄 action.jsp
字号:
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_checkupprojectfile(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("add3.jsp?id="+backid+"&actionflg=mod3");
}
}
if(actionflg!=null && actionflg.equals("add4"))//新增论文
{
com.db.CommonBean myBean = new com.db.CommonBean();
myBean.init("kjc2_paper","id desc","id#NUM#1#bh#CHAR#0#xy#CHAR#0#zz#CHAR#0#kwmc#CHAR#0#lwmc#CHAR#0#slqk#NUM#0#slqk_name#CHAR#0#yxl#CHAR#0#yxyz#CHAR#0#yycs#NUM#0#djzz#NUM#0#bz#CHAR#0#toall");
String []str = new String[12];
str[0] = ds.toString((String)request.getParameter("txt_lwbh"));
str[1] = ds.toString((String)request.getParameter("txt_xymc"));
str[2] = ds.toString((String)request.getParameter("txt_zz"));
str[3] = ds.toString((String)request.getParameter("txt_kwmc"));
str[4] = ds.toString((String)request.getParameter("txt_lwmc"));
str[5] = ds.toString((String)request.getParameter("sel_slqk"));
str[6] = ds.toString((String)request.getParameter("sel_yxl"));
str[7] = ds.toString((String)request.getParameter("txt_yxyz"));
str[8] = ds.toString((String)request.getParameter("txt_yycs"));
str[9] = ds.toString((String)request.getParameter("txt_djzz"));
str[10] = ds.toString((String)request.getParameter("txt_memo"));
str[11] = ds.toString((String)request.getParameter("txt_slqkname"));
//查询论文编号的唯一性
myBean.setTabName("kjc2_paper");
myBean.setOrderBy("bh");
vect = myBean.getAllData(" bh='"+str[0]+"'");
if(vect.size()!=0)
response.sendRedirect("err.jsp?errcode=4");
else
{
Hashtable hash = new Hashtable();
hash.put ( "bh" , str[0] );
hash.put ( "xy" , str[1] );
hash.put ( "zz" , str[2] );
hash.put ( "kwmc" , str[3] );
hash.put ( "lwmc" , str[4] );
hash.put ( "slqk" , str[5] );
hash.put ( "yxl" , str[6] );
hash.put ( "yxyz" , str[7] );
hash.put ( "yycs" , str[8] );
hash.put ( "djzz" , str[9] );
hash.put ( "bz" , str[10] );
hash.put ( "slqk_name" , str[11] );
backid = "" + myBean.add ( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add4.jsp?id="+backid+"&actionflg=mod4");
}
}
if(actionflg!=null && actionflg.equals("add5"))//新增科技专著统计
{
com.db.CommonBean myBean = new com.db.CommonBean();
myBean.init("kjc2_bookstatistic","id desc","id#NUM#1#bh#CHAR#0#xy#CHAR#0#zz#CHAR#0#cbs#CHAR#0#zs#CHAR#0#bz#CHAR#0#toall");
String []str = new String[6];
str[0] = ds.toString((String)request.getParameter("txt_zzbh"));
str[1] = ds.toString((String)request.getParameter("txt_xymc"));
str[2] = ds.toString((String)request.getParameter("txt_zz"));
str[3] = ds.toString((String)request.getParameter("txt_cbs"));
str[4] = ds.toString((String)request.getParameter("txt_zs"));
str[5] = ds.toString((String)request.getParameter("txt_memo"));
//查询专著编号的唯一性
myBean.setTabName("kjc2_bookstatistic");
myBean.setOrderBy("bh");
vect = myBean.getAllData(" bh='"+str[0]+"'");
if(vect.size()!=0)
response.sendRedirect("err.jsp?errcode=5");
else
{
Hashtable hash = new Hashtable();
hash.put ( "bh" , str[0] );
hash.put ( "xy" , str[1] );
hash.put ( "zz" , str[2] );
hash.put ( "cbs" , str[3] );
hash.put ( "zs" , str[4] );
hash.put ( "bz" , str[5] );
backid = "" + myBean.add ( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add5.jsp?id="+backid+"&actionflg=mod5");
}
}
if(actionflg!=null && actionflg.equals("add6"))//新增学术报告会
{
com.db.CommonBean myBean = new com.db.CommonBean();
myBean.init("kjc2_report","id desc","id#NUM#1#bh#CHAR#0#xy#CHAR#0#bgr#CHAR#0#zw#CHAR#0#bgrdw#CHAR#0#bgmc#CHAR#0#tzdx#CHAR#0#rs#CHAR#0#bz#CHAR#0#toall");
String []str = new String[9];
str[0] = ds.toString((String)request.getParameter("txt_bghbh"));
str[1] = ds.toString((String)request.getParameter("txt_xymc"));
str[2] = ds.toString((String)request.getParameter("txt_bgr"));
str[3] = ds.toString((String)request.getParameter("txt_zw"));
str[4] = ds.toString((String)request.getParameter("txt_bgrdw"));
str[5] = ds.toString((String)request.getParameter("txt_bgmc"));
str[6] = ds.toString((String)request.getParameter("txt_tzdx"));
str[7] = ds.toString((String)request.getParameter("txt_rs"));
str[8] = ds.toString((String)request.getParameter("txt_memo"));
//查询报告会编号的唯一性
myBean.setTabName("kjc2_report");
myBean.setOrderBy("bh");
vect = myBean.getAllData(" bh='"+str[0]+"'");
if(vect.size()!=0)
response.sendRedirect("err.jsp?errcode=6");
else
{
Hashtable hash = new Hashtable();
hash.put ( "bh" , str[0] );
hash.put ( "xy" , str[1] );
hash.put ( "bgr" , str[2] );
hash.put ( "zw" , str[3] );
hash.put ( "bgrdw" , str[4] );
hash.put ( "bgmc" , str[5] );
hash.put ( "tzdx" , str[6] );
hash.put ( "rs" , str[7] );
hash.put ( "bz" , str[8] );
backid = "" + myBean.add ( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add6.jsp?id="+backid+"&actionflg=mod6");
}
}
//修改修改修改修改修改修改修改修改修改修改修改修改修改修改修改修改修改修改
if(actionflg!=null && actionflg.equals("mod1"))//修改横纵向项目
{
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(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
//如果是修改则先清空附件
myBean.getDataBySql("delete from kjc2_crossprojectfile where objectid="+id);
//附件表
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("+id+",'"+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="+id+"&actionflg=mod1");
}
}
if(actionflg!=null && actionflg.equals("mod2"))//修改奖励项目
{
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"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -