如何进行添加数据库的操作

最新推荐文章于 2025-10-19 06:34:31 发布

原创最新推荐文章于 2025-10-19 06:34:31 发布 · 1.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#mysql

本文介绍了一种使用Java进行数据库连接配置的方法，并通过Utils类实现了数据库信息的实时查询功能。详细展示了Config类中数据库连接参数的配置过程及读取方式，同时提供了查询数据库的具体实现。

首先我们要有一个连接数据的文件，这个时候我们默认你们都有了，现在我们创建一个Config的类，来进行连接数据库

Config.java

public class Config {
    private static Properties properties = null;
    private static final Logger LOGGER = LoggerFactory.getLogger(Config.class);
    private static String  jdbc_driverClassName = "com.mysql.jdbc.Driver";
    private static String  jdbc_url = "jdbc\\:mysql\\://172.20.11.10\\:3306/myTest?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false";
    private static String  jdbc_username = "root";
    private static String  jdbc_password = "root";

    private static void init() throws Exception{
        properties = new Properties();
        final String zeppelinPath = System.getProperty("ZEPPELIN_CONF_DIR");
        String filepath = "";
        if(zeppelinPath == null){
            filepath = "./jdbc.properties";
        }else {
            filepath = zeppelinPath+"/jdbc.properties";
        }
        final File f = new File(filepath);
        if (f.exists()) {
            LOGGER.info("Config file path: " + filepath);
            InputStream inputStream = new FileInputStream(f);
            properties.load(inputStream);
        } else {
            LOGGER.info("Config file : " + "/jdbc.properties");
            InputStream stream = Config.class.getResourceAsStream("/jdbc.properties");
            properties.load(stream);
        }
    }

    public static String getJdbc_driverClassName() {
        final String url = getConfig("jdbc_driverClassName");
        if (url != null) {
            jdbc_driverClassName = url;
        }
        return jdbc_driverClassName;
    }

    public static String getJdbc_url() {
        final String url = getConfig("jdbc_url");
        if (url != null) {
            jdbc_url = url;
        }
        return jdbc_url;
    }

    public static String getJdbc_username() {
        final String url = getConfig("jdbc_username");
        if (url != null) {
            jdbc_username = url;
        }
        return jdbc_username;
    }

    public static String getJdbc_password() {
        final String url = getConfig("jdbc_password");
        if (url != null) {
            jdbc_password = url;
        }
        return jdbc_password;
    }



    public static String getConfig(String field){
            try {
                if(properties == null) {
                    init();
                }
                return properties.getProperty(field);
            } catch (Exception e) {
                return null;
            }
    }
}

然后后面就是数据库连接操作

这个里面我们列举一下Utils来进行查询数据库的信息

Utils.javapublic class Utils {


    private static  String driver = null;
    private static  String url = null;
    private static  String username = null;
    private static  String password = null;
    private static final long ALLOW_TIME = 10  * 1000;
    private static Date preTime = null;

    private static HashMap<String,String> setdataMap = null;
    private static ArrayList<String> setdataList = null;

    static{
        driver = Config.getConfig("jdbc_driverClassName");
        url = Config.getConfig("jdbc_url");
        username = Config.getConfig("jdbc_username");
        password = Config.getConfig("jdbc_password");
    }

    //是否逾期时间
    public static boolean isOverDueTime() {
        Date d = new Date();
        if (preTime == null || (d.getTime() - preTime.getTime()) > ALLOW_TIME || setdataList == null || setdataMap == null)
            return true;
        return false;
    }

    //进行实时查询数据库查询
    public static HashMap<String,String> finddataMap(){
        try {
            preTime = new Date();
            setdataMap = new HashMap<>();
            Class.forName(driver);
            Connection conn = (Connection) DriverManager.getConnection(url, username, password);
            String sql = "select dataset.name , value from dataset left join dataset_storage on dataset.id = dataset_storage.dataset_id and dataset_storage.item_key = 'majorPath'";
            PreparedStatement pstmt = (PreparedStatement)conn.prepareStatement(sql);
            ResultSet rs = pstmt.executeQuery();
            while (rs.next()) {
                if((rs.getString("item_value")) != null  ){
                    setdataMap.put("#" + rs.getString("ds_name"),rs.getString("item_value"));
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return setdataMap;
    }

    public static ArrayList<String> finddataList(){
        setdataList = new ArrayList<>();
        if(setdataMap != null){
            for (String s:setdataMap.keySet()){
                setdataList.add(s) ;
            }
        }
        return setdataList;
    }

}