<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <% String bz; String TPJG; bz=request.getParameter("bz"); if (bz!=null&&bz.equals("save")) { String DC_GW,WZCP; Connection conn = null; Statement stmt = null; ResultSet rs = null; String url = "jdbc:oracle:thin:@10.72.1.11:1521:ORCL"; String DBDriver="oracle.jdbc.driver.OracleDriver"; String user = "sa"; String password = "sa"; long ID; if (request.getParameter("DC_GW1")==null) { DC_GW=""; } else { DC_GW=request.getParameter("DC_GW1")+","; } if (request.getParameter("DC_GW2")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW2")+","; } if (request.getParameter("DC_GW3")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW3")+","; } if (request.getParameter("DC_GW4")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW4")+","; } if (request.getParameter("DC_GW5")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW5")+","; } if (request.getParameter("DC_GW6")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW6")+","; } if (request.getParameter("DC_GW7")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW7")+","; } if (request.getParameter("DC_GW8")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW8")+","; } if (request.getParameter("DC_GW9")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW9")+","; } if (request.getParameter("DC_GW10")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW10")+","; } if (request.getParameter("DC_GW11")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW11")+","; } if (request.getParameter("DC_GW12")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW12")+","; } if (request.getParameter("DC_GW13")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW13")+","; } if (request.getParameter("select")=="") { DC_GW+=""; } else { DC_GW+=request.getParameter("select")+","; } if (request.getParameter("select2")=="") { DC_GW+=""; } else { DC_GW+=request.getParameter("select2")+","; } if (request.getParameter("select3")=="") { DC_GW+=""; } else { DC_GW+=request.getParameter("select3")+","; } if (request.getParameter("DC_GW22")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW22")+","; } if (request.getParameter("DC_GW23")==null) { DC_GW+=""; } else { DC_GW+=request.getParameter("DC_GW23")+","; } if (request.getParameter("select4")=="") { DC_GW+=""; } else { DC_GW+=request.getParameter("select4")+","; } TPJG=DC_GW; //out.print(TPJG); Class.forName(DBDriver); conn = DriverManager.getConnection(url, user, password); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt.execute("insert into SURVEY (TPJG) values('"+TPJG+"')"); stmt.close(); conn.close(); response.sendRedirect("ok.jsp"); } %>