📄 registered_user.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">
<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>
<%! int ctr=0; %>
<%! int flag=0;
int flag1=0;
int flag2=0;
%>
<%@ page import="java.sql.*" %>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect, connect1;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
connect1=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
Statement state1,state2,state3;
String str1, str2, str3, str4;
state1 = connect.createStatement();
str2=(String)request.getParameter("Act_No");
String strQuery1 = "select * from Login_Info" ;
ResultSet result1 = state1.executeQuery(strQuery1);
while(result1.next())
{
str1=(String)result1.getString("Account_No");
str1=str1.trim();
str2=str2.trim();
if(str2.equals(str1))
{
flag=1;
break;
}
}
state2 = connect1.createStatement();
str4=request.getParameter("cust_id");
str4=str4.trim();
String strQuery2 = "select * from Register_Info where Register_Id='" + str4 +"'";
String fname, frstname,lname,lstname,mname,midname,email,e_mail,actype,act_type,branch, branch_city;
frstname=request.getParameter("frstName");
frstname=frstname.trim();
lname=request.getParameter("lstName");
lname=lname.trim();
mname=request.getParameter("midName");
mname=mname.trim();
email=request.getParameter("email");
email=email.trim();
actype=(String)request.getParameter("AC_Type");
actype=actype.trim();
branch=(String)request.getParameter("Branch");
branch=branch.trim();
ResultSet result2 = state2.executeQuery(strQuery2);
while(result2.next())
{
fname=result2.getString("First_Name");
fname=fname.trim();
midname=result2.getString("Middle_Name");
midname=midname.trim();
lstname=result2.getString("Last_Name");
lstname=lstname.trim();
e_mail=result2.getString("email_id");
e_mail=e_mail.trim();
if((fname.equals(frstname))&&(lname.equals(lstname))&&(mname.equals(midname))&&(email.equals(e_mail)))
{
ctr=1;
flag1=2;
break;
}
}
connect1.close();
connect1=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
state3 = connect1.createStatement();
String strQuery3 = "select * from AcHolder_Info where Register_Id='" + str4 +"'";
ResultSet result3 = state3.executeQuery(strQuery3);
while(result3.next())
{
act_type=result3.getString("Account_Type");
act_type=act_type.trim();
branch_city=result3.getString("Branch");
branch_city=branch_city.trim();
if((actype.equals(act_type))&&(branch.equals(branch_city)))
{
ctr=1;
flag2=3;
break;
}
}
connect1.close();
if((flag!=1)&&(flag1==2)&&(flag2==3))
{
connect1=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
String pwd=request.getParameter("pwd");
PreparedStatement stat4= connect1.prepareStatement("insert into Login_Info values(?,?,?)");
stat4.setString(1,str4);
stat4.setString(2,str2);
stat4.setString(3,request.getParameter("pwd"));
stat4.executeUpdate();
out.println("恭喜您!!!!您已完成在线注册。单击登录按钮进行登录查看账户明细");
%>
<input type="button" value="登录" name="Login" onClick="login()">
<%
}
else
{
out.println("<b>");
out.println("对不起，您的注册请求被拒绝。请检查您是否已经注册或者您所提供的信息与数据库不相符。");
}
}
catch(Exception e)
{
out.println("异常被捕获" +e);
}
%>
<p>
<%
out.println("<h4>");
%>
</p>
<p>
<input type="button" value="返回注册页面" name="Back" onClick="goBack()">
<input type="button" value="取消" name="Login" onClick="goHome()">
</p>
<script Language="JavaScript">
function goBack()
{
open("Registered_usr_page.htm");
}
function goHome()
{
open("Home_page.htm");
}
function login()
{
open("Login_page.htm");
}
</script>
<p> </p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -