<dependency> <groupId>com.teradata</groupId> <artifactId>teradata-jdbc</artifactId> <version>TDVersion</version> </dependency> import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TeradataJDBCExample { private static final String JDBC_URL = "jdbc:teradata://hostname/databaseName"; private static final String USERNAME = "yourUsername"; private static final String PASSWORD = "yourPassword"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.teradata.jdbc.TeraDriver"); conn = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD); stmt = conn.createStatement(); rs = stmt.executeQuery("SELECT * FROM yourTableName"); while (rs.next()) { String column1Value = rs.getString("column1"); } e.printStackTrace(); } finally { try { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } } }


上一篇:
下一篇:
切换中文