📄 guanliyuan2.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>
</head>
<body background="images/bg1.gif">
<div align="center">
<table width="760" border="0" cellpadding="0" cellspacing="0" background="images/bg01.gif">
<!--DWLayoutTable-->
<tr>
<td height="30" align="left" bgcolor="#FFFFFF"><img src="images/logo.gif" width="200" height="80"></td>
</tr>
<tr>
<td width="760" height="30" align="left" bgcolor="#FFFFFF"> </p> <div align="right"><img src="images/sign.gif" width="296" height="12">
</div>
<table width="760" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/bg01.gif">
<tr class="style16">
<td width="43" height="30" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">会员姓名</font></div></td>
<td width="48" background="images/bg01.gif" class="style16"><div align="center"><font color="#CC6600" size="1">会员密码</font></div></td>
<td width="46" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">Email</font></div></td>
<td width="42" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">提示问题</font></div></td>
<td width="55" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">问题答案</font></div></td>
<td width="36" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">姓名</font></div></td>
<td width="53" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">联系电话</font></div></td>
<td width="67" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">所在城市</font></div></td>
<td width="67" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">联系地址</font></div></td>
<td width="42" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">邮政编码</font></div></td>
<td width="42" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">生日</font></div></td>
<td width="40" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">性别</font></div></td>
<td width="53" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">个人主页</font></div></td>
<td width="32" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">QQ号</font></div></td>
<td width="32" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="1">管理</font></div></td>
</tr>
<%String sql="select * 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:index"," "," ");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{String username=rs.getString(1);
%>
<tr>
<td ><font size="1"><%=username%></font></td>
<td><font size="1"><%=rs.getString(2)%></font></td>
<td><font size="1"><%=rs.getString(3)%></font></td>
<td><font size="1"><%=rs.getString(4)%></font></td>
<td><font size="1"><%=rs.getString(5)%></font></td>
<td><font size="1"><%=rs.getString(6)%></font></td>
<td><font size="1"><%=rs.getString(7)%></font></td>
<td><font size="1"><%=rs.getString(8)%></font></td>
<td><font size="1"><%=rs.getString(9)%></font></td>
<td><font size="1"><%=rs.getString(10)%></font></td>
<td><font size="1"><%=rs.getString(11)%></font></td>
<td><font size="1"><%=rs.getString(12)%></font></td>
<td><font size="1"><%=rs.getString(13)%></font></td>
<td ><font size="1"><%=rs.getString(14)%></font></td>
<td ><font size="1"><a href="delet.jsp?username=<%=username%>">删除</a></font></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"><a href="index.htm" class="style17">
</a>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
<param name="BGCOLOR" value="">
<param name="movie" value="button2.swf">
<param name="quality" value="high">
<param name="base" value=".">
<embed src="button2.swf" base="." quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="22" ></embed>
</object>
</p></td>
</tr>
<tr>
<td height="16" align="center" background="images/bg_menu.gif"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="27" align="center"> <p align="center" class="style12"> </p></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -