利用JDBC获取数据库表信息

public static void getColumns1(){
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet result = null;
		try {
			conn = DBUtil.getDBUtil().getconnection();
			ps = conn.prepareStatement("SELECT * FROM tab_xn_company");
			result = ps.executeQuery();
			ResultSetMetaData smd = result.getMetaData();
			
			int columnCount = smd.getColumnCount();
			for (int i = 1; i <= columnCount; i++) {
				String columnName = smd.getColumnName(i);
				int columnType = smd.getColumnType(i);
				String columnTypeName = smd.getColumnTypeName(i);
				System.out.println("columnName=" + columnName + ",columnType="
						+ columnType + ",columnTypeName=" + columnTypeName);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(null != result) result.close();
				if(null != ps ) ps.close();
				if(null != conn) conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void getColumns2(){
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet result = null;
		try {
			conn = DBUtil.getDBUtil().getconnection();
			DatabaseMetaData meta = conn.getMetaData();
			//dev_ydzj_1是数据库用户名，TAB_XN_COMPANY是表名
			result = meta.getColumns(null, "dev_ydzj_1".toUpperCase(), "TAB_XN_COMPANY", null);//参数必须都是大写
			while(null!=result && result.next()){
				System.out.print(result.getString("table_schem")); System.out.print(".");
				System.out.print(result.getString("table_name")); System.out.print(".");
				System.out.print(result.getString("COLUMN_NAME")); System.out.print(":");
				System.out.print("data_type="); System.out.print(result.getInt("data_type"));
				System.out.print(",type_name="); System.out.print(result.getString("type_name"));
				System.out.print(",column_size="); System.out.print(result.getInt("column_size"));	
				System.out.print(",column_def="); System.out.print(result.getString("column_def"));
				System.out.print(",is_nullable="); System.out.println(result.getString("is_nullable"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(null != result) result.close();
				if(null != ps ) ps.close();
				if(null != conn) conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static void getPrimaryKeys(){
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet result = null;
		
		try {
			conn = DBUtil.getDBUtil().getconnection();
			DatabaseMetaData meta = conn.getMetaData();
			System.out.println(meta.getDatabaseProductVersion());
			result = meta.getPrimaryKeys(null, "dev_ydzj_1".toUpperCase(), "T_USER");
			while(null!=result && result.next()){
				System.out.println(result.getString("table_schem"));
				System.out.println(result.getString("table_name"));
				System.out.println(result.getString("column_name"));
				System.out.println(result.getString("key_seq"));
				System.out.println(result.getString("pk_name"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if(null != result) result.close();
				if(null != ps ) ps.close();
				if(null != conn) conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

转载于:https://my.oschina.net/sjyroom/blog/145401