📄 querydatabase.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" language="java" %>
<%@ page import="java.sql.*"%>
<html><title>数据库查询示例</title>
<link href="css/common.css" rel="stylesheet" type="text/css">
<link href="../css/common.css" rel="stylesheet" type="text/css">
<body>
<% Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver").newInstance();
try{con=DriverManager.getConnection("jdbc:mysql://192.168.219.148/ciqms?user=jiasir&password=jiasir&useUnicode=true&characterEncoding=gbk");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM passenger");
out.print("<Table border=0 cellpadding=1 cellspacing=1>");
out.print("<tr>");
out.print("<td><TH width=100 class=\"table\">"+"机票号</td>");
out.print("<td><TH width=100 class=\"table\">"+"旅客姓名</td>");
out.print("<td><TH width=100 class=\"table\">"+"证件种类</td>");
out.print("<td><TH width=100 class=\"table\">"+"证件号码</td>");
out.print("<td><TH width=100 class=\"table\">"+"旅客国籍</td>");
out.print("<td><TH width=100 class=\"table\">"+"违禁品编号</td>");
out.print("<td><TH width=100 class=\"table\">"+"违禁品名</td>");
out.print("<td><TH width=100 class=\"table\">"+"违禁品数量</td>");
out.print("<td><TH width=100 class=\"table\">"+"扣留</td>");
out.print("<td><TH width=100 class=\"table\">"+"进出口</td>");
out.print("<td><TH width=100 class=\"table\">"+"航班号</td>");
out.print("<td><TH width=100 class=\"table\">"+"航班日期</td>");
out.print("<td><TH width=100 class=\"table\">"+"信息插入日期</td>");
out.print("<td><TH width=100 class=\"table\">"+"插入人Id</td>");
out.print("<td><TH width=100 class=\"table\">"+"信息修改日期</td>");
out.print("<td><TH width=100 class=\"table\">"+"修改人Id</td>");
out.print("</tr>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD class=\"table\">"+rs.getString(1)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(2)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(3)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(4)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(5)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(6)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(7)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(8)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(9)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(10)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(11)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(12)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(13)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(14)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(15)+"</TD>");
out.print("<TD class=\"table\">"+rs.getString(16)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}
catch(SQLException e1){}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -