?? userview.jsp
字號(hào):
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>個(gè)人信息查詢</title>
</head>
<body background="/image/BLUE3.JPG">
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=GBK"%>
<%
String userId=(String)session.getAttribute("logName");
try
{
String url=new String();
url="jdbc:odbc:bookStore";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement(); //ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String strin=new String();
strin="select * from client where logName='"+userId+"'";
ResultSet rs=stmt.executeQuery(strin);
rs.next();
%>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 真實(shí)姓名：
<%
out.println(rs.getString("realName"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 登錄名：<%=rs.getString("logName")%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 性別：
<%
out.println(rs.getString("sex"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 星級(jí)：
<%
out.println(rs.getString("grade"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 帳戶余額：
<%
out.println(rs.getString("account"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 用戶總的消費(fèi)額：
<%
out.println(rs.getDouble("totalCost"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 聯(lián)系電話：
<%
out.println(rs.getInt("telNumber"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 地址：
<%
out.println(rs.getString("address"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2"> 郵箱：
<%
out.println("mailbox");
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</font></p>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -