erlang解析mysql协议_详细分析mysql 协议的query包及解析
git
https://github.com/sea-boat/mysql-protocol
概况
mysql客户端可以用query包向服务端发送一个基于文本查询。
mysql通信报文结构类型名字描述int<3>payload长度按照the least significant byte first存储，3个字节的payload和1个字节的序列号组合成报文头
int<1>序列号
stringpayload报文体，长度即为前面指定的payload长度
query包
Payload1 [03] COM_QUERYstring[EOF] the query the server shall execute
更多详情 ： https://dev.mysql.com/doc/internals/en/com-query.html
query包类/**
*
*
mysql query packet.
* @author
*
seaboat
*
*
blog: http://www.php.cn/;/pre>
* @version 1.0
* @see http://www.php.cn/
*/public class QueryPacket extends MySQLPacket {
public byte flag;
public byte[] message;
public void read(byte[] data) {
MySQLMessage mm = new MySQLMessage(data);
packetLength = mm.readUB3();
packetId = mm.read();
flag = mm.read();
message = mm.readBytes();
} public void write(ByteBuffer buffer) {
int size = calcPacketSize();
BufferUtil.writeUB3(buffer, size);
buffer.put(packetId);
buffer.put(COM_QUERY);
buffer.put(message);
} @Override
public int calcPacketSize() {
int size = 1;
if (message != null) {
size += message.length;
}
return size;
}
@Override
protected String getPacketInfo() {
return "MySQL Query Packet";
}
}
git https://github.com/sea-boat/mysql-protocol 概况 mysql客户端可以用query包向服务端发送一个基于文本查询。 mysql通信报文结构类型名字描述int<3>payload长度按照the least significant byte first存储，3个字节的payload和1个字节的序列号组合成报文头 int<1>序列号 stringpayload报文体，长度即为前面指定的payload长度 query包 Payload1 [03] COM_QUERYstring[EOF] the query the server shall execute 更多详情 ： https://dev.mysql.com/doc/internals/en/com-query.html query包类/** * * mysql query packet. * @author * seaboat * * blog: http://www.php.cn/;/pre> * @version 1.0 * @see http://www.php.cn/ */public class QueryPacket extends MySQLPacket { public byte flag; public byte[] message; public void read(byte[] data) { MySQLMessage mm = new MySQLMessage(data); packetLength = mm.readUB3(); packetId = mm.read(); flag = mm.read(); message = mm.readBytes(); } public void write(ByteBuffer buffer) { int size = calcPacketSize(); BufferUtil.writeUB3(buffer, size); buffer.put(packetId); buffer.put(COM_QUERY); buffer.put(message); } @Override public int calcPacketSize() { int size = 1; if (message != null) { size += message.length; } return size; } @Override protected String getPacketInfo() { return "MySQL Query Packet"; } }