📄 uploadsubmit.jsp

📁 这是我老师布置一个学习任务：保险管理系统
💻 JSP
字号:
<%@page contentType="text/html;charset=gb2312 " pageEncoding="gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="fileBean" scope="page" class="net.jspcn.tool.UploadBean" />
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<body bgcolor="#5555AA" background="pictures/background.jpg">
<jsp:include page="top.jsp"/>
</body>
<%
  

         
fileBean.setObjectPath("D:\\Temp\\");

fileBean.setSize(10000*1024);

fileBean.setSuffix(".gif.jpg.png.jpge.html.htm.rar.zip");

fileBean.setSourceFile(request);

String [] saSourceFile = fileBean.getSourceFile();

String [] saObjectFile = fileBean.getObjectFileName();

String [] saDescription = fileBean.getDescription();

int iCount = fileBean.getCount();

String sObjectPath = fileBean.getObjectPath();

for(int i=0;i<iCount;i++) {

out.println("<br>目标上传文件:");

out.println(saSourceFile[i]);

out.println("<br>上传目录:");

out.println(sObjectPath+saObjectFile[i]);

out.println("<br>上传状态:");

out.println(saDescription[i]);

out.println("<br>");
 

}

      String target_id=(session.getAttribute("target_id")).toString();
      String customer_id=(session.getAttribute("customer_id")).toString();
      String person_id=(session.getAttribute("person_id")).toString();
      String car_no=(session.getAttribute("car_no")).toString();
      String factory_no=(session.getAttribute("factory_no")).toString();
      String type=(session.getAttribute("type")).toString();
      String colour=(session.getAttribute("colour")).toString();
      String motor_no=(session.getAttribute("motor_no")).toString();
      String vin_no=(session.getAttribute("vin_no")).toString();
      String frame_no=(session.getAttribute("frame_no")).toString();
      String register_date=(session.getAttribute("register_date")).toString();
      String use_type=(session.getAttribute("use_type")).toString();
      String cap_passanger=(session.getAttribute("cap_passanger")).toString();
      String capability=(session.getAttribute("capability")).toString();
 try{  
  ResultSet rs=connDB.executeQuery("SELECT * FROM Target_car");
         
          rs.last();
  String sqll="Insert into Target_car (target_id,customer_id,person_id,car_no,factory_no,type,colour,motor_no,vin_no,frame_no,register_date,use_type,cap_passanger,capability,pass_side_1,pass_side_2,outer_look,driver_side_1,driver_side_2) values('"+target_id+"','"+customer_id+"','"+person_id+"','"+car_no+"','"+factory_no+"','"+type+"','"+colour+"','"+motor_no+"','"+vin_no+"','"+frame_no+"','"+register_date+"','"+use_type+"','"+cap_passanger+"','"+capability+"','"+saObjectFile[0]+"','"+saObjectFile[1]+"','"+saObjectFile[2]+"','"+saObjectFile[3]+"','"+saObjectFile[4]+"')";
  connDB.executeUpdate(sqll);
  connDB.close();
         
       
        }
        catch(Exception e){
          e.printStackTrace();
        }


%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -