cn.woodwhales.common.example.util.datasource.DataSourceToolExample Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of woodwhales-common Show documentation

https://github.com/woodwhales

There is a newer version: 3.8.3

package cn.woodwhales.common.example.util.datasource;

import cn.woodwhales.common.example.model.util.datasource.DataSourceToolTempMusic;
import cn.woodwhales.common.util.datasource.DataSourceTool;

import java.util.List;

/**
 * @author woodwhales on 2021-07-25 13:28
 * DataSourceTool 使用示例
 */
public class DataSourceToolExample {

    public static void main(String[] args) throws Exception {
        DataSourceTool dataSourceTool = DataSourceTool.newMysql("jdbc:mysql://127.0.0.1:3306/open_music?useUnicode=true&characterEncoding=utf8&autoReconnect=true&autoReconnectForPools=true&zeroDateTimeBehavior=convertToNull&useSSL=false",
                "root", "root1234");

        List musicList = dataSourceTool.queryList("select * from music", DataSourceToolTempMusic.class);
        musicList.stream().forEach(System.out::println);

        System.out.println(" ================ ");

        DataSourceToolTempMusic music = dataSourceTool.queryOne("select * from music where id = 3", DataSourceToolTempMusic.class);
        System.out.println("music = " + music);
    }

}