?? register_page.jsp
字號:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Money Banks公司 注冊頁面</title>
</head>
<body bgproperties="fixed" bgcolor="#CCCCFF">
<form method="POST" action="Home_page.htm">
<script languaue="JavaScript">
function home()
{
open("Home_page.htm");
}
</script>
<%! int update=0; %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
Statement state;
state = connect.createStatement();
String strQuery1 = "select * from Ac_Requests" ;
ResultSet result1 = state.executeQuery(strQuery1);
int ctr1=0;
while(result1.next())
{
ctr1=ctr1+1;
}
String cRegister="R000"+(ctr1+1);
request.setCharacterEncoding("utf-8");
PreparedStatement stat2= connect.prepareStatement("insert into Ac_Requests values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
stat2.setString(1,cRegister);
stat2.setString(2,request.getParameter("branch"));
stat2.setString(3,request.getParameter("AC_Type"));
stat2.setString(4,request.getParameter("title"));
stat2.setString(5,request.getParameter("txtFrstName"));
stat2.setString(6,request.getParameter("txtMidName"));
stat2.setString(7,request.getParameter("txtLastName"));
String strdate=request.getParameter("year")+"-"+"02"+"-"+request.getParameter("date");
Date date;
date=Date.valueOf(strdate);
stat2.setString(8,date.toString());
stat2.setString(9,request.getParameter("phone_office"));
stat2.setString(10,request.getParameter("address"));
stat2.setString(11,request.getParameter("state"));
stat2.setString(12,request.getParameter("zip"));
stat2.setString(13,request.getParameter("E_mail"));
stat2.setString(14,request.getParameter("ph_res"));
stat2.executeUpdate();
}
catch(Exception e){
out.println("捕獲異常：" +e);
update=2;
}
%>
<p></p>
<table border="0" width="100%" height="42">
<tr>
<td width="50%" height="36"><b><font size="5" ><i>Money Banks 公司</i></font></b></td>
<td width="50%" height="36"></td>
</tr>
</table>
<p>
<font size="3" >數(shù)據(jù)庫已更新如下信息，我們的代表將很快拜訪您，
確認(rèn)信息的合法性，修改信息，請單擊<b>后退鍵</b>
</font>
</p>
<table border="0" width="635" height="245">
<tr>
<td width="96" valign="top" height="239">
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<font ><b>分支機構(gòu):</b></font>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<font><b>賬戶類型:</b></font>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b> 名:</b>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<font ><b>出生日期:</b></font>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<font ><b>工作電話:</b></font>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b>地址:</b>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b>州(省):</b>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b>郵編:</b>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b>電子郵件:</b>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<b>家庭電話:</b>
</p>
</td>
<td width="525" valign="top" height="239">
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("branch") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("AC_Type") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("txtFrstName") %>
<%= request.getParameter("txtMidName") %>
<%= request.getParameter("txtLastName") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("date") %>
<%= request.getParameter("month") %>
<%= request.getParameter("year") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("phone_office") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("address") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("state") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("zip") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("E_mail") %>
</p>
<p style="margin-left: -2; margin-right: -2; margin-top: 5; margin-bottom: 5">
<%= request.getParameter("ph_res") %>
</p>
</td>
</tr>
</table>
<p align="center"><input type="button" value="確定 " name="Ok" onClick="home()">
<font ><a href="Register_page.htm">后退</a></font>
</form>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -