Java连接达梦数据库示例

创建日期:2024-06-21
更新日期:2024-06-21

依赖项

<dependencies>
    <dependency>
        <groupId>com.dameng</groupId>
        <artifactId>DmJdbcDriver18</artifactId>
        <version>8.1.3.62</version>
    </dependency>
</dependencies>

代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DmTest {
    static String jdbcString = "dm.jdbc.driver.DmDriver";
    static String urlString = "jdbc:dm://192.168.23.109:5236/HYLAB_BUSINESS?schema=HYLAB_BUSINESS";
    static String userName = "SYSDBA";
    static String password = "SYSDBA";
    static Connection conn = null;
    static Statement state = null;
    static ResultSet rs = null;

    public static void main(String[] args) {
        try {
            Class.forName(jdbcString);
            conn = DriverManager.getConnection(urlString, userName, password);
            state = conn.createStatement();

            String sql = "select DATA from HYLAB_BUSINESS.TD_SCENE";
            rs = state.executeQuery(sql);
            while (rs.next()) {
                String data = rs.getString(1);
                System.out.println(data);
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                rs.close();
                state.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}