JdbcTemplate 查询sqlServer

1：首先定义JdbcTemplate

    @Inject
    private JdbcTemplate yfssLesJdbcTemplate;

2：定义sql

    private String findLineWorkOrderStatisticsForStatusSql = "SELECT Work_Order as order_no,\n" +
            "       STATUS     as order_status,\n" +
            "       count(*)   as sum_count\n" +
            "FROM [YFSS_Line_MES01].[dbo].[Unit_Status]\n" +
            "where Work_Order = ";

3：执行语句

        List<LineWorkOrderStatistics> lineWorkOrderStatistics = yfssLineMesJdbcTemplate.query(findLineWorkOrderRecordSql, new LineWorkOrderStatisticsRowMapper());

其中，findLineWorkOrderRecordSql 是sql语句，new LineWorkOrderStatisticsRowMapper() 是一个返回值为实体类的对象，该类的代码具体为

package com.yanfeng.cloud.pmes.womgmt.data.external;

import com.yanfeng.cloud