hai:
请按如下操作步聚即可以轻松搞定!
1.oracle-ds.xml的内容:
<?xml version="1.0" encoding="UTF-8"?> <!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.2 2003/04/01 04:51:12 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.0.16:1521:orcl</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>testuser</user-name>
<password>oracle</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource></datasources>2.将oracle-ds.xml拷到x:\jboss-3.2.1_tomcat-4.1.24\server\default\deploy目录下
3.用一个测试的jsp页面调用代码如下(假设在oracle中新建了test1表,oracle数据库服务器ip:192.168.0.16):
<%@ page contentType="text/html; charset=GBK" %>
<%@page import="java.sql.*,javax.sql.*,javax.naming.*"%>
javax.sql.DataSource ds =null;
Connection conn=null;
javax.naming.InitialContext env = new InitialContext();
ds=(javax.sql.DataSource) env.lookup("java:/OracleDS");
conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM test1");
while ( rs.next() ) {out.println( "姓名:"+rs.getString("xm") + "<br>");
out.println( "性别:"+rs.getString("xl") + "<br>");
out.println( "学历:"+rs.getString("xl") + "<br>");
out.println( "工资:"+rs.getDouble("gz") + "<br>");}
conn.close();
%>
请按如下操作步聚即可以轻松搞定!
1.oracle-ds.xml的内容:
<?xml version="1.0" encoding="UTF-8"?> <!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.2 2003/04/01 04:51:12 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.0.16:1521:orcl</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>testuser</user-name>
<password>oracle</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource></datasources>2.将oracle-ds.xml拷到x:\jboss-3.2.1_tomcat-4.1.24\server\default\deploy目录下
3.用一个测试的jsp页面调用代码如下(假设在oracle中新建了test1表,oracle数据库服务器ip:192.168.0.16):
<%@ page contentType="text/html; charset=GBK" %>
<%@page import="java.sql.*,javax.sql.*,javax.naming.*"%>
javax.sql.DataSource ds =null;
Connection conn=null;
javax.naming.InitialContext env = new InitialContext();
ds=(javax.sql.DataSource) env.lookup("java:/OracleDS");
conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM test1");
while ( rs.next() ) {out.println( "姓名:"+rs.getString("xm") + "<br>");
out.println( "性别:"+rs.getString("xl") + "<br>");
out.println( "学历:"+rs.getString("xl") + "<br>");
out.println( "工资:"+rs.getDouble("gz") + "<br>");}
conn.close();
%>
解决方案 »
- springmvc 中用redirect跳转如何传递多个参数,用?和&的方式获取不到
- [请教]DOM解析XML:getFirstChild()和getNextSibling()的疑问
- <c:foreach>后页面仍然显示的是标签代码而不是数值 在线等
- 如何删除表单中的某一项????
- cvs在服务端是如何配置的
- 请有经验的帮我看下,目前我这条件毕业能找到什么薪水的工作.
- 请问Struts里如何在View组件中将数据里的数据动态的显示出来
- 客户端图象显示
- 关于HIBERNATE自动生成代码问题!
- 在eclipse启动tomcat报错
- 想找一个树形结构的struts的多语言的留言本。。
- struts给我们带来了什么?是让我们的工作更简单了还是更复杂了?大家都来讨论
可能你对jboss配置还不是很了解!oracle-ds.xml配置文件就是oracle在jboss连接池配置!
javax.naming.InitialContext env = new InitialContext();
ds=(javax.sql.DataSource) env.lookup("java:/OracleDS");
以上代码调用就是jboss连接池调用!
大侠:
那要把oralce的驱动class12.jar拷贝到JBoss的哪个目录下嘛?
4.把oralce的驱动class12.jar拷贝到x:\jboss-3.2.1_tomcat-4.1.24\server\default\lib目录下.
5.重新启动jboss服务器run.bat