WebService netbeans glassfish

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" 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_2_0.xsd">
  <persistence-unit name="uappPU" transaction-type="JTA">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jta-data-source>jdbc/uapp</jta-data-source> <!-- 此名为glassfish数据源的jdbc名字相同-->
        <exclude-unlisted-classes>false</exclude-unlisted-classes>
        <properties>
            <property name="hibernate.hbm2ddl.auto" value="update"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.entity;

import java.io.Serializable;
import java.util.List;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;


/**
 *
 * @author song
 */
@Entity
@Table(name = "club")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "Club.findById",query = "SELECT a FROM Club a WHERE a.clubId = :id"),
    @NamedQuery(name = "Club.findByName",query = "SELECT a FROM Club a WHERE a.clubName LIKE :clubName"),
    @NamedQuery(name = "Club.delById",query = "DELETE FROM Club a where a.clubId = :id")
})
public class Club implements Serializable {
    private static final long serialVersionUID = 1L;
   
    private Integer clubId;
  
    private String clubDescription;
    
    private String clubName;
   
    private String contactName;
    
    private String contactTel;
   
    private String picUrl;

    private List<UserClub> userClubList;
    public Club() {
    }

    public Club(Integer clubId) {
        this.clubId = clubId;
    }
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "club_id")
    public Integer getClubId() {
        return clubId;
    }

    public void setClubId(Integer clubId) {
        this.clubId = clubId;
    }
    
    @Lob
    @Size(max = 2147483647)
    @Column(name = "club_description")
    public String getClubDescription() {
        return clubDescription;
    }

    public void setClubDescription(String clubDescription) {
        this.clubDescription = clubDescription;
    }
    
    @Size(max = 100)
    @Column(name = "club_name")
    public String getClubName() {
        return clubName;
    }

    public void setClubName(String clubName) {
        this.clubName = clubName;
    }
    @Size(max = 100)
    @Column(name = "contact_name")
    public String getContactName() {
        return contactName;
    }

    public void setContactName(String contactName) {
        this.contactName = contactName;
    }
    @Size(max = 20)
    @Column(name = "contact_tel")
    public String getContactTel() {
        return contactTel;
    }

    public void setContactTel(String contactTel) {
        this.contactTel = contactTel;
    }
    @Lob
    @Size(max = 2147483647)
    @Column(name = "pic_url")
    public String getPicUrl() {
        return picUrl;
    }
    
    public void setPicUrl(String picUrl) {
        this.picUrl = picUrl;
    }
    @OneToMany(fetch = FetchType.LAZY , mappedBy = "club" )
    public List<UserClub> getUserClubList() {
        return userClubList;
    }

    public void setUserClubList(List<UserClub> userClubList) {
        this.userClubList = userClubList;
    }
    
    @Override
    public int hashCode() {
        int hash = 0;
        hash += (clubId != null ? clubId.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won‘t work in the case the id fields are not set
        if (!(object instanceof Club)) {
            return false;
        }
        Club other = (Club) object;
        if ((this.clubId == null && other.clubId != null) || (this.clubId != null && !this.clubId.equals(other.clubId))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "com.haiersoft.uapp.entity.Club[ clubId=" + clubId + " ]";
    }
    
}

package com.dao;

import java.util.List;
import javax.persistence.EntityManager;

/**
 *
 * @author chenlitao
 */
public abstract class AbstractDao<T> {
    private Class<T> entityClass;

    public AbstractDao(Class<T> entityClass) {
        this.entityClass = entityClass;
    }

    protected abstract EntityManager getEntityManager();

    public void create(T entity) {
        getEntityManager().persist(entity);
    }

    public void edit(T entity) {
        getEntityManager().merge(entity);
    }

    public void remove(T entity) {
        getEntityManager().remove(getEntityManager().merge(entity));
    }

    public T find(Object id) {
        return getEntityManager().find(entityClass, id);
    }

    public List<T> findAll() {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        cq.select(cq.from(entityClass));
        return getEntityManager().createQuery(cq).getResultList();
    }

    public List<T> findRange(int[] range) {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        cq.select(cq.from(entityClass));
        javax.persistence.Query q = getEntityManager().createQuery(cq);
        q.setMaxResults(range[1] - range[0] + 1);
        q.setFirstResult(range[0]);
        return q.getResultList();
    }

    public int count() {
        javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();
        javax.persistence.criteria.Root<T> rt = cq.from(entityClass);
        cq.select(getEntityManager().getCriteriaBuilder().count(rt));
        javax.persistence.Query q = getEntityManager().createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
    
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.dao;

import com.entity.Club;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import java.util.List;
/**
 *
 * @author song
 */
@Stateless
public class ClubDao extends  AbstractDao<Club>{
    @PersistenceContext(unitName = "uappPU")
    private EntityManager em;
    
    public ClubDao(){
        super(Club.class);
    }
    @Override
    public EntityManager getEntityManager(){
        return em;
    }
    public Club findById(int id){
        Query query = getEntityManager().createNamedQuery("Club.findById", Club.class);
        query.setParameter("id", id);
        List<Club> resultList = query.getResultList();
        if(resultList == null || resultList.isEmpty()){
            return new Club(-1);
        }else{
            return resultList.get(0);
        }
    }
    public List<Club> findByName(String clubName){
        Query query = getEntityManager().createNamedQuery("Club.findByName",Club.class);
        query.setParameter("clubName","%"+ clubName +"%");
        List<Club> resultList = query.getResultList();
        if(resultList == null || resultList.isEmpty()){
            return null;
        }else{
            return resultList;
        }
    }
   
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.pojo;

import com.entity.Club;

/**
 *
 * @author song
 */
public class ClubPojo {
     private int clubId;
    private String clubName;
    private String clubDescription;
    private String picUrl;
    private String contactName;
    private String contactTel;
    public ClubPojo(){
        
    }
    public ClubPojo(Club club){
        this.clubId  = club.getClubId();
        this.clubName = club.getClubName();
        this.clubDescription = club.getClubDescription();
        this.picUrl = club.getPicUrl();
        this.contactName = club.getContactName();
        this.contactTel = club.getContactTel();
    }
    public int getClubId() {
        return clubId;
    }

    public void setClubId(int clubId) {
        this.clubId = clubId;
    }

    public String getClubName() {
        return clubName;
    }

    public void setClubName(String clubName) {
        this.clubName = clubName;
    }

    public String getClubDescription() {
        return clubDescription;
    }

    public void setClubDescription(String clubDescription) {
        this.clubDescription = clubDescription;
    }

    public String getPicUrl() {
        return picUrl;
    }

    public void setPicUrl(String picUrl) {
        this.picUrl = picUrl;
    }

    public String getContactName() {
        return contactName;
    }

    public void setContactName(String contactName) {
        this.contactName = contactName;
    }

    public String getContactTel() {
        return contactTel;
    }

    public void setContactTel(String contactTel) {
        this.contactTel = contactTel;
    }
    
    
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.pojo;

import com.entity.Club;

/**
 *
 * @author song
 */
public class ClubResult {
    private String state;
    private ClubPojo club;
    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public ClubPojo getClub() {
        return club;
    }

    public void setClub(ClubPojo club) {
        this.club = club;
    }
    
}

package com.pojo;

/**
 *
 * @author chenlitao
 */
public class Result {

    private String state;

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

}

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.pojo;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

/**
 *
 * @author yjd
 */
public class ResultSet<T> implements Serializable {

    /**
     * 状态码
     */
    private String state;
    /**
     * 泛型集合
     */
    private List<T> result = new ArrayList<T>();

    /**
     * 总页数
     */
    private int totalPage = 0;
    /**
     * 总条数
     */
    private int totalCount = 0;

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public List<T> getResult() {
        return result;
    }

    public void setResult(List<T> result) {
        this.result = result;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.service;

import com.dao.ClubDao;
import com.dao.UserClubDao;
import com.entity.Club;
import com.entity.UserClub;
import javax.ejb.LocalBean;
import javax.ejb.Stateless;
import java.util.ArrayList;
import javax.ejb.EJB;
import java.util.List;
/**
 *
 * @author song
 */
@Stateless
@LocalBean
public class ClubService {
    @EJB 
    private ClubDao clubDao;
    @EJB
    private UserClubDao userClubDao;
  

    public ClubService() {
    }
    
    public Club findById(int clubId){
        return clubDao.findById(clubId);
    }
    
    public List<Club> findByClubName(String clubName){
        List<Club> list = clubDao.findByName(clubName);
        if(list == null || list.isEmpty()){
            return new ArrayList<Club>();
        }else{
            return list;
        }
    }
    public  void addClub(Club club){
        clubDao.create(club);
    }
    
    public void edit(Club club){
        clubDao.edit(club);
    }
    public List<Club> findAll(){
        return clubDao.findAll();
    }
    
     public List<UserClub> findByClubId(int clubId){
        return userClubDao.findByClubId(clubId);
    }
    
    public List<UserClub> findByUserName(String userName){
        return userClubDao.findByUserName(userName);
    }
    
    public boolean delByClubIdAndUserName(int clubId,String userName){
        return userClubDao.delByClubIdAndUserName(clubId, userName);
    }
    public void joinClub(UserClub userClub){
        userClubDao.create(userClub);
    }
    public UserClub findByClubIdAndUserName(int clubId,String userName){
        return userClubDao.findByClubIdAndUserName(clubId, userName);
    }
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.facade;

import com.entity.Club;
import com.entity.UserClub;
import com.pojo.ClubPojo;
import com.pojo.ClubResult;
import com.pojo.Result;
import com.pojo.ResultSet;
import com.pojo.UserClubPojo;
import com.pojo.UserClubResult;
import com.service.ClubService;
import java.util.ArrayList;
import java.util.Date;
import javax.ejb.EJB;
import javax.ejb.Stateless;
import javax.jws.WebMethod;
import javax.jws.WebResult;
import javax.jws.WebService;
import javax.jws.soap.SOAPBinding;

import javax.jws.WebParam;
import java.util.List;
/**
 *
 * @author song
 */
@Stateless
@WebService(serviceName = "club",name = "ClubFacade",targetNamespace =  "http://com.haiersoft.uapp.ws.facade.ClubFacade")
@SOAPBinding(style = SOAPBinding.Style.RPC,use = SOAPBinding.Use.LITERAL, parameterStyle = SOAPBinding.ParameterStyle.WRAPPED)
public class ClubFacade {
    @EJB
    private ClubService clubService;
    
    /**
     * 根据俱乐部Id查询
     * @param id
     * @return 
     */
    @WebMethod(action = "findByClub0",operationName = "findByClubId")
    @WebResult(name = "result")
    public ClubResult findByClubId(@WebParam(name = "clubId") int clubId){
           ClubResult resultClub = new ClubResult();
           try{
               Club club = clubService.findById(clubId);
               if(club.getClubId() != -1){
                      resultClub.setState("200");
                      resultClub.setClub(new ClubPojo(club));
                }else{
                   resultClub.setState("none");
               }
               return resultClub;
           }catch(Exception e){
               resultClub.setState("900");
               return resultClub;
           }
    }
    
    /**
     * 创建俱乐部信息
     * @param clubPojo
     * @return 
     */
    @WebMethod(action = "createClub",operationName = "createClub")
    @WebResult(name = "result")
    public Result createClub(@WebParam(name="clubPojo") ClubPojo clubPojo){
         Club club = proverClub(clubPojo);
         Result result = new Result();
        
           try{
               clubService.addClub(club);
               result.setState("200");
               return result;
           }catch(Exception e){
               System.out.println(e.toString());
               result.setState("900");
               return result;
           }
    }
    
    /**
     * 根据俱乐部名称查询俱乐部
     * @param clubName
     * @return 
     */
    @WebMethod(action = "findByClubName",operationName = "findByClubName")
    @WebResult(name = "result")
    public ResultSet findByClubName(@WebParam(name="clubName") String clubName){
        ResultSet<ClubPojo> clubResultSet = new ResultSet<ClubPojo>();
        try{
            List<Club> listClub = clubService.findByClubName(clubName);
            if(listClub.size() <= 1){
                  clubResultSet.setState("200");
            }else{
                clubResultSet.setState("201");
            }
            List<ClubPojo> listClubPojos = new ArrayList<ClubPojo>();
            for(Club club:listClub){
                listClubPojos.add(new ClubPojo(club));
            }
          clubResultSet.setResult(listClubPojos);
          clubResultSet.setTotalCount(listClub.size());
        }catch(Exception e){
            clubResultSet.setState("error");
        }
        return clubResultSet;
    }
    /**
     * 编辑俱乐部信息
     * @param clubPojo
     * @return 
     */
    @WebMethod(action = "editClub",operationName = "editClub")
    @WebResult(name = "result")
    public Result editClub(@WebParam(name="clubPojo") ClubPojo clubPojo){
         Club club = proverClub(clubPojo);
         club.setClubId(clubPojo.getClubId());
         Result result = new Result();
        
           try{
               clubService.edit(club);
               result.setState("200");
               return result;
           }catch(Exception e){
               System.out.println(e.toString());
               result.setState("900");
               return result;
           }
    }
    
    /**
     * 查询所有的俱乐部信息
     * @return 
     */
    @WebMethod(action = "findAllClub",operationName = "findAllClub")
    @WebResult(name="result")
    public ResultSet findAllClub(){
        ResultSet<ClubPojo> result = new ResultSet<ClubPojo>();
        List<Club> clubList = clubService.findAll();
        if(clubList.size() <= 1){
            result.setState("200");
        }else{
            result.setState("201");
        }
         List<ClubPojo> listClubPojos = new ArrayList<ClubPojo>();
         for(Club club:clubList){
               listClubPojos.add(new ClubPojo(club));
         }
        result.setResult(listClubPojos);
        return result;
    }
    /**
     * 将俱乐部pojo类转化为实体类
     * @param clubPojo
     * @return 
     */
    private Club proverClub(ClubPojo clubPojo){
        if(clubPojo == null ){
            return null;
        }
        Club club = new Club();
        club.setClubName(clubPojo.getClubName());
        club.setClubDescription(clubPojo.getClubDescription());
        club.setContactName(clubPojo.getContactName());
        club.setContactTel(clubPojo.getContactTel());
        club.setPicUrl(clubPojo.getPicUrl());
        return club;
    }
    
   
    /**
     * 加入俱乐部
     * @param clubId
     * @param userId
     * @param userName
     * @param mobilePhone
     * @return 
     */
    @WebMethod(action = "joinClub",operationName = "joinClub")
    @WebResult(name="result")
    public Result joinClub(@WebParam(name = "clubId") int clubId,@WebParam(name = "userId")String userId,@WebParam(name = "userName")String userName ,@WebParam(name = "mobilePhone")String mobilePhone){
        Result result = new Result();
      
        UserClub userClub = new UserClub();
        
        userClub.setClub(new Club(clubId));
        userClub.setUserId(userId);
        userClub.setUserName(userName);
        userClub.setMobilePhone(mobilePhone);
        Date time = new Date();
        userClub.setJoinTime( time);
        try{
            clubService.joinClub(userClub);
            result.setState("200");
        }catch(Exception e){
            result.setState("error");
            System.out.println(e);
        }
        return result;
    }
    /**
     * 根据俱乐部Id查询俱乐部的报名人数
     * @param clubId
     * @return 
     */
    @WebMethod(action = "findUserByClubId",operationName = "findUserByClubId")
    @WebResult(name = "result")
    public ResultSet findUserByClubId(@WebParam(name  ="clubId") int clubId){
        ResultSet<UserClubPojo> result = new  ResultSet<UserClubPojo>();
        try{
            List<UserClub> userClubList = clubService.findByClubId(clubId);
            if(userClubList.size() <= 1){
                result.setState("200");
            }else{
                result.setState("201");
            }
            List<UserClubPojo> listClubPojos = new ArrayList<UserClubPojo>();
            for(UserClub userClub:userClubList){
               listClubPojos.add(new UserClubPojo(userClub));
            }
            result.setResult(listClubPojos);
            result.setTotalCount(userClubList.size());
        }catch(Exception e){
            result.setState("error");
        }
        return result;
    }
    /**
     * 根据用户名查询报名俱乐部
     * @param userName
     * @return 
     */
    @WebMethod(action = "findByUserName",operationName = "findByUserName")
    @WebResult(name = "result")
    public ResultSet findByUserName(@WebParam(name="userName")String userName){
        ResultSet<UserClubPojo> result = new  ResultSet<UserClubPojo>();
        try{
           List<UserClub> userClubList = clubService.findByUserName(userName);
            if(userClubList.size() <= 1){
                result.setState("200");
            }else{
                result.setState("201");
            }
            List<UserClubPojo> listClubPojos = new ArrayList<UserClubPojo>();
            for(UserClub userClub:userClubList){
               listClubPojos.add(new UserClubPojo(userClub));
            }
          result.setResult(listClubPojos);
          result.setTotalCount(userClubList.size());
        }catch(Exception e){
            result.setState("error");
        }
        return result;
    }
    /**
     * 根据俱乐部Id和用户名查询是否有报名信息
     * @param clubId
     * @param userName
     * @return 
     */
    @WebMethod(action = "findByClubIdAndUserName",operationName = "findByClubIdAndUserName")
    @WebResult(name = "result")
    public UserClubResult findByClubIdAndUserName(@WebParam(name = "clubId")int clubId,@WebParam(name = "userName")String userName){
        UserClubResult result = new  UserClubResult();
        try{
             UserClub userClub = clubService.findByClubIdAndUserName(clubId, userName);
             if(userClub != null){
                result.setState("200");
                result.setUserClub(new UserClubPojo(userClub));
             }else{
                 result.setState("none");
             }
          
        }catch(Exception e){
            result.setState("error");
        }
        return result;
    }
    /**
     * 根据Id和用户名删除报名信息
     * @param clubId
     * @param userName
     * @return 
     */
    @WebMethod(action = "delByClubIdAndUserName",operationName = "delByClubIdAndUserName")
    @WebResult(name = "result")
    public Result delByClubIdAndUserName(@WebParam(name = "clubId")int clubId,@WebParam(name = "userName")String userName){
        Result result = new Result();
        try{
            boolean flag = clubService.delByClubIdAndUserName(clubId, userName);
            if(flag){
                result.setState("200");
            }else{
                result.setState("none");
            }
        }catch(Exception e){
            result.setState("error");
        }
        return result;
    }
}