操作jdbc的api

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.rowset.SqlRowSet;
import org.springframework.jdbc.support.rowset.SqlRowSetMetaData;
import org.springframework.stereotype.Component;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

 /**
  * @Author ljm
  * @Description jdbc api
  * @Date  2023/2/10 15:53
  * @return
  */
@Component
public class JdbcSql {

    @Autowired
    private JdbcTemplate jdbcTemplate;


     /**
      * @Author ljm
      * @Description 查询单个记录
      * @Date  2023/2/10 15:54
      * @return
      */
    public Map<String, Object> getByDataBase(String sql){
        Map<String, Object> map = jdbcTemplate.queryForMap(sql);
        return map;
    }

     /**
      * @Author ljm
      * @Description 返回多条记录
      * @Date  2023/2/10 16:07
      * @return
      */
    public List<Map<String, Object>> getByDataBaseList(String sql){
        List<Map<String, Object>> data = new ArrayList<>();
        SqlRowSet sqlRowSet = jdbcTemplate.queryForRowSet(sql);

        //返回结果集
        SqlRowSetMetaData metaData = sqlRowSet.getMetaData();
        while (sqlRowSet.next()) {
            Map<String, Object> map = new HashMap<>(1);
            //获取列名
            String columnName = metaData.getColumnName(1);
            //获取列的值
            Object values = sqlRowSet.getObject(1);
            map.put(columnName, values);
            data.add(map);
        }
        return data;
    }
}