📄 adxiugaishanchu.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看会员资料</title>
<style type="text/css">
<!--
body {
}
body,td,th {
font-size: 14px;
}
.style16 {
color: #0099CC;
font-weight: bold;
}
.style17 {font-size: 14px}
.style18 {
color: #996633;
font-weight: bold;
}
.style19 {color: #996633}
.style20 {
font-size: 36px;
color: #FF3300;
}
.style2 {color: #3333FF;
font-size: 18px;
font-family: "幼圆";
}
.style5 {font-family: "幼圆";
font-size: 18px;
}
.style7 {font-family: "幼圆"; font-size: 18px; color: #0000FF; }
-->
</style></head>
<body>
<div align="center">
<table width="991" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="991" height="7" align="left"> </p> <div align="center"><span class="style20">用户资料查询及修改</span> </div> <div align="center"> </div>
<div align="center"></div> </td>
</tr>
<tr>
<td height="8" align="left"><p> </p>
<p align="center" class="style20"> </p></td>
</tr>
<tr>
<td height="15" align="left"><table width="976" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#C6D8E7">
<tr bgcolor="#E3E4E8" class="style16">
<td width="62" height="30"><div align="center" class="style18">用户名</div></td>
<td width="76" class="style16"><div align="center" class="style19">密码</div></td>
<td width="83"><div align="center" class="style19">真实姓名</div></td>
<td width="90"><div align="center" class="style19">性别</div></td>
<td width="84"><div align="center" class="style19">年龄</div></td>
<td width="84"><div align="center" class="style19">联系电话</div></td>
<td width="90"><div align="center" class="style19">电子邮箱</div></td>
<td width="86"><div align="center" class="style19">提示问题</div></td>
<td width="93"><div align="center" class="style19">回答问题</div></td>
<td width="103"><div align="center" class="style19">是否删除？</div></td>
<td width="101"><div align="center" class="style19">需要修改？</div></td>
</tr>
<%String sql="select name,password,truename,sex,age,tel,email,wenti,daan from zhuce";
ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn=DriverManager.getConnection("jdbc:odbc:d"," "," ");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{String name=rs.getString(1);
%>
<tr>
<td height="25"><div align="center"><%=name%>
<input name="hiddenField" type="hidden" value="<%=name%>">
</div></td>
<td><div align="center"><%=rs.getString(2)%></div></td>
<td><div align="center"><%=rs.getString(3)%></div></td>
<td><div align="center"><%=rs.getString(4)%></div></td>
<td><div align="center"><%=rs.getString(5)%></div></td>
<td><div align="center"><%=rs.getString(6)%></div></td>
<td><div align="center"><%=rs.getString(7)%></div></td>
<td><div align="center"><%=rs.getString(8)%></div></td>
<td><div align="center"><%=rs.getString(9)%></div></td>
<td><div align="center"><a href="deleuser.jsp?name=<%=name%>">删</a></div></td>
<td><div align="center"><a href="userxiugai1.jsp?name=<%=name%>">修改信息</a></div></td>
</tr>
<%} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%>
</table></td>
</tr>
<tr>
<td height="12" align="center"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="12" align="center"><p align="center" class="style12"><span class="style2"></span></p></td>
</tr>
<tr>
<td height="27" align="center"><hr size="1" class="style12">
<p align="center" class="style12"> </p></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -