Cool
Cool
Published on 2022-05-31 / 49 Visits
2
0

Java5行代码从数据库拿到数据

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);
        }
    }

}


Comment