下面的程序expddl.jsp可导出当前连接数据库的用户下的所有数据表的DDL. 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" %> <% DataSource ds = null; Context ic = new InitialContext(); ds = (DataSource) ic.lookup("java:comp/env/jdbc/mydb"); Connection conn = ds.getConnection(); OracleDatabaseMetaData odmd = (OracleDatabaseMetaData) conn.getMetaData(); String us = odmd.getUserName(); String[] types = new String[1]; types[0] = "TABLE"; ResultSet rs = odmd.getTables(null,us,"%",types); while(rs.next()) { //取表名 String tname = rs.getString(3); %> 表名:<%= tname%>
<% } rs.close(); conn.close(); %> |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 05:32 , Processed in 0.167461 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.