Javaè·åæ°æ®åºç表ä¸åå段çå段åï¼ä»£ç å¦ä¸ï¼
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
public class TestDemo {
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://æ°æ®åºIPå°å:3306/æ°æ®åºå称";
String user = "æ°æ®åºç¨æ·å";
String pass = "æ°æ®åºç¨æ·å¯ç ";
conn = DriverManager.getConnection(url, user, pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main(String[] args) {
Connection conn = getConnection();
String sql = "select * from AccessType";
PreparedStatement stmt;
try {
stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData data = rs.getMetaData();
for (int i = 1; i <= data.getColumnCount(); i++) {
// è·å¾ææåçæ°ç®åå®é
åæ°
int columnCount = data.getColumnCount();
// è·å¾æå®åçåå
String columnName = data.getColumnName(i);
// è·å¾æå®åçåå¼
int columnType = data.getColumnType(i);
// è·å¾æå®åçæ°æ®ç±»åå
String columnTypeName = data.getColumnTypeName(i);
// æå¨çCatalogåå
String catalogName = data.getCatalogName(i);
// 对åºæ°æ®ç±»åçç±»
String columnClassName = data.getColumnClassName(i);
// å¨æ°æ®åºä¸ç±»åçæ大å符个æ°
int columnDisplaySize = data.getColumnDisplaySize(i);
// é»è®¤çåçæ é¢
String columnLabel = data.getColumnLabel(i);
// è·å¾åç模å¼
String schemaName = data.getSchemaName(i);
// æåç±»åç精确度(ç±»åçé¿åº¦)
int precision = data.getPrecision(i);
// å°æ°ç¹åçä½æ°
int scale = data.getScale(i);
// è·åæå对åºç表å
String tableName = data.getTableName(i);
// æ¯å¦èªå¨éå¢
boolean isAutoInctement = data.isAutoIncrement(i);
// å¨æ°æ®åºä¸æ¯å¦ä¸ºè´§å¸å
boolean isCurrency = data.isCurrency(i);
// æ¯å¦ä¸ºç©º
int isNullable = data.isNullable(i);
// æ¯å¦ä¸ºåªè¯»
boolean isReadOnly = data.isReadOnly(i);
// è½å¦åºç°å¨whereä¸
boolean isSearchable = data.isSearchable(i);
System.out.println(columnCount);
System.out.println("è·å¾å" + i + "çå段å称:" + columnName);
System.out.println("è·å¾å" + i + "çç±»å,è¿åSqlTypeä¸çç¼å·:"+ columnType);
System.out.println("è·å¾å" + i + "çæ°æ®ç±»åå:" + columnTypeName);
System.out.println("è·å¾å" + i + "æå¨çCatalogåå:"+ catalogName);
System.out.println("è·å¾å" + i + "对åºæ°æ®ç±»åçç±»:"+ columnClassName);
System.out.println("è·å¾å" + i + "å¨æ°æ®åºä¸ç±»åçæ大å符个æ°:"+ columnDisplaySize);
System.out.println("è·å¾å" + i + "çé»è®¤çåçæ é¢:" + columnLabel);
System.out.println("è·å¾å" + i + "ç模å¼:" + schemaName);
System.out.println("è·å¾å" + i + "ç±»åç精确度(ç±»åçé¿åº¦):" + precision);
System.out.println("è·å¾å" + i + "å°æ°ç¹åçä½æ°:" + scale);
System.out.println("è·å¾å" + i + "对åºç表å:" + tableName);
System.out.println("è·å¾å" + i + "æ¯å¦èªå¨éå¢:" + isAutoInctement);
System.out.println("è·å¾å" + i + "å¨æ°æ®åºä¸æ¯å¦ä¸ºè´§å¸å:" + isCurrency);
System.out.println("è·å¾å" + i + "æ¯å¦ä¸ºç©º:" + isNullable);
System.out.println("è·å¾å" + i + "æ¯å¦ä¸ºåªè¯»:" + isReadOnly);
System.out.println("è·å¾å" + i + "è½å¦åºç°å¨whereä¸:"+ isSearchable);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
温馨提示:内容为网友见解,仅供参考