DPersonBatchDao.java

package com.viontech.keliu.dao;

import com.viontech.keliu.entity.DPersonBatch;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import javax.annotation.Resource;
import java.util.Date;
import java.util.List;

/**
 * Created with IntelliJ IDEA.
 *
 * @author: zhuhai
 * Date: 2024-05-30
 * Time: 18:04
 */
@Repository
public class DPersonBatchDao {

    @Resource
    private JdbcTemplate jdbcTemplate;


    public List<DPersonBatch> getPersonBatchList(Long mallId, Date countDate) {
        String sql = "select * from d_person_batch where mall_id = ? and count_date = ?";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(DPersonBatch.class), mallId, countDate);
    }


}