package com.cxs.dao;

import com.cxs.model.entity.Coordinate;
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.List;

/**
 * @author cnmgb
 * @version 1.0
 * @date 2022/4/15
 **/
public class CoordinateDao {

  private QueryRunner queryRunner = new QueryRunner(DBUtils.getDs());
  public List<Coordinate> getCoordinateList() {
    try {
      return queryRunner.query("select * from bp_coordinate;",
          new BeanListHandler<Coordinate>(Coordinate.class));
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return null;
  }
}