📄 guanliyuan.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看会员资料</title>
</head>
<body background="images/bg1.gif">
<div align="center">
<%!
String username2;
String password2;
String name;
String pass;
%>
<%
name=request.getParameter("username2");
pass=request.getParameter("password2");
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr="jdbc:odbc:index";
String sql="select * from guanliyuan where name like ";
try
{
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("加载驱动失败!");
}
try
{
Connection conn=DriverManager.getConnection(ConnStr,"","");
ResultSet rs;
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql+"'"+name+"'");
while(rs.next())
{
username2=rs.getString(1);
password2=rs.getString(2);
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("读出数据失败!");
}
%>
<%
if(!username2.equals(name) || !password2.equals(pass))
{ out.println("<p>"+"密码输入错误，登录失败!"+"<p>"+"请重新登录");
response.setHeader("Refresh","5;URL=index.htm");
return;}
else
{
%>
<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="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/bg01.gif">
<tr class="style16">
<td width="250" height="30" background="images/bg01.gif"><div align="center"><font color="#CC6600" size="2">会员姓名</font></div></td>
<td width="280" background="images/bg01.gif" class="style16"><div align="center"><font color="#CC6600" size="2">密码</font></div></td>
<td ><div align="center"><font size="2">管理</font></div></td>
</tr>
<%String sql2="select * from zhuce";
ResultSet rs2=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn2=DriverManager.getConnection("jdbc:odbc:index"," "," ");
Statement stmt2=conn2.createStatement();
rs2=stmt2.executeQuery(sql2);
while(rs2.next())
{String username=rs2.getString(1);
String password=rs2.getString(2);
%>
<tr>
<td ><div align="center"><font size="2"><%=username%></font></div></td>
<td><div align="center"><font size="2"><%=password%></font></div></td>
<td width="222" ><p align="center"><font size="2"><a href="guanliyuan2.jsp">察看会员资料</a></font></p></td>
</tr>
<%} stmt2.close();
conn2.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></p>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td width="33%"><div align="center"><font color="#CC6600" size="2">姓名</font></div></td>
<td width="38%"><div align="center"><font color="#CC6600" size="2">留言主题</font></div></td>
<td width="29%"><div align="center"><font color="#000000" size="2">管理</font></div></td>
</tr>
<tr>
<%
String sql3="select * from liuyan";
ResultSet rs3=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn3=DriverManager.getConnection("jdbc:odbc:index"," "," ");
Statement stmt3=conn3.createStatement();
rs3=stmt3.executeQuery(sql3);
while(rs3.next())
{String username=rs3.getString(1);
String memo=rs3.getString(6);
%>
<td><div align="center"><font size="2"><%=username%></font></div></td>
<td><div align="center"><font size="2"><%=memo%></font></div></td>
<td><div align="center"><font size="2"><a href="guanliyuan3.jsp">查看留言</a></font></div></td>
</tr>
<%} stmt3.close();
conn3.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
//out.println("数据没有写入");
}%>
</table>
<p align="center" class="style12">
<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="20">
<param name="movie" value="button3.swf">
<param name="quality" value="high">
<param name="base" value=".">
<embed src="button3.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="20" ></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 + -