webservice spring与CXF结合实现 实例和jar包都有

package com.cxfdemo.server.dao; import java.lang.reflect.InvocationTargetException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.apache.commons.beanutils.BeanUtils; import com.cxfdemo.server.domain.Merchant; import com.cxfdemo.server.exception.DAOException; import com.cxfdemo.server.service.main.DBGen; import com.cxfdemo.server.service.util.DateFormatUtil; import com.cxfdemo.server.service.util.H2BDUtil; import com.cxfdemo.server.service.util.UUIDGenerator; public class MerchantDAO { private MerchantDAO(){} public static MerchantDAO dao = new MerchantDAO(); public static String sql_Create ="insert into merchant(merchant_Id,merchant_Short_Name,merchant_Full_Name,merchant_Address,merchant_zip,merchant_fax,merchant_tel,create_Time,update_Time) values(?,?,?,?,?,?,?,?,?)";; public static String sql_SelectByShortName ="select merchant_Id,merchant_Short_Name,merchant_Full_Name,merchant_Address,merchant_zip,merchant_fax,merchant_tel,create_Time,update_Time merchant from merchant where merchant_Short_Name=?"; public static String sql_SelectAll ="select merchant_Id,merchant_Short_Name,merchant_Full_Name,merchant_Address,merchant_zip,merchant_fax,merchant_tel,create_Time,update_Time merchant from merchant"; public static String sql_selectMerchantsByZip ="select merchant_Id,merchant_Short_Name,merchant_Full_Name,merchant_Address,merchant_zip,merchant_fax,merchant_tel,create_Time,update_Time merchant from merchant where merchant_zip=?"; public static String sql_selectMerchantsById ="select merchant_Id,merchant_Short_Name,merchant_Full_Name,merchant_Address,merchant_zip,merchant_fax,merchant_tel,create_Time,update_Time merchant from merchant where merchant_Id=?"; public Merchant selectById(String merchant_Id) throws DAOException{ Merchant m = null; if(merchant_Id==null){return m;} try { Connection con=H2BDUtil.getConnection(); PreparedStatement pstm = con.prepareStatement(sql_selectMerchantsById); pstm.setString(1, merchant_Id); ResultSet rs = pstm.executeQuery(); for(;rs.next();){ m= new Merchant(); m.setMerchant_Id(rs.getString("merchant_Id")); m.setMerchant_Short_Name(rs.getString("merchant_Short_Name")); m.setMerchant_Full_Name(rs.getString("merchant_Full_Name")); m.setMerchant_Address(rs.getString("merchant_Address")); m.setMerchant_zip(rs.getString("merchant_zip")); m.setMerchant_fax(rs.getString("merchant_fax")); m.setMerchant_tel(rs.getString("merchant_tel")); m.setCreate_Time(DateFormatUtil.formatDateOfDB(rs.getString("create_Time"))); m.setUpdate_Time(DateFormatUtil.formatDateOfDB(rs.getString("update_Time"))); } con.close(); } catch (SQLException e) { e.printStackTrace(); throw new DAOException("DAO Exception", e); } return m; } public List<Merchant> selectMerchantsByZip(String zip) throws DAOException{ List<Merchant> merchantList= null; if(zip == null){ return null;} try { Connection con=H2BDUtil.getConnection(); PreparedStatement pstm = con.prepareStatement(sql_selectMerchantsByZip); pstm.setString(1, zip); ResultSet rs = pstm.executeQuery(); if(rs != null){ merchantList=new ArrayList<Merchant>();} for(;rs.next();){ Merchant m= new Merchant(); m.setMerchant_Id(rs.getString("merchant_Id")); m.setMerchant_Short_Name(rs.getString("merchant_Short_Name")); m.setMerchant_Full_Name(rs.getString("merchant_Full_Name")); m.setMerchant_Address(rs.getString("merchant_Address")); m.setMerchant_zip(rs.getString("merchant_zip")); m.setMerchant_fax(rs.getString("merchant_fax")); m.setMerchant_tel(rs.getString("merchant_tel")); m.setCreate_Time(DateFormatUtil.formatDateOfDB(rs.getString("create_Time"))); m.setUpdate_Time(DateFormatUtil.formatDateOfDB(rs.getString("update_Time"))); merchantList.add(m); } con.close(); } catch (SQLException e) { e.printStackTrace(); throw new DAOException("DAO Exception", e); } return merchantList; } public Merchant selectByShortName(String shortName) throws DAOException{ Merchant m = null; if(shortName==null){return m;} try { Connection con=H2BDUtil.getConnection(); PreparedStatement pstm = con.prepareStatement(sql_SelectByShortName); pstm.setString(1, shortName); ResultSet rs = pstm.executeQuery(); for(;rs.next();){ m= new Merchant(); m.setMerchant_Id(rs.getString("merchant_Id")); m.setMerchant_Short_Name(rs.getString("merchant_Short_Name")); m.setMerchant_Full_Name(rs.getString("merchant_Full_Name")); m.setMerchant_Address(rs.getString("merchant_Address")); m.setMerchant_zip(rs.getString("merchant_zip")); m.setMerchant_fax(rs.getString("merchant_fax")); m.setMerchant_tel(rs.getString("merchant_tel")); m.setCreate_Time(DateFormatUtil.formatDateOfDB(rs.getString("create_Time"))); m.setUpdate_Time(DateFormatUtil.formatDateOfDB(rs.getString("update_Time"))); } con.close(); } catch (SQLException e) { e.printStackTrace(); throw new DAOException("DAO Exception", e); } return m; } public List<Merchant> selectAllMerchant() throws DAOException{ List<Merchant> merchantList= null; try { Connection con=H2BDUtil.getConnection(); PreparedStatement pstm = con.prepareStatement(sql_SelectAll); ResultSet rs = pstm.executeQuery(); if(rs != null){ merchantList=new ArrayList<Merchant>();} for(;rs.next();){ Merchant m= new Merchant(); m.setMerchant_Id(rs.getString("merchant_Id")); m.setMerchant_Short_Name(rs.getString("merchant_Short_Name")); m.setMerchant_Full_Name(rs.getString("merchant_Full_Name")); m.setMerchant_Address(rs.getString("merchant_Address")); m.setMerchant_zip(rs.getString("merchant_zip")); m.setMerchant_fax(rs.getString("merchant_fax")); m.setMerchant_tel(rs.getString("merchant_tel")); m.setCreate_Time(DateFormatUtil.formatDateOfDB(rs.getString("create_Time"))); m.setUpdate_Time(DateFormatUtil.formatDateOfDB(rs.getString("update_Time"))); merchantList.add(m); } con.close(); } catch (SQLException e) { e.printStackTrace(); throw new DAOException("DAO Exception", e); } return merchantList; } public Merchant createMerchant(Merchant m) throws DAOException{ boolean b = false; Merchant mm = null; try { Connection con=H2BDUtil.getConnection(); m.setMerchant_Id(UUIDGenerator.getUUID()); Date d = new Date(); m.setCreate_Time(d); m.setUpdate_Time(d); PreparedStatement pstm = con.prepareStatement(sql_Create); pstm.setString(1, m.getMerchant_Id()); pstm.setString(2, m.getMerchant_Short_Name()); pstm.setString(3, m.getMerchant_Full_Name()); pstm.setString(4, m.getMerchant_Address()); pstm.setString(5, m.getMerchant_zip()); pstm.setString(6, m.getMerchant_fax()); pstm.setString(7, m.getMerchant_tel()); pstm.setString(8, DateFormatUtil.formatDateOfDB(m.getCreate_Time())); pstm.setString(9, DateFormatUtil.formatDateOfDB(m.getUpdate_Time())); b = !pstm.execute(); if(b){ mm = new Merchant(); BeanUtils.copyProperties(mm, m); } con.close(); } catch (Exception e) { e.printStackTrace(); b=false; throw new DAOException("DAO Exception", e); } return mm; } public static void main(String[] args) thr