📄 display.jsp
字号:
<!--display.jsp-->
<%@ page import="java.sql.*" contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>
</title>
</head>
<body bgcolor="#ffffff">
<h2>
查询结果如下：
</h2>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:saloryDSN";
String user="admin";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
stmt.setMaxRows(10);
String query=request.getParameter("query");
out.print(query);
ResultSet rs=stmt.executeQuery(query);
ResultSetMetaData rsmd=rs.getMetaData();
int cols=rsmd.getColumnCount();
out.println("<table border=6>");
out.println("<tr bgcolor=lightblue>");
for(int i=1;i<=cols;i++)
{
out.print("<th>");
out.print(rsmd.getColumnLabel(i));
out.println("</th>");
}
out.print("</tr>");
while(rs.next()){
out.print("<tr bgcolor=lightyellow>");
for(int i=1;i<=cols;i++){
out.print("<td>");
Object obj=rs.getObject(i);
if(obj!=null)
out.print(obj.toString());
else
out.print("");
out.println("</td>");
}//end of for
out.print("</tr>");
}//end of while
out.print("</table>");
rs.close();
stmt.close();
conn.close();
}
catch(ClassNotFoundException ex){
out.println(ex.getMessage());
}
catch(SQLException ex){
out.println(ex.getMessage());
}
%>
<a href="query.jsp">下一个查询</a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -