//关键字处理 String key_word=conv(request.getParameter("key_word"))+";"+tmp_key; if (!cppp.trim().equals("")) key_word=key_word+";"+conv(cppp); if (!cpxh.trim().equals("")) key_word=key_word+";"+conv(cpxh); if (xxms.length()>=100) key_word=key_word+";"+conv(xxms.substring(0,100)); else key_word=key_word+";"+conv(xxms);
if (request.getParameter("sfgq")==null) sfgq=""; else sfgq=request.getParameter("sfgq"); if (request.getParameter("gqlx")==null) gqlx=""; else gqlx=request.getParameter("gqlx"); if (request.getParameter("sf")==null) gqsf=""; else gqsf=request.getParameter("sf");
if (request.getParameter("yxq")==null) yxq=""; else yxq=request.getParameter("yxq");
if (request.getParameter("cpsl")==null) cpsl=""; else cpsl=request.getParameter("cpsl");
String aid=request.getParameter("aid");
String bid=request.getParameter("bid");
String ycd=request.getParameter("ycd");
String cpgg=request.getParameter("cpgg");
String cpjg=request.getParameter("cpjg");
String xxms=request.getParameter("xxms");
String cptp=request.getParameter("imgcptp");
String cpxh=request.getParameter("cpxh");
String cppp=request.getParameter("cppp");
String zxdhl=request.getParameter("zxdhl");
String ghnl=request.getParameter("ghnl");
String tpbl=request.getParameter("tpbl");
//关键字处理
String key_word=conv(request.getParameter("key_word"))+";"+tmp_key;
if (!cppp.trim().equals(""))
key_word=key_word+";"+conv(cppp);
if (!cpxh.trim().equals(""))
key_word=key_word+";"+conv(cpxh);
if (xxms.length()>=100) key_word=key_word+";"+conv(xxms.substring(0,100));
else
key_word=key_word+";"+conv(xxms);
if (request.getParameter("sfgq")==null)
sfgq="";
else sfgq=request.getParameter("sfgq");
if (request.getParameter("gqlx")==null)
gqlx="";
else gqlx=request.getParameter("gqlx");
if (request.getParameter("sf")==null)
gqsf="";
else gqsf=request.getParameter("sf");
if (request.getParameter("yxq")==null)
yxq="";
else yxq=request.getParameter("yxq");
if (request.getParameter("cpsl")==null)
cpsl="";
else cpsl=request.getParameter("cpsl");
try{
sql="INSERT INTO dt_cpk(gsid,aid,bid,sf,cpmc,cpgg,cpdj,cplx,cpms,cpxh,cppp,zxdhl,ghnl,cptp,key_word,tpbl,shzt,fwcs,sftj,sfjp,djsj) VALUES('"
+id+"','"
+aid+"','"
+bid+"',"
+convert(ycd)+","
+convert(cpmc)+","
+convert(cpgg)+","
+convert(cpjg)+","
+"0,"
+convert(transform(xxms))+","
+convert(cpxh)+","
+convert(cppp)+","
+convert(zxdhl)+","
+convert(ghnl)+","
+convert(cptp)+","
+"'"+key_word+"',"
+tpbl+",'0','0','0','0',getdate())";
//out.print(key_word);
//out.println(sql);
dbBean.execute(sql);
//out.println("发布成功!");
}catch(Exception e){
response.sendRedirect("../error.jsp?ErrorID=2");
}