📄 registernetmember.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page import="java.sql.*"%><%--The taglib directive below imports the JSTL library. If you uncomment it,you must also add the JSTL library to the project. The Add Library... actionon Libraries node in Projects view can be used to add the JSTL 1.1 library.--%><%--<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> --%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>网上银行</title> </head> <body background="D:/YJ/YJ1.23/NetBank/background/b100.gif"> <font face="隶书" color="blue" size=3> <% String userName=request.getParameter("userName"); String userPassword = request.getParameter("userPassword"); String reUserPassword=request.getParameter("rePassword"); String servicePassword = request.getParameter("servicePassword"); String reServicePassword=request.getParameter("reServicePassword"); String accountID = " "+request.getParameter("accountID"); String IDcard = request.getParameter("ID"); String accountPassword = request.getParameter("accountPassword"); String address = request.getParameter("address"); String phone = request.getParameter("phone"); String mobile = request.getParameter("mobile"); String email = request.getParameter("email"); if(!userPassword.equals(reUserPassword)) { %> <p align = "center"> 两次输入的登陆密码不一致，请重新输入 <p align = "center"> <a href = "Register.html">回到注册界面</a> <meta http-equiv="refresh" content="2; URL=Register.html"> <% } else if(!servicePassword.equals(reServicePassword)) { %> <p align = "center"> 两次输入的服务密码不一致，请重新输入 <p align = "center"> <a href = "Register.html">回到注册界面</a> <meta http-equiv="refresh" content="2; URL=Register.html"> <% } else { String dbUrl = "jdbc:odbc:afei"; String user = "scott"; String password = "tiger"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection(dbUrl,user,password); String sql = "Select * from deAccount where accountID = '"+accountID+"'"; Statement stat = conn.createStatement(); ResultSet result = stat.executeQuery(sql); if(!result.next()) { %> <p align = "center"> 对不起，您输入的帐号不存在！ 请重新输入 <p align = "center"> <a href = "Register.html">回到注册界面</a> <meta http-equiv="refresh" content="2; URL=Register.html"> <% } else { String sql1 = "Select * from deAccount where accountID = '"+accountID+"' and IDcard = '"+IDcard+"'"; ResultSet result1 = stat.executeQuery(sql1); if(!result1.next()) { %> <p align = "center"> 对不起，您输入的帐号和身份证号不匹配！ 请重新输入 <p align = "center"> <a href = "Register.html">回到注册界面</a> <meta http-equiv="refresh" content="2; URL=Register.html"> <% } else { String sql2 = "Select * from deAccount where accountID = '"+accountID+"' and IDcard = '"+IDcard+"' and accountPassword='"+accountPassword+"'"; ResultSet result2 = stat.executeQuery(sql2); if(!result2.next()) { %> <p align = "center"> 对不起，您输入的密码错误！ 请重新输入 <p align = "center"> <a href = "Register.html">回到注册界面</a> <meta http-equiv="refresh" content="2; URL=Register.html"> <% } else { CallableStatement proc = conn.prepareCall("{ call InsertNetMember(?,?,?,?,?,?,?,?) }"); proc.setString(1, userName); proc.setString(2, userPassword); proc.setString(3,servicePassword); proc.setString(4, accountID); proc.setString(5, IDcard); proc.setString(6,phone); proc.setString(7, mobile); proc.setString(8, email); proc.execute(); proc.close(); conn.close(); } } } %> <p align = "center"> 祝贺您注册成功 <meta http-equiv="refresh" content="2; URL=Login.html"> <% } catch(Exception connectException) { out.println(connectException); out.println("连接数据库失败，请联系管理员！"); } } %> </font> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -