other_deal.jsp

来自「这是我老师布置一个学习任务:保险管理系统 」· JSP 代码 · 共 45 行

JSP
45
字号
<%@ 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 insurename=request.getParameter("insurename");
      String description=request.getParameter("description");
      String etcitem1=request.getParameter("etcitem1");
      String etcitem2=request.getParameter("etcitem2");
     
      
      
       try{
          
          ResultSet rs=connDB.executeQuery("SELECT * FROM Target_else"); 
          rs.last();
          String sqll="Insert into Target_else (target_id,customer_id,person_id,insurename,description,etcitem1,etcitem2) values('"+target_id+"','"+customer_id+"','"+person_id+"','"+insurename+"','"+description+"','"+etcitem1+"','"+etcitem2+"')";
          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 + =
减小字号Ctrl + -
显示快捷键?