?? custominfo.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="#6666CC" background="pictures/background.jpg">
<jsp:include page="top.jsp"/>
<center>
<p>
<%
String strname=request.getParameter("name");
String strpassword=request.getParameter("password");
try{
ResultSet rs=connDB.executeQuery("select * from Customer where custom_name like"+" "+"'"+strname+"'"+"and custom_password like"+" "+"'"+strpassword+"'");
if(!rs.next())
{
response.sendRedirect("error.jsp");
connDB.close();
}
else{
%> <form action="deal.jsp" method="get">
<table cellspacing="3" cellpadding="3" align="center" >
<tr>
<font color="#FF8700" size="3">
<tr > <td>客戶號:</td><td><%= rs.getString(1) %></td></tr>
<tr ><td> 客戶密碼:</td><td><%= rs.getString(2) %></td></tr>
<tr><td> 客戶性質:</td><td><%= rs.getString(3) %></td></tr>
<tr> <td>客戶名稱:</td><td><%= rs.getString(4) %></td></tr>
<tr><td>客戶地址:</td><td><%= rs.getString(5) %></td></tr>
<tr><td>法人組織機構代碼:</td><td><%= rs.getString(6) %></td></tr>
<tr><td>法人代表:</td><td><%= rs.getString(7) %></td></tr>
<tr><td> 電話號碼:</td><td><%= rs.getString(8) %></td></tr>
<tr> <td>移動電話:</td><td><%= rs.getString(9) %></td></tr>
<tr> <td>傳真號碼:</td><td><%= rs.getString(10) %></td></tr>
<tr><td>法人:</td><td><%= rs.getString(11) %></td></tr>
<tr><td>登記日期:</td><td><%= rs.getString(12) %></td></tr>
<tr> <td>登記人:</td><td><%= rs.getString(13) %></td></tr>
<tr> <td>相關公司:</td><td><%= rs.getString(14) %></td></tr>
</tr>
<tr>
<td align="center">
<input type="submit" value="我要投保">
</td>
</tr>
<%
}
%>
</table>
</form>
<%
connDB.close();
}
catch(SQLException e){}
%>
</p>
<jsp:include page="copyright.jsp"/>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -