在ejb的会话bean(session bean)中使用数据源（DataSource）！！！

首先说下怎么在jboss中发布一个数据源

在%jboss_home%/docs/examples/jca/oracle-ds.xml找到数据源的配置模板，修改内容如下

<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>OracleDS</jndi-name> <use-java-context>false</use-java-context> <connection-url>jdbc:oracle:thin:@10.3.188.35:1522:ntdata</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>unipay</user-name> <password>unipay</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>Oracle10G</type-mapping> </metadata> </local-tx-datasource> </datasources>

其中这句话（<use-java-context>false</use-java-context>）至关重要，下面还要解释一下下。

如果你配置的数据源需要跨VM的话，那这句话一定要加上，在lookup的时候也不要在数据源名字前面加“java：”拉。

不加上这句话的话，在lookup的时候就必须在数据源名字前面加“java：”。而且数据源只能让发布到jboss内的应用调用。

这么说你明白了吗？？？

我的数据源是和代码一起打成jar包放到%jboss_home%/server/default/deploy目录下面的。

数据源发布完拉可以到http://localhost:8888/ --> JMX Console --> jboss.jca 下面查看

name=OracleDS,service=DataSourceBinding name=OracleDS,service=LocalTxCM name=OracleDS,service=ManagedConnectionFactory name=OracleDS,service=ManagedConnectionPool

 

接着开始开发客户端

数据库工具类

import java.sql.CallableStatement; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Savepoint; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; import org.apache.log4j.Logger; public class DBUtils { private static Logger logger = Logger.getLogger(DBUtils.class.getName()); public static Connection getConnection() { Connection conn = null; try { Context context = new InitialContext(); DataSource dataSource = (DataSource) context.lookup("OracleDS"); conn = dataSource.getConnection(); } catch (NamingException e) { logger.info("查找数据源失败···", e); } catch (SQLException e) { logger.info("获取数据库连接失败···", e); } return conn; } public static void close(Connection conn) { if (conn != null) { try { conn.close(); } catch (SQLException e) { logger.info("释放数据库连接失败···", e); } } } public static void close(CallableStatement cs) { if (cs != null) { try { cs.close(); } catch (SQLException e) { logger.info("关闭CallableStatement失败···", e); } } } public static void close(PreparedStatement ps) { if (ps != null) { try { ps.close(); } catch (SQLException e) { logger.info("关闭PreparedStatement失败···", e); } } } public static void close(ResultSet rs) { if (rs != null) { try { rs.close(); } catch (SQLException e) { logger.info("关闭ResultSet失败···", e); } } } public static void setAutoCommit(Connection conn, boolean autoCommit) { if (conn != null) { try { conn.setAutoCommit(autoCommit); } catch (SQLException e) { logger.info("设置事务提交方式失败···", e); } } } public static void commit(Connection conn) { if (conn != null) { try { conn.commit(); } catch (SQLException e) { logger.info("提交事务失败···", e); } } } public static void rollback(Connection conn) { if (conn != null) { try { conn.rollback(); } catch (SQLException e) { logger.info("回滚事务失败···", e); } } } public static void rollback(Connection conn, Savepoint sp) { if (conn != null) { try { conn.rollback(sp); } catch (SQLException e) { logger.info("回滚事务失败···", e); } } } }

 

接口、dto类

public interface UserInfoRemote { public UserInfo getUserInfo(); } public interface UserInfoLocal { public UserInfo getUserInfo(); } import java.io.Serializable; public class UserInfo implements Serializable { private String acctdate; private String status; private String dayoverdate; //get set 方法省略··· }

 

ejb类

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.ejb.Local; import javax.ejb.Remote; import javax.ejb.Stateless; @Stateless(name = "userInfoBean") @Remote(UserInfoRemote.class) @Local(UserInfoLocal.class) public class UserInfoBean implements UserInfoLocal, UserInfoRemote { public UserInfo getUserInfo() { String sql = "select * from t_pay_sysinfo"; UserInfo userInfo = new UserInfo(); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = DBUtils.getConnection(); ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { userInfo.setAcctdate(rs.getString("acctdate")); userInfo.setDayoverdate(rs.getString("dayoverdate")); userInfo.setStatus(rs.getString("status")); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtils.close(rs); DBUtils.close(ps); DBUtils.close(conn); } return userInfo; } }

 

ant

<?xml version="1.0" encoding="UTF-8"?> <project name="ejb" basedir="."> <property name="src.dir" value="${basedir}/src"/> <property name="bin.dir" value="${basedir}/bin"/> <property name="jboss.home" value="C:/job/jboss-5.0.0.GA"/> <target name="deploy"> <javac srcdir="${src.dir}" destdir="${bin.dir}"/> <jar jarfile="${basedir}/${ant.project.name}.jar"> <fileset dir="${bin.dir}"> <include name="**/**"/> </fileset> </jar> <copy file="${basedir}/${ant.project.name}.jar" todir="${jboss.home}/server/default/deploy"/> </target> <target name="undeploy"> <delete file="${basedir}/${ant.project.name}.jar"/> <delete file="${jboss.home}/server/default/deploy/${ant.project.name}.jar"/> </target> </project>

 

配置文件

jndi.property java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory java.naming.provider.url=jnp://127.0.0.1:1099 java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces log4j.property log4j.rootLogger=INFO,stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=[QC] %p [%t] %C.%M(%L) | %m%n

 

客户端：

 public static void main(String[] args) throws Exception { Context context = new InitialContext(); UserInfoRemote userInfoRemote = (UserInfoRemote) context .lookup("userInfoBean/remote"); UserInfo userInfo = userInfoRemote.getUserInfo(); System.out.println(userInfo.getAcctdate()); System.out.println(userInfo.getDayoverdate()); System.out.println(userInfo.getStatus()); }

 

客户端也要加jndi.property

java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory java.naming.provider.url=jnp://127.0.0.1:1099 java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces