"); //out.println("| 表单项名（FieldName） | "+ file.getFieldName() + " |
"); //out.println("| 文件长度（Size） | " + file.getSize() + " |
"); //out.println("| 文件名（FileName） | " + file.getFileName() + " |
"); //out.println("| 文件扩展名（FileExt） | " + file.getFileExt() + " |
"); //out.println("| 文件全名（FilePathName） | "+ file.getFilePathName() + " |
"); //out.println("| 实际路径 | "+ getServletContext().getRealPath("/") + " |
"); //out.println("| 下载 | " + file.getFileName() + " | |
"); //out.println("
"); //out.println(agvid); } Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url = "jdbc:oracle:thin:@10.20.32.87:1521:XMCSHIS"; String user = "michelle"; String password = "michelle"; Connection conn = DriverManager.getConnection(url, user, password); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); try{ for(int i=1;i<=3;i++){ String checkdate=su.getRequest().getParameter("checkdate"); String csttype=su.getRequest().getParameter("csttype"); String cstid=su.getRequest().getParameter("" + "cstid"+i + ""); String reason=su.getRequest().getParameter("" + "reason"+i + ""); String remark=su.getRequest().getParameter("" + "remark"+i + ""); String status=su.getRequest().getParameter("" + "status"+i + ""); String op=su.getRequest().getParameter("" + "op"+i + ""); String reporter=su.getRequest().getParameter("reporter"); if(cstid.equals("")) {break;} String SQL="insert into michelle.Table1(checkdate ,type ,id,reason ,op ,remark ,attachsourcename ,newfilename ,reporter ,status )" +" values('"+checkdate+"','"+type+"',UPPER('"+id+"'),'"+reason+"','"+op+"','"+remark+"','"+attachsourcename+"','"+newfilename+"','"+reporter+"','"+status+"')"; //out.print(SQL); //out.println(11144); //stmt.executeUpdate(SQL); } out.println("保存记录成功！ | "); } catch(Exception ex){ out.println(" 保存记录失败！Error Info：
"+ex.getMessage()+"
返回上一页 | "); //out.println("sql.executeUpdate:"+ex.getMessage()); } ...展开收缩 