mysql resultset_mysql 协议的ResultsetRow包及解析

git

https://github.com/sea-boat/mysql-protocol

概况

ResultsetRow包属于服务端返回ResultSet时的其中一部分包，用于描述结果集的行记录。

mysql通信报文结构类型名字描述int<3>payload长度按照the least significant byte first存储，3个字节的payload和1个字节的序列号组合成报文头

int<1>序列号

stringpayload报文体，长度即为前面指定的payload长度

ResultsetRow包

Payloadif(NULL){ 0xfb}else{

Protocol::LengthEncodedString}

更多详情 ： http://dev.mysql.com/doc/internals/en/com-query-response.html#text-resultset

ResultsetRow包类/**

*

*

resultset row packet.

* @author

*

seaboat

*

email: 849586227@qq.com

*

blog: http://www.php.cn/;/pre>

* @version 1.0

* @see http://www.php.cn/

*/public class ResultsetRowPacket extends MySQLPacket {

private static final byte NULL_MARK = (byte) 251;

public int columnCount;

public List columnValues;

public ResultsetRowPacket() {

}

public ResultsetRowPacket(int columnCount) {

this.columnCount = columnCount;

}

@Override

public void read(byte[] data) {

MySQLMessage mm = new MySQLMessage(data);

packetLength = mm.readUB3();

packetId = mm.read();

for (int i = 0; i < columnCount; i++) {

columnValues.add(mm.readBytesWithLength());

}

} @Override

public void write(ByteBuffer buffer) {

BufferUtil.writeUB3(buffer, calcPacketSize());

buffer.put(packetId);

for (int i = 0; i < columnCount; i++) {

byte[] fv = columnValues.get(i);

if (fv == null) {

buffer.put(NULL_MARK);

} else {

BufferUtil.writeLength(buffer, fv.length);

buffer.put(fv);

}

}

} @Override

public int calcPacketSize() {

int size = 0;

for (int i = 0; i < columnCount; i++) {

byte[] v = columnValues.get(i);

size += (v == null || v.length == 0) ? 1 : BufferUtil.getLength(v);

} return size;

} @Override

protected String getPacketInfo() {

return "MySQL Resultset Row Packet";

}

}

以上就是mysql 协议的ResultsetRow包及解析的内容，更多相关内容请关注PHP中文网(www.php.cn)！

本文原创发布php中文网，转载请注明出处，感谢您的尊重！