µµÀºÀ̾ƹö´ÔÀÇ hexam.cls¸¦ ÀÌ¿ëÇÑ mySQL°ú phpµîÀ» ÀÌ¿ëÇؼ DB¿Í
TeXÀÇ ¿¬µ¿À» ½ÇÇèÇØ º¼·Á°í ÇÕ´Ï´Ù. À̹øÀº DB pool¸¦ ÀÌ¿ëÇؼ ¹«ÀÛÀ§ÀûÀ¸·Î ¹®Á¦¸¦ ÃâÁ¦ ÇÒ ¼ö ÀÖ°Ô ÇÒ·Á°í ÇÕ´Ï´Ù. ¾ó¸¶³ª µµ¿òÀÌ µÉ·ÃÁö´Â ¸ð¸£°ÚÁö¸¸¿ä. ¶ÇÇÑ KLDP¿¡¼ vi like editor on WEBÀÇ Åä·Ð°ú ÇÔ²² ÀÖ´Â editor¿¡ ´ëÇÑ °ÍÀ» ¸¹ÀÌ ÂüÁ¶ ÇÏ·Á°í ÇÕ´Ï´Ù.
¸ñÂ÷
- 1 °³¿ä
- 1.1 DB ¼³°è¿¡ ´ëÇÑ °³¿ä
- 1.2 WebEditor ¸¸µé±â¿¡ ´ëÇÑ °³¿ä
- 1.3 MainȸéÀÇ ¼³°è¿¡ ´ëÇÑ °³¿ä
- 1.4 DB ÀúÀå½Ã html¹®¼·Î ÀúÀåÇϱâ
1.1 DB ¼³°è¿¡ ´ëÇÑ °³¿ä ¶
HExamMain table¼³°è
- idOfMain : int(10) unsigned not null auto_increment,
- CategoryOfAnswer : char(20) not null,¹®Á¦´Â ¾î¶² Ç׸ñ¿¡ ¼ÓÇϴ°¡? ¾î´À chapter¿¡ ¼ÓÇϴ°¡?
- TypeOfQuestion : char(2) not null,¹®Á¦ÀÇ À¯ÇüÀÔ´Ï´Ù. °´°ü½Ä(SC),multiplechoice(MC), ´Ü´ä½Ä(SS), ¾à¼ú½Ä(MS), ¹®Á¦ ¼¼úÇÏ°í ³ÈÄ¿¡ ¿©·¯ ¹®Ç×(LA)
- AbstractOfQuestion : char(200) not null, ¹®Á¦¿¡ ´ëÇÑ °³¿äÀÌ´Ù.
- LANumberOfQuestion : smallint null,LAÇüÀ϶§ ¹®Á¦ÀÇ ¼öÀÔ´Ï´Ù.
- QustionOrList : text not null, ¹®Á¦ÀÔ´Ï´Ù.
- Choice : char(500) null, ¹®Á¦Áß Ç׸ñÀÔ´Ï´Ù.
- AnswerChoice : smallint null,°´°ü½Ä ´äÀÔ´Ï´Ù.
- AnswerString : text null,ÁÖ°ü½Ä ´äÀÔ´Ï´Ù.
- PointofQuestion : smallint not null,¹®Á¦´Â ¸îÁ¡Àΰ¡¿ä?
- DateOfAnswer : datetime not null,¹®Á¦¸¦ ¾ðÁ¦ ³Â´Â°¡¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù. PoolÁßÀÇ ¹®Á¦´Â ¸î %, »õ·Î ÀÛ¼ºÇÑ ¹®Á¦´Â ¸î %¶ó°í ÇÒ ¶§ »ç¿ëÇÏ·Á°í ÇÕ´Ï´Ù.
- GradeOfQuestion : smallint not null, ¹®Á¦ÀÇ ³À̵µ¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù.
create table
HExamMain (
idOfMain int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null
LANumberOfQuestion smallint null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null) ENGINE=INNODB;
LAHExam table
- LAid : int(10) unsigned not null auto_increment, primary key
- idOfMain : int(10) unsigned not null , idOfMainÂüÁ¶°ª
- CategoryOfAnswer : char(20) not null,¹®Á¦´Â ¾î¶² Ç׸ñ¿¡ ¼ÓÇϴ°¡? ¾î´À chapter¿¡ ¼ÓÇϴ°¡?
- TypeOfQuestion : char(2) not null,¹®Á¦ÀÇ À¯ÇüÀÔ´Ï´Ù. °´°ü½Ä(SC),multiplechoice(MC), ´Ü´ä½Ä(SS), ¾à¼ú½Ä(MS), ¹®Á¦ ¼¼úÇÏ°í ³ÈÄ¿¡ ¿©·¯ ¹®Ç×(LA)
- QustionOrList : text not null, ¹®Á¦ÀÔ´Ï´Ù.
- Choice : char(500) null, ¹®Á¦Áß Ç׸ñÀÔ´Ï´Ù.
- AnswerChoice : smallint null,°´°ü½Ä ´äÀÔ´Ï´Ù.
- AnswerString : text null,ÁÖ°ü½Ä ´äÀÔ´Ï´Ù.
- PointofQuestion : smallint not null,¹®Á¦´Â ¸îÁ¡Àΰ¡¿ä?
- DateOfAnswer : datetime not null,¹®Á¦¸¦ ¾ðÁ¦ ³Â´Â°¡¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù. PoolÁßÀÇ ¹®Á¦´Â ¸î %, »õ·Î ÀÛ¼ºÇÑ ¹®Á¦´Â ¸î %¶ó°í ÇÒ ¶§ »ç¿ëÇÏ·Á°í ÇÕ´Ï´Ù.
- GradeOfQuestion : smallint not null, ¹®Á¦ÀÇ ³À̵µ¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù.
create table
LAHExam (
LAid int unsigned not null auto_increment primary key,
CategoryOfAnswer char(20) not null,
TypeOfQuestion char(2) not null,
AbstractOfQuestion varchar(200) not null,
QuestionOrList varchar(500) not null,
Choice varchar(500) null,
AnswerChoice smallint null,
AnswerString varchar(500) null,
PointOfQuestion smallint not null,
DateOfAnswer datetime not null,
GradeOfQuestion smallint not null,
Pa_
IdOfMain int,
INDEX
ParIdOfMain(Pa_
IdOfMain)
FOREIGN KEY (Pa_
IdOfMain) REFERENCE
HExamMain(
IdOfMain) ON DELETE CASCADE
) ENGINE=INNODB;
FigureOfQuestion table
- idOfFigure : int(10) unsigned not null auto_increment, primary key
- idOfMain int(10) unsigned null, HExamMain tableÂüÁ¶
- LAid int(10) unsigned null, LAHExam tableÂüÁ¶
- file_path
- file_name
- file_name2
- file_size
¿©±â¿¡ ÇÑ°¡Áö ´õ ÇÑ´Ù°í ÇϸéÀº ¾Æ¸¶µµ ÀÎÁõ½Ã¿¡ ÇÊ¿äÇÑ tableÁ¤µµÀÏ °Í °°´Ù.
ÀÌ¿Ü·Î phpschool.com¿¡ °¬´õ´Ï ¸¹Àº ÀÚ·á°¡ ÀÖ´Ù. ÀÌÀü¿¡
WebTeX¸¸µé±â¿¡¼ »ç¿ëÇÑ ¹æ¹ýÀº ¾îµð¼ º¸Áöµµ µèÁöµµ ¸øÇÑ ¹æ¹ýÀÌ´Ù. ¿ª½Ã ã´Â ¸¸Å º¸ÀÌ´Â °¡ º¸´Ù.
1.3 MainȸéÀÇ ¼³°è¿¡ ´ëÇÑ °³¿ä ¶
- ÀÔ·Â ºÎºÐ: WebEditor¸¦ ÀÌ¿ëÇÏ°í ´Ù¸¥ ºÎºÐµéÀ» ÀûÀýÈ÷ ÀÌ¿ëÇؼ ¾à 4°³Á¤µµÀÇ ÀÔ·ÂâÀ» ¸¸µé·Á°í ÇÑ´Ù. ±×¾ß ¸»·Î mainâ ¹®Á¦À¯Çü¹× category¿Í ¹®Á¦¿¡ discriptionÀÌ ´ã°ÜÁ® ÀÖ´Â ºÎºÐ --> ¿©±â¼ ¹®Á¦ À¯ÇüÀÌ ³ª¿À¸é °´°ü½Ä, ÁÖ°ü½Ä, ¼¼úÈÄ¿¡ °´°ü½Ä ÁÖ°ü½ÄÀÌ ³ª¿À´Â ÇüÅÂÀÌ´Ù.
- Á» ´õ ½Ã°£ÀÌ ³ª¸é ±âÁ¸ÀÇ ¹®¼¸¦ ±×³É º¹»çÇØ ¿Í¼ ºÙ¿´À»¶§ ÀûÀýÈ÷ htmlÈ ÇØ ÁÖ´Â ±â´Éµµ Çѹø »ý°¢ÇØ º¸ÀÚ.
- ¼öÁ¤ ºÎºÐ : ÀÌ ºÎºÐ¿¡¼´Â TeX source¸¦ ¶ÇÇÑ html·Î ¹Ù²Ù´Â °ÍÀÌ ÇÊ¿äÇÒµí ÇÏ´Ù. ¾îÂî µÇ¾ú´ø º¸¶§±æ ÀÏÀÌ´Ù.
- ã¾Æº¸±â ºÎºÐÀº : category·Î ã±â(ÀÏÀü¿¡ Çß´ø °Í °°ÀÌ ±×³É À§¿¡¼ ¾Æ·¡·Î Âß ³ª¿ÇÏ´Â ½ÄÀÌ ¾Æ´Ñ paging(?) À̶ó°í ÇÏ´Â technique¸¦ ÀÌ¿ëÇÒ °Í, abstract(°³¿ä)·Î ã±â, ³¯Â¥·Î ã±âµî ÀÌ»ó ´õ ÇÊ¿äÇÑ°ÍÀÌ ÀÖÀ»±î¿ä?
- Áö¿ì±â
- TeX¸¸µé±â
- ½ÃÇè¹®Á¦ ¸¸µé±â µîÀÔ´Ï´Ù.
1.4 DB ÀúÀå½Ã html¹®¼·Î ÀúÀåÇϱ⠶
- DB ÀúÀå½Ã htmlÇüÅ·ΠÀúÀåÇϱâ·Î Çß´Ù. ¹°·Ð ¸ðµç Ç׸ñÀ» ´Ù ±×·¸°Ô ÀúÀåÇÒ ÇÊ¿ä´Â ¾øÁö¸¸ html·Î ÀúÀåÇÏ´Â °ÍÀÌ ³ªÁß¿¡ ã¾Æº¸±â ÇßÀ»¶§ ¿øº» ±×´ë·ÎÀÇ ´À³¦À» °¡Áú¼ö ÀÖÀ»µí ÇؼÀÌ´Ù.
- htmltolatex ¶ó´Â java programÀÌ ÀÖ´Ù. ÀÌ°ÍÀ» »ç¿ëÇÏ·Á°í ÇÑ´Ù. ¾îµð±îÁö µÉ·±Áö´Â Àǹ®ÀÌÁö¸¸, ¿ì¸® °Í °°ÀÌ °£´ÜÇÑ °ÍÀ» ÃæºÐÈ÷ °¡´ÉÇϸ®¶ó »ý°¢ÇÑ´Ù. http://htmltolatex.sourceforge.net/ ¿©±â¿¡¼ down¹Þ¾Æ¼ ½ÇÇàÇØ º¸´Ï ±×·±´ë·Î µÇ´Âµí ½Í´Ù.