📄 wealth_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 fixedassets=request.getParameter("fixedassets");
      String workshophouse=request.getParameter("workshophouse");
      String building=request.getParameter("building");
      String currencyassets=request.getParameter("currencyassets");
      String raw_material=request.getParameter("raw_material");
      String stock_commodity=request.getParameter("stock_commodity");
      String machine=request.getParameter("machine");
      String computer=request.getParameter("computer");
      String processing=request.getParameter("processing");
      String replace_storage=request.getParameter("replace_storage");
      String specialitem=request.getParameter("specialitem");
      
      
       try{
         
          ResultSet rs=connDB.executeQuery("SELECT * FROM Target_prop"); 
          rs.last();
          String sqll="Insert into Target_prop (target_id,customer_id,person_id,fixedassets,workshophouse,building,currencyassets,raw_material,stock_commodity,machine,computer,processing, replace_storage,specialitem) values('"+target_id+"','"+customer_id+"','"+person_id+"','"+fixedassets+"','"+workshophouse+"','"+building+"','"+currencyassets+"','"+raw_material+"','"+stock_commodity+"','"+machine+"','"+computer+"','"+processing+"','"+replace_storage+"','"+specialitem+"')";
          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 + -