Question

java程序如何判断mysql数据库中字段的数据类型？

Answer 1

public ParameterList getFieldList(String tableName)throws SQLException{
ResultSet rs = executeQuery("SELECT * FROM " + tableName);
ResultSetMetaData meta = rs.getMetaData();
int columnCount = meta.getColumnCount();
ParameterList result = new ParameterList();
for (int i = 0; i < columnCount; i++)
{
DBTableFieldStruct field = new DBTableFieldStruct();
int cursor = i + 1;
field.type = meta.getColumnType(cursor);
result.append(field);
}
return result;
}