⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 other_manage.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>picc</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
</head>

<body bgcolor="#FFFFCC" leftmargin=10 topmargin="8" background="pictures/background.jpg">
<table width="100%"  border="0" cellspacing="0" cellpadding="0" background="pictures/bg.gif">
  <tr>
    <td>
<table width="777" height="609"  border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td valign="top">
	<jsp:include page="top.jsp"/>
	<table width="100%"  border="0" cellspacing="0" cellpadding="0" class="tableBorder_LTR">
      <tr>
        <td height="30" align="center" bgcolor="#eeeeee">≡≡≡ <span class="word_grey"><a href="../other.jsp">添加(单击此处即可添加其他险)</a></span> ≡≡≡</td>
       
      </tr>
    </table>
	<table width="100%" height="396"  border="0" cellpadding="0" cellspacing="0" class="tableBorder_LBR">
        <tr>
          <td width="26%" height="395" valign="top"><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
            <tr>
              <td width="55%" height="82" align="center" class="word_grey">&nbsp;<img src="pictures/reg.gif" width="84" height="54"></td>
              <td width="45%" align="left" class="word_grey">其他险管理</td>
            </tr>
            <tr>
              <td height="112" colspan="2" valign="top" class="word_grey"><ul>
               
              
                <li>删除其他险信息:点击添加图标即可删除其他险信息。</li>
               
               </ul></td>
            </tr>
            <tr align="center">
              <td colspan="2" valign="middle" class="word_grey"></td>
            </tr>
          </table></td>
          <td width="5" valign="top" background="pictures/Cen_separate.gif"></td>
          <td width="73%" valign="top"><table width="100%" height="14"  border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td height="13" align="center">&nbsp;</td>
            </tr>
          </table>
            <table width="100%" height="48"  border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF">
              <tr>
                <td width="10%" height="27" align="center">标的号</td>
                <td width="10%" align="center">客户号</td>
                <td width="10%" align="center">联系人号</td>
                <td width="10%" align="center">承保险种名称</td>
                <td width="10%" align="center">承保情况描述</td>
                <td width="10%" align="center">备注说明1</td>
                <td width="10%"  align="center">备注说明2</td>
               
                <td width="10%" align="center">删除</td>
              </tr>
<%
 
  
      try{
       
        
        ResultSet rs=connDB.executeQuery("select * from Target_else");
       


while(rs.next()){
	  String target_id=rs.getString("target_id");
	  String customer_id=rs.getString("customer_id");
	  String person_id=rs.getString("person_id");
	  String insurename=rs.getString("insurename");
	  String description=rs.getString("description");
	  String etcitem1=rs.getString("etcitem1");
	  String etcitem2=rs.getString("etcitem2");
	
	 
	  %>

              <tr style="padding:5px;">
                
               
                <td align="center"><%=target_id%></td>
                <td align="center"><%=customer_id%></td>
                <td align="center"><%=person_id%></td>
                <td align="center"><%=insurename%></td>
                <td align="center"><%=description%></td>
                <td align="center"><%=etcitem1%></td>
                <td align="center"><%=etcitem2%></td>
              
               
                
                <td align="center"><a href="other_del.jsp?target_id=<%=target_id%>"><img src="pictures/del.gif" width="16" height="16"></a></td>
              </tr>
<%  }
  connDB.close();
 }catch(SQLException e)
        {}


%>
            </table>
		</td>
        </tr>
      </table>
      <jsp:include page="copyright.jsp"/>
    </td>
  </tr>
</table>
</td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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