依赖项
<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();
}
}
}
}