本文共 1657 字，大约阅读时间需要 5 分钟。
- 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 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 {
-
-
- 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();
- }
- }
- }
- }
转载地址：http://mvgvo.baihongyu.com/