📄 lxlook.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 lx";
ResultSet rs=sm.executeQuery(str);
%>
<table width="100%" align="center" border="1" cellpadding="1">
<tr>
<td width="40" align="center">编号</td>
<td width="293" align="center">路线安排</td>
<td width="227" align="center">食宿交通</td>
<td width="68">手续价格</td>
<td width="274" align="center">联系方式</td>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getInt("id")%></td>
<td><%=rs.getString("anpai")%></td>
<td><%=rs.getString("ssjt")%></td>
<td><%=rs.getInt("money")%></td>
<td><%=rs.getString("lx")%></td>
</tr>
<%
}
sm.close();
con.close();
}
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 + -