package com.lr.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
/**
* Users generated by hbm2java
*/
@Entity
@Table(name = "users", catalog = "ejb3", uniqueConstraints = {})
public class Users implements java.io.Serializable {
// Fields
private int id;
private String name;
private String pass;
// Constructors
/** default constructor */
public Users() {
}
/** minimal constructor */
public Users(int id) {
this.id = id;
}
/** full constructor */
public Users(int id, String name, String pass) {
this.id = id;
this.name = name;
this.pass = pass;
}
// Property accessors
@Id
@Column(name = "id", unique = true, nullable = false, insertable = true, updatable = true)
public int getId() {
return this.id;
}
public void setId(int id) {
this.id = id;
}
@Column(name = "name", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
@Column(name = "pass", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
public String getPass() {
return this.pass;
}
public void setPass(String pass) {
this.pass = pass;
}
}
package com.lr.entity;
// Generated 2006-8-28 16:22:58 by Hibernate Tools 3.1.0.beta5
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
/**
* Home object for domain model class Users.
* @see com.lr.entity.Users
* @author Hibernate Tools
*/
@Stateless
public class UsersHome {
private static final Log log = LogFactory.getLog(UsersHome.class);
@PersistenceContext
private EntityManager entityManager;
public void persist(Users transientInstance) {
log.debug("persisting Users instance");
try {
entityManager.persist(transientInstance);
log.debug("persist successful");
} catch (RuntimeException re) {
log.error("persist failed", re);
throw re;
}
}
public void remove(Users persistentInstance) {
log.debug("removing Users instance");
try {
entityManager.remove(persistentInstance);
log.debug("remove successful");
} catch (RuntimeException re) {
log.error("remove failed", re);
throw re;
}
}
public Users merge(Users detachedInstance) {
log.debug("merging Users instance");
try {
Users result = entityManager.merge(detachedInstance);
log.debug("merge successful");
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
throw re;
}
}
public Users findById(int id) {
log.debug("getting Users instance with id: " + id);
try {
Users instance = entityManager.find(Users.class, id);
log.debug("get successful");
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}
}
package com.lr.stateless;
import javax.ejb.Remote;
import javax.ejb.Stateless;
import com.lr.UsersDAO;
import com.lr.entity.Users;
import javax.persistence.*;
import java.util.*;
@Stateless
@Remote({UsersDAO.class})
public class UsersDAOBean implements com.lr.UsersDAO {
@PersistenceContext
public EntityManager em;
public String Find(String id){
//通过主键查找
Users user=em.find(Users.class,Integer.valueOf(id));
return user.getPass()+user.getName();
}
public void ShowUser(){
//显示所有信息
String ejb3ql="select u from users";
Query query=em.createQuery(ejb3ql);
List result=query.getResultList();
Iterator iterator=result.iterator();
if(result!=null){
while(iterator.hasNext()){
Users user=(Users)iterator.next();
user.getId();
user.getPass();
user.getName();
}
}
}
public boolean DelUser(String id){
//删除
try{
Users user=em.find(Users.class,Integer.valueOf(id));
em.remove(user);
}catch(Exception e){
e.printStackTrace();
return false;
}
return true;
}
public boolean insertUser(String name,String pass){
//插入
try{
Users user=new Users();
user.setName(name);
user.setPass(pass);
em.persist(user);
}catch(Exception e){
e.printStackTrace();
return false;
}
return true;
}
public boolean ChangeUser(String name,String pass){
//修改
try{
String ejb3ql="update Users as u set u.name='"+name+"',user.pass='"+pass+"'";
Query query=em.createQuery(ejb3ql);
query.executeUpdate();
}catch(Exception e){
e.printStackTrace();
return false;
}
return true;
}
}
package com.lr;
public interface UsersDAO{
public String Find(String name);
public void ShowUser();
public boolean DelUser(String id);
public boolean insertUser(String name,String pass);
public boolean ChangeUser(String name,String pass);
}
<persistence>
<persistence-unit name="Users">
<jta-data-source>java:/mysql1</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
</properties>
</persistence-unit>
</persistence>
<?xml version="1.0" encoding="UTF-8" ?>
<datasources>
<local-tx-datasource>
<jndi-name>mysql1</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/ejb3</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
<password>123456</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>