authenticator.setUser("xjq");
authenticator.setPassword("123456");
authenticator.setInitialSchema("test");
//
final TransportImpl transport = new TransportImpl();
transport.setAuthenticator(authenticator);
transport.setSocketFactory(new SocketFactoryImpl());
transport.connect("localhost", 3306);
//
final ComQuery command = new ComQuery();
command.setSql(StringColumn.valueOf("select * from test.abc where id < 6".getBytes()));
transport.getOutputStream().writePacket(command);
transport.getOutputStream().flush();
//
Packet packet = transport.getInputStream().readPacket();
if(packet.getPacketBody()[0] == ErrorPacket.PACKET_MARKER) {
final ErrorPacket error = ErrorPacket.valueOf(packet);
LOGGER.info("{}", error);
return;
}
//
final ResultSetHeaderPacket header = ResultSetHeaderPacket.valueOf(packet);
LOGGER.info("{}", header);
//
while(true) {
packet = transport.getInputStream().readPacket();
if(packet.getPacketBody()[0] == EOFPacket.PACKET_MARKER) {
EOFPacket eof = EOFPacket.valueOf(packet);
LOGGER.info("{}", eof);
break;
} else {
ResultSetFieldPacket field = ResultSetFieldPacket.valueOf(packet);
LOGGER.info("{}", field);
}
}
//
while(true) {
packet = transport.getInputStream().readPacket();
if(packet.getPacketBody()[0] == EOFPacket.PACKET_MARKER) {
EOFPacket eof = EOFPacket.valueOf(packet);
LOGGER.info("{}", eof);
break;
} else {