JDBC连接数据库_并获取当前用户创建的所有表

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class GetConn {
	private Connection conn;
	private PreparedStatement pstmt;
	
	public List<String> queryTable() {
        String sql = "select table_name from user_tables";
        List<String> list = new ArrayList<String>();
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@192.168.1.96:1521:yxdb", "yxmanager",
                    "yxmanager");
            pstmt = conn.prepareStatement(sql);
            ResultSet rs = pstmt.executeQuery();
            while (rs.next()) {
                list.add(rs.getString("table_name"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
}