通过jdbc连接数据库

天有不测阳光

已于 2023-12-24 15:44:55 修改

阅读量418

点赞数 6

文章标签：数据库 java

于 2023-12-20 11:22:16 首次发布

本文链接：https://blog.youkuaiyun.com/Master_Yiran/article/details/135103587

版权

package org.example;

import java.sql.*;

public class Main {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

            // 加载ClickHouse的JDBC驱动程序
            Class.forName("com.clickhouse.jdbc.ClickHouseDriver");

            // 创建ClickHouse数据库连接
            String url = "jdbc:clickhouse://localhost:8123/mydatabase";
            String user = "yourusername";
            String password = "yourpassword";
            Connection connection = DriverManager.getConnection(url, user, password);

            // 创建Statement对象
            Statement statement = connection.createStatement();

            // 执行SQL查询语句
            String sql = "SELECT * FROM my_table";
            ResultSet resultSet = statement.executeQuery(sql);

            // 遍历查询结果并处理数据
            while (resultSet.next()) {
                String column1 = resultSet.getString("assy_id");
                String column2 = resultSet.getString("removed");

                // 对数据进行处理或输出
//                System.out.println("assy_id: " + column1 + ", removed: " + column2);
            }

            // 关闭ResultSet、Statement和Connection对象
            resultSet.close();
            statement.close();
            connection.close();

        }
    }

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>cktohive</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
<dependencies>
    <dependency>
        <groupId>com.clickhouse</groupId>
        <artifactId>clickhouse-jdbc</artifactId>
        <version>0.4.6</version>
    </dependency>

    <dependency>
        <groupId>net.jpountz.lz4</groupId>
        <artifactId>lz4</artifactId>
        <version>1.3.0</version>
    </dependency>
</dependencies>
</project>