jdbc实现连接数据库并查询该数据库下表名
package com.git.rdp.utils; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class JdbcUtils { public static void main(String[] args) { Connection conn = null; String className = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@192.168.1.150:1521:orcl"; String user = "devplat"; String password = "devplat"; String sql = "select table_name from user_tables"; try { Class.forName(className); conn = DriverManager.getConnection(url,user,password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); List<String> list = new ArrayList<String>(); while(rs.next()){ System.out.println(rs.getString("TABLE_NAME")); String tblName = rs.getString("TABLE_NAME"); list.add(tblName); } System.out.println(list); } catch (Exception e) { e.printStackTrace(); } } }
声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。