📄 clidb.cpp
字号:
//-< CLIDB.CPP >-----------------------------------------------------*--------*// FastDB Version 1.0 (c) 1999 GARRET * ? *// (Main Memory Database Management System) * /\| *// * / \ *// Created: 7-Nov-99 K.A. Knizhnik * / [] \ *// Last update: 7-Nov-99 K.A. Knizhnik * GARRET *//-------------------------------------------------------------------*--------*// Example of Web database publishing: Clients Database//-------------------------------------------------------------------*--------*#include "clidb.h"dbDatabase db;//- Client ------------------------------------------------void Client::print(WWWconnection& con) const { con << TAG << "<OPTION VALUE=" << clientId << ">" << organization << "</OPTION>";} REGISTER(Client);//- Manager ------------------------------------------------bool Manager::loginFromAnyHost;void Manager::print(WWWconnection& con) const { con << TAG << "<OPTION VALUE=\"" << name << "\">" << name << "</OPTION>";} REGISTER(Manager);//- Segment ------------------------------------------------void Segment::print(WWWconnection& con) const { con << TAG << "<OPTION VALUE=\"" << name << "\">" << name << "</OPTION>";} REGISTER(Segment);//- History ------------------------------------------------void History::print(WWWconnection& con) const { ThreadContext& the = ThreadContext::of(con); char buf[64]; con << TAG << "<OPTION VALUE=" << messageId << ">" << date.asString(buf, sizeof buf) << " " << (the.managerForm ? the.clients.at(client)->organization : manager != null ? the.managers.at(manager)->name : "") << "</OPTION>";} REGISTER(History);//---- ClientSequencer -------------------------------------REGISTER(Sequencer);template<class T>void print(WWWconnection& con, dbCursor<T>& cursor) { do { cursor->print(con); } while(cursor.next());}template<class T>void print(WWWconnection& con, dbArray<dbReference<T> > const& arr) { dbCursor<T> cursor; for (int i = 0, n = arr.length(); i < n; i++) { cursor.at(arr[i])->print(con); } }//---- Thread Context --------------------------------------------------ThreadContext& ThreadContext::of(WWWconnection& con){ if (con.userData == NULL) { con.userData = new ThreadContext; } return *(ThreadContext*)con.userData;}ThreadContext::ThreadContext() { qClient = "clientId=",clientId; qManager = "name=",&name; qClients = "start from",clientsArray,"order by organization"; qManagers = "start from",managersArray,"order by name"; qSegment = "name=",&name; qMessage = "messageId=",messageId; qMessages = "start from",messagesArray, "order by",dbDateTime::descent("date");}//--- HTML specific part -------------------------------------------#define HTML_HEAD "Content-type: text/html\r\n\r\n\<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 3.2//EN\"><HTML><HEAD>"#define BODY "<BODY BGCOLOR=\"#c0c0c0\">"#define EMPTY_LIST "<OPTION> </OPTION></SELECT><BR>"void mainMenuReference(WWWconnection& con){ char* manager = con.get("manager"); if (manager != NULL) { con << TAG << "<P><HR><CENTER><A HREF=\"" << con.getStub() << "?socket=" << con.getAddress() << "&page=managerForm&manager=" << URL << manager << "\">Back to main menu</A></CENTER>"; } con << TAG << "</BODY></HTML>";}bool error(WWWconnection& con, char const* msg){ con << TAG << HTML_HEAD "<TITLE>ClientDB error</TITLE></HEAD><BODY>" "<H1><FONT COLOR=\"#FF0000\">" << msg << "</FONT></H1></BODY></HTML>"; mainMenuReference(con); return true;}bool addManagerForm(WWWconnection& con){ con << TAG << HTML_HEAD "<TITLE>Add new manager</TITLE></HEAD>" BODY "<H2>Add manager</H2>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"addManager\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\">" "<INPUT TYPE=hidden NAME=\"segment\" VALUE=\"" << con.get("segment") << "\"><TABLE>" "<TR><TH ALIGN=LEFT>Manager name</TH>" "<TD><INPUT TYPE=text NAME=\"name\" SIZE=30></TD></TR>" "<TR><TH ALIGN=LEFT>Host IP address</TH>" "<TD><INPUT TYPE=text NAME=\"ipaddr\" SIZE=16 VALUE=\"*\"></TD></TR>" "<TR><TH ALIGN=LEFT>Administrator rights</TH>" "<TD><INPUT TYPE=CHECKBOX NAME=\"miniadmin\" VALUE=\"on\"></TD></TR>" "</TABLE>" "<INPUT TYPE=submit VALUE=\"Add\"> " "<INPUT TYPE=reset VALUE=\"Reset\"></FORM>"; mainMenuReference(con); return true;}bool addClientForm(WWWconnection& con){ con << TAG << HTML_HEAD "<TITLE>Add new client</TITLE></HEAD>" BODY "<H2>Add client</H2>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"addClient\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\">" "<INPUT TYPE=hidden NAME=\"segment\" VALUE=\"" << con.get("segment") << "\"><TABLE>" "<TR><TH ALIGN=LEFT>Organization</TH>" "<TD><INPUT TYPE=text NAME=\"organization\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>Phone</TH>" "<TD><INPUT TYPE=text NAME=\"phone\" SIZE=20></TD></TR>" "<TR><TH ALIGN=LEFT>Phone2</TH>" "<TD><INPUT TYPE=text NAME=\"phone2\" SIZE=20></TD></TR>" "<TR><TH ALIGN=LEFT>Fax</TH>" "<TD><INPUT TYPE=text NAME=\"fax\" SIZE=20></TD></TR>" "<TR><TH ALIGN=LEFT>E-Mail</TH>" "<TD><INPUT TYPE=text NAME=\"email\" SIZE=30></TD></TR>" "<TR><TH ALIGN=LEFT>WWW address</TH>" "<TD><INPUT TYPE=text NAME=\"www\" SIZE=30></TD></TR>" "<TR><TH ALIGN=LEFT>Person</TH>" "<TD><INPUT TYPE=text NAME=\"person\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>Person2</TH>" "<TD><INPUT TYPE=text NAME=\"person2\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>CEO</TH>" "<TD><INPUT TYPE=text NAME=\"lpr\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>Address</TH>" "<TD><INPUT TYPE=text NAME=\"addr\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>Information</TH>" "<TD><INPUT TYPE=text NAME=\"info\" SIZE=40></TD></TR>" "<TR><TH ALIGN=LEFT>Status</TH>" "<TD><INPUT TYPE=text NAME=\"status\" SIZE=40></TD></TR>" "</TABLE><INPUT TYPE=submit VALUE=\"Add\"> " "<INPUT TYPE=reset VALUE=\"Reset\"></FORM>"; mainMenuReference(con); return true;}bool addSegmentForm(WWWconnection& con){ con << TAG << HTML_HEAD "<TITLE>Add new segment</TITLE></HEAD>" BODY "<H2>Add segment</H2>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"addSegment\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\"><TABLE>" "<TR><TH ALIGN=LEFT>Segment name </TH>" "<TD><INPUT TYPE=text NAME=\"name\" SIZE=30></TD></TR>" "</TD></TR></TABLE><P>" "<INPUT TYPE=submit VALUE=\"Add\"> " "<INPUT TYPE=reset VALUE=\"Reset\"></FORM>"; mainMenuReference(con); return true;}bool addHistoryForm(WWWconnection& con){ con << TAG << HTML_HEAD "<TITLE>Add message</TITLE></HEAD>" BODY "<H2>Add message</H2>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"addHistory\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\"><INPUT TYPE=hidden NAME=\"client\" VALUE=" << con.get("client") << "\"><TEXTAREA NAME=\"message\" ROWS=10 COLS=60></TEXTAREA><P>" "<INPUT TYPE=submit VALUE=\"Add\"> " "<INPUT TYPE=reset VALUE=\"Reset\"></FORM>"; mainMenuReference(con); return true;}bool editManagerForm(WWWconnection& con){ if (con.get("new")) { return addManagerForm(con); } ThreadContext& the = ThreadContext::of(con); the.name = con.get("name"); if (the.name == NULL) { return error(con, "No manager was selected"); } if (the.managers.select(the.qManager) == 0) { return error(con, "No such manager"); } con << TAG << HTML_HEAD "<TITLE>Edit manager form</TITLE></HEAD>" BODY "<H2>Update manager</H2>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"editManager\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\"><INPUT TYPE=hidden NAME=\"oldName\" VALUE=\"" << the.name << "\">" "<TABLE><TR><TH ALIGN=LEFT>Manager name</TH>" "<TD><INPUT TYPE=text NAME=\"name\" SIZE=30 VALUE=\"" << the.managers->name << "\"></TD></TR>" "<TR><TH ALIGN=LEFT>Host IP address</TH>" "<TD><INPUT TYPE=text NAME=\"ipaddr\" SIZE=16 VALUE=\"" << the.managers->IPaddr << "\"</TD></TR>" "<TR><TH ALIGN=LEFT>Administrator rights</TH>" "<TD><INPUT TYPE=CHECKBOX NAME=\"miniadmin\" VALUE=\"on\"" << ((the.managers->flags & Manager::isMinAdmin) ? "CHECKED" : "") << "></TD></TR></TABLE>" "<INPUT TYPE=submit NAME=\"action\" VALUE=\"Update\"> " "<INPUT TYPE=submit NAME=\"action\" VALUE=\"Remove\"></FORM><P>" "<FORM METHOD=POST ACTION=\"" << con.getStub() << "\">" "<INPUT TYPE=HIDDEN NAME=\"socket\" VALUE=\"" << con.getAddress() << "\"><INPUT TYPE=hidden NAME=\"page\" VALUE=\"editHistoryForm\">" "<INPUT TYPE=hidden NAME=\"manager\" VALUE=\"" << con.get("manager") << "\"><SELECT NAME=\"messageId\" SIZE=15>"; the.managerForm = true; if (the.managers->messages.length() != 0) { print(con, the.managers->messages); con << TAG << "</SELECT><BR><INPUT TYPE=submit NAME=\"action\" VALUE=\"Select\"></FORM>"; } else { con << TAG << EMPTY_LIST "</FORM>"; } mainMenuReference(con);⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -