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

📄 userdetail.jsp

📁 一个使用jdbc存储和调用大对象(比如图片等)的例子
💻 JSP
字号:
<html>
<head>
<title>查看个人资料</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="bbs.css">
<style type="text/css">
</style>
</head>
<body bgcolor="#FFF9F0">
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn = OPDB.getConn();

String username = OPDB.AsciiToChineseString(request.getParameter("name"));
String sql = "";
int i = username.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
	username = username.substring(0,i);
	sql = "select email,homepage,userlevel,experience from t_bbs_user where username = '" + username + "' and usertype = 'Y'";
}
else {
	sql = "select email,homepage,userlevel,experience from t_bbs_user where username = '" + username + "' and usertype = 'N'";
}
ResultSet rs = OPDB.select(conn,sql);
rs.next();
String email = rs.getString("email");
if (email == null) email = "保密";
String homepage = rs.getString("homepage");
if (homepage == null) homepage = "保密";
String userlevel = OPDB.GBK(rs.getString("userlevel"));
String experience = rs.getString("experience");
String name = request.getParameter("name");
rs.close();
%>
<table width="280" border="2" cellpadding="3" align="center">
  <tr> 
    <td align="right">大名:</td>
    <td><%= name %></td>
  </tr>
  <tr> 
    <td align="right">密码:</td>
    <td>嘻嘻,这个不许看!</td>
  </tr>
  <tr> 
    <td align="right">电子信箱:</td>
    <td><%= email %></td>
  </tr>
  <tr> 
    <td align="right">个人主页:</td>
    <td><%= homepage %></td>
  </tr>
  <tr> 
    <td align="right">当前身份:</td>
    <td><%= userlevel %></td>
  </tr>
  <tr>
    <td align="right">当前功力:</td>
    <td><%= experience %></td>
  </tr>
</table>
<p align="center"><a href="javascript:window.close();">关闭</a></p>
</body>
</html>

⌨️ 快捷键说明

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