package com.migu.springcloud.util;
import com.migu.springcloud.entities.DataBase;
import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class MysqlUtil {
public HashMap getData(DataBase database, String sql) throws SQLException, ClassNotFoundException {
HashMap<String, Object> hashMap = new HashMap<>();
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("数据库驱动加载成功");
// 获取数据库连接对象
Connection conn = DriverManager.getConnection(database.getUrl(), database.getUserName(), database.getPassWord());
System.out.println("数据库连接成功"
Java JDBC 连接数据库 根据sql语句返回表格数据
最新推荐文章于 2022-03-11 15:43:44 发布