jdbc template操作sqlserver

1、安装sqlserver数据库，并在创建database ERP和表student

数据库帐号sa  密码:1234Qwer

2、引入sqlserver的驱动

<dependency>
   <groupId>com.microsoft.sqlserver</groupId>
   <artifactId>mssql-jdbc</artifactId>
   <version>8.2.1.jre8</version>
</dependency>

3、代码结果如下

 

package com.hl.dataplatform.sqlserver;


import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

/**
 * @program: datahub
 * @description: 连接测试
 * @author: forist.li
 * @create: 2021-05-10 16:36
 **/
public class ConnectTest {
    public static void main(String[] args) {
        JdbcTemplate template=createJdbcTemplate();

        String count=template.queryForObject("SELECT COUNT(id) FROM student",String.class);
        System.out.println("查询数据条数"+count);

       List<Map<String, Object>> datas= template.queryForList("select *from student");
       datas.forEach(data->{
           System.out.println("数据为:"+data);
       });

    }

    private static JdbcTemplate createJdbcTemplate() {

        String username="sa";
        String password="1234Qwer";
        String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ERP";
        String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";

        return new JdbcTemplate(DataSourceBuilder.create().driverClassName(driver).
                username(username).
                password(password).url(url).build());
    }



}