The datasource is an attribute in application scope. You can use the
pageContext to get this attribute.
You may be able to do something with a <bean:XXXX.> tag or a
<jsp:useBean /> tag to expose this attribute... but I could not figure
it out.
by the way.... you aren't going to put a business rule in a jsp page????
are you ???? :-)
I try to keep all my sql in a bean then call methods to enforce business
rules or pull data to be displayed in a page.
Scriptlets bad, taglibs good :-)
my $.02
-Mark
<%@ page import="javax.sql.DataSource,
org.apache.struts.action.Action,
java.sql.Connection,
java.sql.Statement,
java.sql.ResultSet" %>
<%
DataSource dataSource = (DataSource)
pageContext.getAttribute(Action.DATA_SOURCE_KEY,
PageContext.APPLICATION_SCOPE);
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select bill_grp_code,
bill_grp_dsc from bill_grp");
/* DO SOMETHING WITH THE DATA */
resultSet.close();
statement.close();
connection.close();
%>
<html>
<body>
testing
</body>
</html>
Barry Jia wrote:
>Hi, All
>I read the struts document, I config my data source in struts-config.xml,
>In my action I can use the following code to get Data source and use it.
>Right now I want to use it in my JSP scriplet, when I use it, it can not be
>compiled as servlet is a undefined variable or class.
>I want to know, in my Action, servlet is in which package ? how to use same
>code in *.jsp file
>Thanks!
>
> DataSource dataSource = (DataSource)
> servlet.getServletContext().getAttribute(Action.DATA_SOURCE_KEY);
> conn = dataSource.getConnection();
> ... perform required functions as in the previous example ...
> conn.close();
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
