📄 userinfo.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page language = "java" %>
<html>
<head>
<title>音乐天堂--个人信息</title>
<link href="../theme/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<br>
<body background="../../IMAGES/bg05.gif">
<a class="title">查看个人信息</a>
<%
String userid = new String(request.getParameter("userid").trim().getBytes("ISO-8859-1"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:MusicSky","sa","");
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT USER_ID,USER_PASSWORD,USER_NAME,ADDRESS,PHONE,EMAIL FROM userpassword WHERE USER_ID='"+userid+"'" );
%>
<table width="400" border="1" cellpadding="0" cellspacing="0">
<tr>
<% while(rs.next())
{
%>
<td width="85" align="right">用户名：</td>
<td width="309"><%=rs.getString("USER_ID")%></td>
</tr>
<tr>
<td width="85" align="right">密码：</td>
<td width="309"><%=rs.getString("USER_PASSWORD")%></td>
</tr>
<tr>
<td width="85" align="right">真实姓名：</td>
<td width="309"><%=rs.getString("USER_NAME")%></td>
</tr>
<tr>
<td width="85" align="right">联系地址：</td>
<td width="309"><%=rs.getString("ADDRESS")%></td>
</tr>
<tr>
<td width="85" align="right">联系电话：</td>
<td width="309"><%=rs.getString("PHONE")%> </td>
</tr>
<tr>
<td width="85" align="right">电子邮件：</td>
<td width="309"><%=rs.getString("EMAIL")%></td>
</tr>
<tr>
<td height="49" colspan="2" align="right">
<div align="center">
<input type="button" name="clostbtn" value="请继续购物-_-" onclick="javascript:window.close();return false;">
</div></td>
</tr>
<%}%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -