package com.cxs.dao;

import com.cxs.model.Project;
import com.cxs.utils.DBUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;

/**
 * @Description 项目查询
 * @Package com.cxs.dao
 * @ClassName LandParameterDao
 * @Data 2022-04-15 14:20
 * @Author cxs
 */
public class LandParameterDao {
    QueryRunner queryRunner = new QueryRunner(DBUtils.getDs());

    public List<Project> landParameterData(String county, String projectName, Date parse, Date parse1) throws SQLException {
        return queryRunner.query("select *from bp_project where LocationLand = ? and ProjectName = ? and CreateTime between ? and ?", new BeanListHandler<>(Project.class), county, projectName, parse, parse1);
    }
}