📄 alterinfo.jsp

📁 一个简单的银行管理系统
💻 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/0003.gif">    <%        String loginID = (String)session.getAttribute("userName");	String accountID = "";	String addr = "";	String phone = "";	String mobilePhone = "";	String email = "";        String IDcard = "";                       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 netMember.accountID,addr,phone,mobilePhone,email,IDcard from netMember,deAccount where netMember.accountID = deAccount.accountID and loginID = '"+loginID+"'";            Statement stat = conn.createStatement();            ResultSet result = stat.executeQuery(sql);                       if(result.next())            {                accountID = result.getString("accountID");                addr = result.getString("addr");	        phone = result.getString("phone");                mobilePhone = result.getString("mobilePhone");                email = result.getString("email");                IDcard = result.getString("IDcard");            }            conn.close();        }        catch(Exception connectException)        {            out.println(connectException);            out.println("连接数据库失败！  请与管理员联系！");        }    %>    <form name="alter" action="UpdateInfo.jsp" method="POST">      <p align="center">        <font face="隶书" color="blue" size=3>修改资料</font>      <p align="center">        <font face="隶书" color="blue" size=3>用户名称</font>        <input type="text" name="userName" value=<%=loginID%> disabled/>      <p align="center">        <font face="隶书" color="blue" size=3>登陆密码</font>        <input type="password" name="userPassword" value="" />      <p align="center">        <font face="隶书" color="blue" size=3>重复密码</font>        <input type="password" name="rePassword" value="" />      <p align="center">        <font face="隶书" color="blue" size=3>服务密码</font>        <input type="password" name="servicePassword" value="" />      <p align="center">        <font face="隶书" color="blue" size=3>重复密码</font>        <input type="password" name="reServicePassword" value="" />      <p align="center">        <font face="隶书" color="blue" size=3>关联帐号</font>        <input type="text" name="accountID" value=<%=accountID%> disabled/>      <p align="center">        <font face="隶书" color="blue" size=3>身份证号</font>        <input type="text" name="ID" value=<%=IDcard%> disabled/>      <p align="center">        <font face="隶书" color="blue" size=3>家庭住址</font>        <input type="text" name="address" value=<%=addr%> />      <p align="center">        <font face="隶书" color="blue" size=3>固定电话</font>        <input type="text" name="phone" value=<%=phone%> />      <p align="center">        <font face="隶书" color="blue" size=3>移动电话</font>        <input type="text" name="mobile" value=<%=mobilePhone%> />      <p align="center">        <font face="隶书" color="blue" size=3>电子邮箱</font>        <input type="text" name="email" value=<%=email%> />     <p align="center">        <input type="submit" value="修改" name="commit" />        <input type="reset" value="重置" name="reset" />  </form>    </body></html>
⌨️ 快捷键说明

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