📄 buklook.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<html>
<head><title>查看预约</title><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<body>
<hr>
<h4>信息：</h4>
<%@ page import="java.sql.*"%>
<%
try{
request.setCharacterEncoding("gb2312");
String str;
String sou=request.getParameter("sou");
String datauser="root";
String datapw="L0VEXING";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/luyou?user="+datauser+"&password="+datapw+"&useUnicode=true&characterEncoding=GB2312" ;
Connection con= DriverManager.getConnection(url);
Statement sm=con.createStatement();
str="select * from buk";
ResultSet rs=sm.executeQuery(str);
int i=0;
%>
<table width="33%" align="center" border="1" cellpadding="1">
<tr>
<td width="142" align="center">姓名</td>
<td width="184" align="center">预约线路编号</td>
</tr>
<%
while(rs.next()){
i++;
%>
<tr>
<td align="center"><%=rs.getString("name")%></td>
<td align="center"><%=rs.getInt("id")%></td>
</tr>
<%
}
sm.close();
con.close();%>
<table width="60%" border="0" cellpadding="0">
<tr>
<td align="center">共<%=i%>个预约</td>
</tr>
</table>
<%}
catch(Exception e)
{
out.print("未知错误，请联系管理员");
}
%>
</table>
<hr>
<table width="100%" border="0" cellpadding="0" align="center">
<tr>
<td align="center"><a href="index.html" title="返回">返回</a></td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -