net.shopxx.dao.impl.PaymentLogDaoImpl.java Source code

Introduction

Here is the source code for net.shopxx.dao.impl.PaymentLogDaoImpl.java

Source

/*
 * Copyright 2005-2015 shopxx.net. All rights reserved.
 * Support: http://3936242.01p.com/
 * License: http://3936242.01p.com/license
 */
package net.shopxx.dao.impl;

import javax.persistence.NoResultException;

import net.shopxx.dao.PaymentLogDao;
import net.shopxx.entity.PaymentLog;

import org.apache.commons.lang.StringUtils;
import org.springframework.stereotype.Repository;

@Repository("paymentLogDaoImpl")
public class PaymentLogDaoImpl extends BaseDaoImpl<PaymentLog, Long> implements PaymentLogDao {

    public PaymentLog findBySn(String sn) {
        if (StringUtils.isEmpty(sn)) {
            return null;
        }
        String jpql = "select paymentLog from PaymentLog paymentLog where lower(paymentLog.sn) = lower(:sn)";
        try {
            return entityManager.createQuery(jpql, PaymentLog.class).setParameter("sn", sn).getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

}