怎样在JBuilder中配置JSP中的DataSource?

wangb 2002-07-29 02:18:28

小弟想在JBuilder中运行如下,无奈总是提示DataSource找不到?请问怎样才能让下面这个JSP在JBuilder中运行起来,小弟多谢了!
JSP如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.lang.*,javax.naming.*,javax.sql.*" %>
<%
java.sql.Connection sqlCon; //数据\u5E93\u8FDE接\u5BF9象

java.sql.Statement sqlStmt; //SQL\u8BED句\u5BF9象

java.sql.ResultSet sqlRst; //\u7ED3果集\u5BF9象

java.lang.String strCon; //数据\u5E93\u8FDE接字符串

java.lang.String strSQL; //SQL\u8BED句

int intPageSize; //一\u9875\u663E示的\u8BB0\u5F55数

int intRowCount; //\u8BB0\u5F55\u603B数

int intPageCount; //\u603B\u9875数

int intPage; //待\u663E示\u9875\u7801

java.lang.String strPage;

int i,j,k; //\u8BBE置一\u9875\u663E示的\u8BB0\u5F55数

intPageSize = 5; //取得待\u663E示\u9875\u7801

strPage = request.getParameter("page");

if(strPage==null){

intPage = 1;

} else{

intPage = java.lang.Integer.parseInt(strPage);

if(intPage<1) intPage = 1; }

//Datasource
// Obtain our environment naming context

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up our data source
DataSource ds = (DataSource)
envCtx.lookup("jdbc/BookDB");
sqlCon = ds.getConnection();

sqlStmt = sqlCon.createStatement();

strSQL = "select count(*) from guestbook";

sqlRst = sqlStmt.executeQuery(strSQL);

sqlRst.next();

intRowCount = sqlRst.getInt(1);

sqlRst.close();

intPageCount = (intRowCount+intPageSize-1) / intPageSize;

strSQL = "select name,email,body from guestbook";

sqlRst = sqlStmt.executeQuery(strSQL);

i = (intPage-1) * intPageSize;

for(j=0;j<i;j++) sqlRst.next(); %>

<html>

<head>

<title>JSP数据\u5E93操作例程 - 数据分\u9875\u663E示 - JDBC-ODBC</title>

</head>

<body>

<p align=center>jdbc-odbc Test</p>

<table border="1" cellspacing="0" cellpadding="0" width=600 align=center>

<%

i = 0;

while(i<intPageSize && sqlRst.next()){ %>

<tr>

<td>Name:<%=sqlRst.getString(1)%></td>

<td>email:<%=sqlRst.getString(2)%></td>

</tr>

<tr>

<td colspan=2><%=sqlRst.getString(3)%></td>

</tr>

<% i++; } %>

<tr>

<td colspan=2 align=center>

Di<%=intPage%>\u9875 Total<%=intPageCount%>\u9875

<%if(intPage<intPageCount){%>

<a href="mssql.jsp?page=<%=intPage+1%>">Next\u9875</a><%

}

%>

<%if(intPage>1){%>

<a href="mssql.jsp?page=<%=intPage-1%>">Previour\u9875</a><%

}

%>

</td>

</tr>
</table> </body>
</html>
<%
sqlRst.close();

sqlStmt.close();

sqlCon.close();

%>

...全文