jdbc实现连接数据库并查询该数据库下表名

来源：互联网发布：python socket 连接编辑：程序博客网时间：2024/05/21 17:55

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

0 0