⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 userview.jsp

📁 面向对象软件工程案例
💻 JSP
字号:
🔍 
<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>个人信息查询</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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 真实姓名：&nbsp;&nbsp;&nbsp;
 <%
 out.println(rs.getString("realName"));
%>
       
         </font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;登录名：<%=rs.getString("logName")%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; 性别：
<%
out.println(rs.getString("sex"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 星级：
<%
out.println(rs.getString("grade"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 帐户余额：
<%
out.println(rs.getString("account"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 用户总的消费额：
<%
out.println(rs.getDouble("totalCost"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 联系电话：
<%
out.println(rs.getInt("telNumber"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 地址：
<%
out.println(rs.getString("address"));
%>
</font></p>
<p class="MsoNormal" style="line-height: 200%"><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 邮箱：
<%
out.println("mailbox");
        }
        catch(Exception e)
        {
          out.println(e.toString());
        }
%>
</font></p>

</body>

</html>

⌨️ 快捷键说明

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