Export Oracle Data Table DDL with JSP

xiaoxiao2021-03-06  16

These days are busy organizing ISO documents, nor do you know if your own database manual is complete, and calculate it. The following program expddl.jsp exports DDL of all data tables under users of the current connection database.

EXPDDL.JSP:

<% @ Page ContentType = "Text / HTML; Charset = GB2312" Language = "Java"%> <% @ page import = "java.sql. *"%> <% @ page import = "Oracle.jdbc.OracleDatabaseMetadata" %> <% @ Page Import = "Oracle.jdbc.OracleresultsetMetadata"%> <% @ Page Import = "javax.sql. *, javax.naming.context"%> <% @ page import = "javax.naming.initialcontext "%>

Table name: <% = tname%>
Sequence No.
Identifier
Type / Accuracy
转载请注明原文地址:https://www.9cbs.com/read-41354.html

New Post(0)
CopyRight © 2020 All Rights Reserved
Processed: 0.037, SQL: 9