先上配置文件
存放目录:META-INF/persistence.xml
<?xml version="1.0"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0" >
<persistence-unit name="xkEntity" transaction-type="JTA">
<jta-data-source>MySqlDS</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.jdbc.fetch_size" value="18" />
<property name="hibernate.jdbc.batch_size" value="10" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.format_sql" value="true" />
</properties>
</persistence-unit>
</persistence>
建立EJBProject
package com.entity;
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="user_info")
public class User implements Serializable{
@Id
@Column(name="user_id")
private String id;
@Column(name="user_name",length=30)
private String name;
public User() {
}
public String getId() {
return this.id;
}
public void setId(String id) {
this.id = id;
}
public int hashCode() {
return (this.id == null) ? 0 : this.id.hashCode();
}
public boolean equals(Object object) {
if (object instanceof User) {
final User obj = (User) object;
return (this.id != null) ? this.id.equals(obj.id)
: (obj.id == null);
}
return false;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
}
package com;
import javax.ejb.Remote;
import com.entity.User;
@Remote
public interface UtilEntityDAORemote<T> {
public User getEntity(String id);
}
package com;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import com.entity.User;
@Stateless
public class UtilEntityDAO<T> implements UtilEntityDAORemote {
@PersistenceContext(name="xkEntity")
EntityManager em;
public User getEntity(String id) {
// TODO Auto-generated method stub
Query query= em.createQuery("from User us where us.id=:id");
query.setParameter("id", id);
return (User) query.getSingleResult();
}
}
发布到jboss/server/all/deploy下面
测试
package com;
import java.util.Properties;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import com.entity.User;
public class test {
public static void main(String[] args){
Properties prop=new Properties();
prop.setProperty("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory");
prop.setProperty("java.naming.provider.url", "localhost:1100");
prop.setProperty("java.naming.factory.url.pkgs", "org.jboss.naming");
InitialContext ctx;
try {
ctx=new InitialContext(prop);
UtilEntityDAORemote util=(UtilEntityDAORemote) ctx.lookup("UtilEntityDAO/remote");
User u= util.getEntity("1");
System.out.println(u.getName());
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
ok结束
下面说点问题 这个例子是在jboss6.0final下完成的。所以相关的jar包一定要用jboss6的。不然会报错。
贴上datasource配置
<?xml version="1.0" encoding="UTF-8"?>
<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->
<!-- $Id: mysql-ds.xml 97536 2009-12-08 14:05:07Z jesper.pedersen $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:mysql://127.0.0.1:3306/test</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<min-pool-size>30</min-pool-size>
<max-pool-size>50</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
-->
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers-->
<check-valid-connection-sql>select * from user_info</check-valid-connection-sql>
<security-domain>MysqlDSRealm</security-domain>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
当前配置文件中没有写用户名密码而是用 <security-domain>MysqlDSRealm</security-domain>来验证。配置路径server/all/conf/login-config.xml
<application-policy name="MysqlDSRealm">
<authentication>
<login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag="required">
<module-option name="principal">root</module-option>
<module-option name="userName">root</module-option>
<module-option name="password">root</module-option>
<module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>
</authentication>
</application-policy>
ok完毕