mysql协议的ColumnDefinition包及解析代码详情
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql协议的ColumnDefinition包及解析代码详情,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4136字,纯文字阅读大概需要6分钟。
内容图文
![mysql协议的ColumnDefinition包及解析代码详情](/upload/InfoBanner/zyjiaocheng/539/f17f8e8e4d084b52ab3a59abde860f63.jpg)
git
https://github.com/sea-boat/mysql-protocol
概况
ColumnDefinition包属于服务端返回ResultSet时的其中一部分包,用于描述结果集的字段信息。
mysql通信报文结构
类型 | 名字 | 描述 |
---|---|---|
int<3> | payload长度 | 按照the least significant byte first存储,3个字节的payload和1个字节的序列号组合成报文头 |
int<1> | 序列号 | |
string | payload | 报文体,长度即为前面指定的payload长度 |
ColumnDefinition包
Payload
lenenc_str catalog lenenc_str schema lenenc_str table lenenc_str org_table lenenc_str name lenenc_str org_name lenenc_int length of fixed-length fields [0c]2 character set4 column length1 type2 flags1 decimals2 filler [00] [00] if command was COM_FIELD_LIST { lenenc_int length of default-valuesstring[$len] default values }
更多详情 : http://dev.mysql.com/doc/internals/en/com-query-response.html#column-definition
ColumnCount包类
/** * * <pre><b>column definition command packet.</b></pre> * @author * <pre>seaboat</pre> * <pre><b>email: </b>849586227@qq.com</pre> * <pre><b>blog: </b>http://www.gxlcms.com/;/pre> * @version 1.0 * @see http://www.gxlcms.com/ */public class ColumnDefinitionPacket extends MySQLPacket { private static final byte[] DEFAULT_CATALOG = "def".getBytes(); private static final byte NEXT_LENGTH = 0x0c; private static final byte[] FILLER = { 00, 00 }; public byte[] catalog = DEFAULT_CATALOG;// always "def" public byte[] schema; public byte[] table; public byte[] orgTable; public byte[] name; public byte[] orgName; public byte nextLength = NEXT_LENGTH;// always 0x0c public int charsetSet; public long length; public int type; public int flags; public byte decimals; public byte[] filler = FILLER; public byte[] defaultValues; public void read(byte[] data) { MySQLMessage mm = new MySQLMessage(data); this.packetLength = mm.readUB3(); this.packetId = mm.read(); this.catalog = mm.readBytesWithLength(); this.schema = mm.readBytesWithLength(); this.table = mm.readBytesWithLength(); this.orgTable = mm.readBytesWithLength(); this.name = mm.readBytesWithLength(); this.orgName = mm.readBytesWithLength(); this.nextLength = mm.read(); this.charsetSet = mm.readUB2(); this.length = mm.readUB4(); this.type = mm.read() & 0xff; this.flags = mm.readUB2(); this.decimals = mm.read(); this.filler = mm.readBytes(2); if (mm.hasRemaining()) { this.defaultValues = mm.readBytesWithLength(); } } @Override public void write(ByteBuffer buffer) { int size = calcPacketSize(); BufferUtil.writeUB3(buffer, size); buffer.put(packetId); BufferUtil.writeWithLength(buffer, catalog, (byte) 0); BufferUtil.writeWithLength(buffer, schema, (byte) 0); BufferUtil.writeWithLength(buffer, table, (byte) 0); BufferUtil.writeWithLength(buffer, orgTable, (byte) 0); BufferUtil.writeWithLength(buffer, name, (byte) 0); BufferUtil.writeWithLength(buffer, orgName, (byte) 0); buffer.put(NEXT_LENGTH); BufferUtil.writeUB2(buffer, charsetSet); BufferUtil.writeUB4(buffer, length); buffer.put((byte) (type & 0xff)); BufferUtil.writeUB2(buffer, flags); buffer.put(decimals); buffer.put(FILLER); if (defaultValues != null) { //only use for show columns BufferUtil.writeWithLength(buffer, defaultValues); } } @Override public int calcPacketSize() { int size = (catalog == null ? 1 : BufferUtil.getLength(catalog)); size += (schema == null ? 1 : BufferUtil.getLength(schema)); size += (table == null ? 1 : BufferUtil.getLength(table)); size += (orgTable == null ? 1 : BufferUtil.getLength(orgTable)); size += (name == null ? 1 : BufferUtil.getLength(name)); size += (orgName == null ? 1 : BufferUtil.getLength(orgName)); size += 13; if (defaultValues != null) { size += BufferUtil.getLength(defaultValues); } return size; } @Override protected String getPacketInfo() { return "MySQL Column Definition Packet"; } }
以上就是mysql 协议的ColumnDefinition包及解析代码详情的内容,更多相关内容请关注PHP中文网(www.gxlcms.com)!
内容总结
以上是互联网集市为您收集整理的mysql协议的ColumnDefinition包及解析代码详情全部内容,希望文章能够帮你解决mysql协议的ColumnDefinition包及解析代码详情所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。