Page 910 - 3-3

Handler();
~Handler();

void Run();
void Stop();
void Start();
};
#endif

< Handler.cpp >

#include "Handler.h"

Handler::Handler(): Power(true), RaspSocket(0) {
// Socket Setting
Server = new TcpServerSock;
ServerSocket = Server->GetServerFD();

// Select setting
maxfd = ServerSocket;
FD_ZERO(&ori_reads);
FD_SET(ServerSocket, &ori_reads);

// MySQL connection Setting
driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "korea1234");
con->setSchema("SmartOffice");
}

Handler::~Handler() {
delete LoginStmt;
delete CurrentStmt;
delete EventStmt;
delete con;
}

void Handler::InitSQL() {
// Database table 초기화
sql::Statement *InitStmt = con->createStatement();
InitStmt->execute("CREATE TABLE IF NOT EXISTS EventLog(Number int
auto_increment primary key, Name text, Status text, Date text)");

InitStmt->execute("CREATE TABLE IF NOT EXISTS UserInfo(ID text, Password text,
Name text)");
InitStmt->execute("DROP TABLE IF EXISTS CurrentStatus");

- 910 -