📄 checkupoper.jsp
字号:
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>会员登录验证</title>
</head>
<body>
<%@page import="java.sql.*"%>
<%
String number=request.getParameter("number");
String password=request.getParameter("password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:xgx");
Statement stmt=conn.createStatement();
String sqlstr="Select * from customer where cNo='"+number+"' and keyword='"+password+"'";
//out.print(sqlstr);
ResultSet rs=stmt.executeQuery(sqlstr);
if(rs.next())
{
out.print("登录成功<p></p>1.<a href=bookpage.jsp>图书预订</a><p></p>");
out.print("2.<a href=paymentpage.jsp>支付管理</a><p></p>");
out.print("3.<a href=bookinfo.jsp>图书信息查询</a><p></p>");
out.print("4.<a href=liuyan.jsp>顾客留言</a>");
}
else
{
out.print("密码错误或者帐号不存在 <a href=index.jsp>返回首页</a>");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -