Java代码
- package com.iminido.util.dev;
- import com.iminido.db.Conn;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.ResultSetMetaData;
- import java.sql.SQLException;
- public class DataBaseStruct {
- // private final String DRIVER = "oracle.jdbc.driver.OracleDriver";
- // private final String URI = "jdbc:oracle:thin:@192.168.1.6:1521:orcl";
- // private final String NAME = "xcww";
- // private final String PASSWORD = "1";
- private Connection conn = null;
- private PreparedStatement pstmt = null;
- private ResultSet rs = null;
- private ResultSetMetaData rsm = null;
- public static void main(String[] args) {
- DataBaseStruct dbs = new DataBaseStruct();
- dbs.getTableStruct("t_user");
- }
- public void getTableStruct(String tableName) {
- try {
- // Class.forName(DRIVER);
- // conn = DriverManager.getConnection(URI,NAME,PASSWORD);
- conn = Conn.conn();
- pstmt = (PreparedStatement) conn.prepareStatement("select * from " + tableName);
- pstmt.execute();
- rsm = (ResultSetMetaData) pstmt.getMetaData();
- StringBuilder insert = new StringBuilder();
- insert.append("INSERT INTO " + tableName + "(");
- for (int i = 1; i < rsm.getColumnCount() + 1; i++) {
- insert.append("'").append(rsm.getColumnName(i)).append("',");
- }
- insert.append(") values (");
- for (int i = 1; i < rsm.getColumnCount() + 1; i++) {
- insert.append("'").append(rsm.getColumnName(i)).append("',");
- }
- insert.append(");");
- System.out.println(insert.toString().replace(",)", ")").toUpperCase());
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- try {
- pstmt.close();
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- }
