📄 other_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 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -