📄 action.jsp
字号:
//查询登记号的唯一性
myBean.setTabName("kjc2_prizeproject");
myBean.setOrderBy("bh");
vect = myBean.getAllData(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
//如果是修改则先清空附件
myBean.getDataBySql("delete from kjc2_prizeprojectfile 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_prizeprojectfile(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("add2.jsp?id="+id+"&actionflg=mod2");
}
}
if(actionflg!=null && actionflg.equals("mod3"))//修改鉴定项目
{
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(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
//如果是修改则先清空附件
myBean.getDataBySql("delete from kjc2_checkupprojectfile 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_checkupprojectfile(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("add3.jsp?id="+id+"&actionflg=mod3");
}
}
if(actionflg!=null && actionflg.equals("mod4"))//修改论文
{
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(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add4.jsp?id="+id+"&actionflg=mod4");
}
}
if(actionflg!=null && actionflg.equals("mod5"))//修改科技专著统计
{
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(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add5.jsp?id="+id+"&actionflg=mod5");
}
}
if(actionflg!=null && actionflg.equals("mod6"))//修改学术报告会
{
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(" id<>"+id+" and 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] );
myBean.setID(id);
myBean.mod( hash ) ;
out.println("<script>alert('成功提交!');</script>");
myBean.closeConn ( ) ;
response.sendRedirect("success.jsp");
//response.sendRedirect("add6.jsp?id="+id+"&actionflg=mod6");
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -