linux链接达梦数据库

[DM]
Description = Dameng Database
Driver = /path/to/dmjdbc/dmjdbc8.jar
Server = your_server_ip
Port = your_port
Database = your_database_name
User = your_username
Password = your_password

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

public class DMConnectionTest {
    public static void main(String[] args) {
        String url = "jdbc:dm://your_server_ip:your_port/your_database_name";
        String user = "your_username";
        String password = "your_password";

        try {
            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println("Connected to DM Database!");
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

import pyodbc

conn = pyodbc.connect('DSN=DM;UID=your_username;PWD=your_password')
cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")
rows = cursor.fetchall()
for row in rows:
    print(row)
conn.close()