java druid连接SQLserver 数据库

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.alibaba.druid.pool.DruidPooledConnection;
import com.alibaba.druid.util.JdbcUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

public class HelloWorld {
    public static void main(String[] args){
        try
        {
            Properties properties=new Properties();
            InputStream resourceAsStream = JdbcUtils.class.getClassLoader().getResourceAsStream("druid.properties");
            properties.load(resourceAsStream);
            DruidDataSource druidDataSource;
            druidDataSource= (DruidDataSource) DruidDataSourceFactory.createDataSource(properties);
            
            Connection connection = druidDataSource.getConnection();
            QueryRunner queryRunner=new QueryRunner();
            try {
                Users query = queryRunner.query(connection, "SELECT * FROM Users", new BeanHandler<Users>(Users.class));
                System.out.println(query);
            } catch (Exception e) {
                e.printStackTrace();
            }

            druidDataSource.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
            System.out.print("fail!");
        }

    }
}

        <!-- 基于Apache commons-dbutils进行二次封装处理的JDBC工具类库 -->
        <dependency>
            <groupId>com.github.wywuzh</groupId>
            <artifactId>commons-dbutils</artifactId>
            <version>2.6.10.1.RELEASE</version>
        </dependency>

# druid.properties文件的配置
driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1;DatabaseName=
username=
password=
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大超时时间
maxWait=3000
validationQuery=select -1

public class Users {
    private int id;
    private String name;
    private String age;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAge() {
        return age;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public Users() {
    }

    public Users(int id, String name, String age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age='" + age + '\'' +
                '}';
    }
}