package com.liang.fastservice.test;
import cn.hutool.db.Db;
import cn.hutool.db.Entity;
import cn.hutool.db.ds.simple.SimpleDataSource;
import javax.sql.DataSource;
import java.sql.SQLException;
import java.util.*;
public class Test19 {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
DataSource ds = new SimpleDataSource("jdbc:mysql://127.0.0.1:3306/pet?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8", "user", "password");
List<Entity> user = Db.use(ds).findAll("sys_user");
for (Entity entity : user) {
String id = entity.getStr("user_id");
System.out.println(id);
}
}
}