📄 123.jsp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.String.*" %>
<%!
public String codeToString(String str)
{
String s=str;
try
{
byte temp[]=s.getBytes("ISO_8859_1");
s=new String (temp);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>我的图书馆</title>
<link href="site.css" rel="stylesheet" type="text/css" />
<link href="sitecss1.css" rel="stylesheet" type="text/css" />
<style type="text/css">
/*<![CDATA[*/
td.c2 {color: #FFFFFF}
b.c1 {color: #FFFFFF}
/*]]>*/
</style>
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="bottom" colspan="4">
<table width="70%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="bottom">
<table width="100" border="0" cellpadding="0" cellspacing="0" class="graytd">
<tr>
<td class="grayleft"><img src="../tpl/blue/image/g_left_top_bottom.gif" width="5" height="4"></td>
<td height="4"></td>
<td class="grayright"><img src="../tpl/blue/image/g_right_top_bottom.gif" width="5" height="4"></td>
</tr>
<tr>
<td width="5"></td>
<td height="20" align="center"><b class="p3"><a class="header" href="search.html">书目检索</a></b></td>
<td width="5"></td>
</tr>
</table>
</td>
<td><table width="100" border="0" cellpadding="0" cellspacing="0" class="bluetable">
<tr>
<td class="bluelefttd"></td>
<td height="4"></td>
<td class="bluerighttd"></td>
</tr>
<tr>
<td width="5"></td>
<td height="20" align="center"><b class="p3"><a class="header" href="redr_info.jsp"><font color="#FFFFFF">我的图书馆</font></a></b></td>
<td width="5"></td>
</tr>
</table></td>
<td><table width="100" border="0" cellpadding="0" cellspacing="0" bgcolor="#E2E2E3">
<tr>
<td width="5" height="4"><img src="../tpl/blue/image/g_left_top_bottom.gif" width="5" height="4"></td>
<td height="4"></td>
<td width="5" height="4"><img src="../tpl/blue/image/g_right_top_bottom.gif" width="5" height="4"></td>
</tr>
<tr>
<td width="5"></td>
<td height="20" align="center"><b class="p3"><a class="header" href="../opac/newbook.php">新书通报</a></b></td>
<td width="5"></td>
</tr>
</table></td>
<td><table width="100" border="0" cellpadding="0" cellspacing="0" bgcolor="#E2E2E3">
<tr>
<td width="5" height="4"><img src="../tpl/blue/image/g_left_top_bottom.gif" width="5" height="4"></td>
<td height="4"></td>
<td width="5" height="4"><img src="../tpl/blue/image/g_right_top_bottom.gif" width="5" height="4"></td>
</tr>
<tr>
<td width="5"></td>
<td height="20" align="center"><b class="p3"><a class="header" href="../opac/asord.php">订购征询</a></b></td>
<td width="5"></td>
</tr>
</table></td>
<td><table width="100" border="0" cellpadding="0" cellspacing="0" bgcolor="#E2E2E3">
<tr>
<td width="5" height="4"><img src="../tpl/blue/image/g_left_top_bottom.gif" width="5" height="4"></td>
<td height="4"></td>
<td width="5" height="4"><img src="../tpl/blue/image/g_right_top_bottom.gif" width="5" height="4"></td>
</tr>
<tr>
<td width="5"></td>
<td height="20" align="center"><b class="p3"><a class="header" href="../opac/announce.php">信息发布</a></b></td>
<td width="5"></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String Studentno=codeToString(request.getParameter("id"));
String Studentpwd=codeToString(request.getParameter("password"));
out.println("Studentpwd="+Studentpwd);
String sqlString=null;
HttpSession mysession=request.getSession();
sqlString="select *from readers where readerno = '"+Studentno+"'";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.println("can find");
}
try
{
con=DriverManager.getConnection("jdbc:odbc:datebase","sa","123");
//sql=con.createStatement(sqlString);
sql=con.createStatement();
try
{
rs=sql.executeQuery(sqlString);
}
catch(Exception e)
{
out.print("<table><tr><td>您输入的信息有错误</td></tr></table>");
}
if(!rs.next())
{
out.print("<table><tr><td>您输入的信息有错误</td></tr></table>");
}
else
{
if(Studentpwd.compareTo(rs.getString("Readerpwd"))!=0)
out.print("<table><tr><td>您输入的密码有错误</td></tr></table>");
else{
session.setAttribute("id",Studentno);
%>
<tr>
<td height='28' valign='bottom'>
<table width='100%' border='0' cellspacing='0' cellpadding='0' bgcolor='#0163a1' height=27>
<tr><td height='5'></td></tr>
<tr valign='bottom' class='p4'>
<td width='12%'></td>
<td align="left">
<% out.print("<a class='a3' href='reader1.jsp'>读者信息</a>");%>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=3">书刊借阅</a>
<font color="#FFFFFF">| </font>
<% out.print("<a class='a3' href='reader3.jsp'>修改密码</a>");%>
<font color="#FFFFFF">| </font>
<% out.print("<a class='a3' href='reader4.jsp'>修改个人信息</a>");%>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=6">预约委托</a>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=7">到书情况</a>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=8">书刊遗失</a>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=9">读者定制</a>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=11">借阅规则</a>
<font color="#FFFFFF">| </font>
<a class="a3" href="../reader/main.php?tab=12">短信服务</a>
<td><a class="a3" href="logout.jsp"><font color="#FFFFFF">注销</font></a></td>
</tr>
<tr><td height="5" colspan="3"></td></tr>
</table>
</td>
</tr>
</td>
</tr>
<tr>
<td height="21" valign="top">
</td>
</tr>
</table>
<TABLE width="100%" border=0 cellPadding=0 cellSpacing=1>
<tr><td align="center" height="10"> </td></tr>
<tr><td align="center"><a class="a2" href="../reader/redr_cust_edit.php">修改读者定制信息</a></td></tr>
<tr><td align="center" height="10"> </td></tr>
</table>
<TABLE cellSpacing=0 cellPadding=0 width=100% align=left valign="top">
<TR>
<TD colSpan=2>
<TABLE width="100%" border=0 cellPadding=0 cellSpacing=1>
<tr><td align="center" height="10"> </td></tr>
<tr><td align="center"><a class="a2" href="../reader/redr_cust_edit.php">修改读者定制信息</a></td></tr>
<tr><td align="center" height="10"> </td></tr>
</table>
</TD></TR></TABLE>
<%}
}
}
catch(SQLException e)
{
out.println(e.getMessage());
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -