📄 responsibility_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 total_rep=request.getParameter("total_rep");
      String percase_rep=request.getParameter("percase_rep");
      String perdeath1=request.getParameter("perdeath1");
      String person1=request.getParameter("person1");
      String perdeath2=request.getParameter("perdeath2");
      String person2=request.getParameter("person2");
      String perservicefee1=request.getParameter("perservicefee1");
      String personfee1=request.getParameter("personfee1");
      String perservicefee2=request.getParameter("perservicefee2");
      String personfee2=request.getParameter("personfee2");
      String perservicelose=request.getParameter("perservicelose");
      String lose_of_rate=request.getParameter("lose_of_rate");
      
      
       try{
          
         
          ResultSet rs=connDB.executeQuery("SELECT * FROM Target_respon"); 
          rs.last();
          String sqll="Insert into Target_respon (target_id,customer_id,person_id,total_rep,percase_rep,perdeath1,person1,perdeath2,person2,perservicefee1,personfee1,perservicefee2,personfee2, perservicelose,lose_of_rate) values('"+target_id+"','"+customer_id+"','"+person_id+"','"+total_rep+"','"+percase_rep+"','"+perdeath1+"','"+person1+"','"+perdeath2+"','"+person2+"','"+perservicefee1+"','"+personfee1+"','"+perservicefee2+"','"+personfee2+"','"+perservicelose+"','"+lose_of_rate+"')";
          connDB.executeUpdate(sqll);
         
         connDB.close();
         
       
        }
        catch(SQLException e){
          e.printStackTrace();
        }
      
      
      
    %>
    
     <tr><font color="88888CC" size="7" align="center">提示：投保成功，谢谢合作！</font></tr>
    
   
  <jsp:include page="copyright.jsp"/>
 </body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -