sqlviewer_v2.jsp
来自「精通从JavaScript到Jsp范例程序设计」· JSP 代码 · 共 66 行
JSP
66 行
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="xbook.common.*" %>
<%@ page contentType="text/html; charset=Big5" %>
<jsp:useBean id="connPool" scope="application" class="xbook.common.ConnPool" >
<jsp:setProperty name="connPool" property="driverName" value="weblogic.jdbc.mssqlserver4.Driver" />
<jsp:setProperty name="connPool" property="jdbcURL" value="jdbc:weblogic:mssqlserver4:JavaDB@BigSun:1433" />
<jsp:setProperty name="connPool" property="userName" value="admin" />
<jsp:setProperty name="connPool" property="password" value="admin" />
<jsp:setProperty name="connPool" property="connectionSwitch" value="on" />
</jsp:useBean>
<jsp:useBean id="sqlBridge" scope="page" class="xbook.common.SQLBridge" >
<jsp:setProperty name="sqlBridge" property="connPool" value="<%=connPool %>" />
<jsp:setProperty name="sqlBridge" property="connectionSwitch" value="on" />
</jsp:useBean>
<%
String sqlStatements=ISOtoBig5.convert( request.getParameter( "SQL-statements" ) ) ;
if( sqlStatements==null )
throw new ServletException( "SQL-statement not found." ) ;
%>
<html>
<head>
<title>SQLViewer</title>
</head>
<body bgcolor="#FFFFFF">
<%
try {
%>
SQL:<strong><%=sqlStatements %></strong><br>
<%
int numRows=0 ;
if( ( numRows=sqlBridge.execSQL( sqlStatements ) )==-1 ) {
%>
<table width="100%" border="1" cellpadding="1" cellspacing="1" >
<tr>
<%
String[] columnName=sqlBridge.getColumnNames() ;
for( int j=0 ; j<columnName.length ; j++ ) {
%>
<td>
<div align="center"><%=columnName[j] %></div>
</td>
<%
}
%>
</tr>
<%
while( sqlBridge.nextRow() ) {
%>
<tr>
<%
for( int k=1 ; k<=sqlBridge.getColumnCount() ; k++ ) {
%>
<td>
<div align="left"><%=sqlBridge.getFieldString( k ) %></div>
</td>
<%
}
%>
</tr>
<%
}
%>
</table>
磅︽Θ⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?