📄 boat_deal.jsp

📁 这是我老师布置一个学习任务：保险管理系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>

<html>
 <head>
  <title>将投保信息保存到数据库</title>
 </head>
 <body bgcolor="#5555AA" background="pictures/background.jpg">
<jsp:include page="top.jsp"/>
   <% 
      String target_id=request.getParameter("target_id");
      String customer_id=request.getParameter("customer_id");
      String person_id=request.getParameter("person_id");
      String fleetno=request.getParameter("fleetno");
      String shipcname=request.getParameter("shipcname");
      String shipename=request.getParameter("shipename");
      String oldshipname=request.getParameter("oldshipname");
      String shipowner=request.getParameter("shipowner");
      String makeyearmonth=request.getParameter("makeyearmonth");
      String country=request.getParameter("country");
      String stephull=request.getParameter("stephull");
      String makefactory=request.getParameter("makefactory");
      String shiptype=request.getParameter("shiptype");
      String shipusage=request.getParameter("shipusage");
      String shipport=request.getParameter("shipport");
      String sailscope=request.getParameter("sailscope");
      String toncount=request.getParameter("toncount");
      String loadton=request.getParameter("loadton");
      String shiplength=request.getParameter("shiplength");
      String shipwidth=request.getParameter("shipwidth");
      String shipdepth=request.getParameter("shipdepth");
      String seatcount=request.getParameter("seatcount");
      String shipoutlooking=request.getParameter("shipoutlooking");
      String sailcertificate=request.getParameter("sailcertificate");
      String certfication=request.getParameter("certfication");
      String shipvalue=request.getParameter("shipvalue");
      String currency=request.getParameter("currency");
        try{
        ResultSet rs=connDB.executeQuery("SELECT * FROM Target_ship");
         
          rs.last();
          String sqll="Insert into Target_ship (target_id,customer_id,person_id,fleetno,shipcname,shipename,oldshipname,shipowner,makeyearmonth,country,stephull,makefactory, shiptype,shipusage,shipport,sailscope,toncount,loadton,shiplength,shipwidth,shipdepth,seatcount,shipoutlooking,sailcertificate,certfication,shipvalue,currency) values('"+target_id+"','"+customer_id+"','"+person_id+"','"+fleetno+"','"+shipcname+"','"+shipename+"','"+oldshipname+"','"+shipowner+"','"+makeyearmonth+"','"+country+"','"+stephull+"','"+makefactory+"','"+shiptype+"','"+shipusage+"','"+shipport+"','"+sailscope+"','"+toncount+"','"+loadton+"','"+shiplength+"','"+shipwidth+"','"+shipdepth+"','"+seatcount+"','"+shipoutlooking+"','"+sailcertificate+"','"+certfication+"','"+shipvalue+"','"+currency+"')";
          connDB.executeUpdate(sqll);
         
         connDB.close();
         
       
        }
        catch(SQLException e){
          e.printStackTrace();
        }
      
      
      
    %>
    
     <tr><font color="88888CC" size="7" align="center">提示：投保成功，谢谢合作！</font></tr>
    <input name="Submit3" type="button" class="btn_grey" value="返回" onClick="JScript:history.back()">
   
  <jsp:include page="copyright.jsp"/>
 </body>

</html>
⌨️ 快捷键说明

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