📄 userinf.jsp.htm
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.*,java.sql.*,java.text.DateFormat,java.net.*"%>
<html>
<head>
<title>用户信息板块列表</title>
</head>
<body>
<%//防止某些用户不进行登陆，直接想进入此页面
if (session.getAttribute("username")==null){
response.sendRedirect("login1.jsp");
}%>
<%
String username=(String)session.getAttribute("username");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql="";
sql="select * from User where UserName='"+username+"'";
ResultSet rs=stmt.executeQuery(sql); //执行查询操作
rs.next();
%>
<table width="90%" align="center" cellpadding="3" cellspacing="1">
<tr>
<td colspan="2" bgcolor="#009933">      用户 <%=username%>
    <a href="javascript:history.back();">返回</a>
</td>
</tr>
<form name="myform" method="post" action="mod.jsp?userneme=<%=username%>" OnSubmit="return checkdata();">
<tr>
<td bgcolor="#efefef" width="37%">编号</td>
<td bgcolor="#efefef" width="63%">
<%=rs.getString("ID")%>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">用户名</td>
<td bgcolor="#efefef" width="63%">
<%=username%>
<input type="hidden" name="username" value="<%=username%>">
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">密码</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="password" value=<%=rs.getString("Password")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">Email</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="email" value=<%=rs.getString("Email")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">性别</td>
<td bgcolor="#efefef" width="63%">
<%
if(rs.getString("Sex").equals("men")) {%>
<input type="radio" name="sex" value="men" checked><img src="images/boy.gif" width="24" height="24">男孩
<input type="radio" name="sex" value="women"><img src="images/girl.gif" width="26" height="26">女孩
<%}else{%>
<input type="radio" name="sex" value="men"><img src="images/boy.gif" width="24" height="24">男孩
<input type="radio" name="sex" value="women" checked><img src="images/girl.gif" width="26" height="26">女孩
<%}%>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">电话</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="phone" value=<%=rs.getString("Phone")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">地址</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="address" value=<%=rs.getString("Address")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">年龄</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="age" value=<%=rs.getString("Age")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">头像</td>
<td bgcolor="#efefef" width="63%">
<select name="face" size=1 onChange="document.images['face'].src=options[selectedIndex].value;">
<%
for (int i=1;i<=60;i++)
out.println("<option value=images/face/Image" + i + ".gif>Image"+ i +"</option>");
%>
</select>
<img id=face src=<%=rs.getString("Face")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">发贴数</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="postnumber" value=<%=rs.getInt("PostNumber")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">等级</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="rank" value=<%=rs.getInt("Rank")%>>
</td>
</tr>
<tr>
<td colspan=2>
<center>
<input type="submit" value="确定">      
<input type="reset" value="重置">
</center>
</td>
</tr>
</table>
<% stmt.close();
conn.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -