#===================================================================

# pom.xml中添加引用

#       <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

#       <dependency>

#           <groupId>mysql</groupId>

#           <artifactId>mysql-connector-java</artifactId>

#           <version>8.0.17</version>

#       </dependency>

#

#        <!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc -->

#        <dependency>

#            <groupId>com.microsoft.sqlserver</groupId>

#            <artifactId>mssql-jdbc</artifactId>

#            <version>7.4.0.jre12</version>

#            <scope>test</scope>

#        </dependency>

# 数据库配置文件样例

# \src\main\resources目录下创建config/db.setting

# DsFactory默认读取的配置文件是config/db.setting

# db.setting的配置包括两部分：基本连接信息和连接池配置信息。

# 基本连接信息所有连接池都支持，连接池配置信息根据不同的连接池，连接池配置是根据连接池相应的配置项移植而来

#===================================================================

## db.setting文件

#mysql

#url = jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false

#driver =com.mysql.cj.jdbc.Driver

#sqlserver

url = jdbc:sqlserver://111.230.23.148:1433; DatabaseName=SampleDB

driver =com.microsoft.sqlserver.jdbc.SQLServerDriver

user = sa

pass = Smile2017AbC_168_bCd8690

## 可选配置

# 是否在日志中显示执行的SQL

showSql = true

# 是否格式化显示的SQL

formatSql = false

# 是否显示SQL参数

showParams = true

package com.database.demo;

import cn.hutool.db.Db;

import cn.hutool.db.Entity;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import java.sql.SQLException;

import java.util.List;

@RunWith(SpringRunner.class)

@SpringBootTest

public class DemoApplicationTests {

    @Test

    public void contextLoads() {

    }

    @Test

    public void Test1() throws SQLException {

        //product为表名

        // List<Entity> list = Db.use().findAll("product");

        // for (Entity entity : list) {

        //     System.out.println(entity.toString());

        // }

        // 直接sql语句操作  insert/update/delete

        // Integer i = Db.use().execute("insert into product(username,password,realname) values(?,?,?)", "zhangxiao", "1234568", "张晓");

        // if (i > 0) {

        //     System.out.println("数据插入成功");

        // } else {

        //     System.out.println("数据插入失败");

        // }

        Entity entity = Entity.create("product");

        List<Entity> list = Db.use().page(entity, 2, 10);

        for (Entity entity1 : list) {

            //System.out.println(entity1.toString());

            System.out.printf("用户ID: %s 用户名：%s 真实姓名：%s", entity1.get("id"), entity1.get("username"), entity1.get("realname"));

            System.out.println();

        }

    }

}