untitled

Size: px

Start display at page:

Download "untitled"

ふさこはまもり
7 years ago
Views:

1 Ĺ Ĺ Ĺ Java Ĺ Eclipse Ĺ MySQL Ĺ Ĺ MySQL Ĺ (IT) 1.4 (p.6) Ĺ Ĺ Ĺ Ĺ OS Ĺ HTML 1 10 ii

2 10 Peter Norvig [37] 3 C 1 1) Ĺ Mozilla Firefox Ĺ Java SE Development Kit (JDK) Ĺ Apache Tomcat Ĺ MySQL Ĺ Eclipse + Web Tools Platform (WTP) OS Ĺ Windows XP, Vista Ĺ GNU/Linux Ĺ Mac OS X 10.3 GNU/Linux CD PC 2 p. 13 (taro.yabuki@unfindable.net) ( ) Firefox JDK 5.0 Tomcat 5.5 MySQL 5 Eclipse 3.2 WTP 1.5 OS Windows XP, Vista Mac OS X GNU/Linux Slax 5.1.7b iii

13 (taro.yabuki@unfindable.net) (http://www.morikita.co.jp/soft/84731/) 2007 7 1) Firefox 1.5 2.0 JDK 5.

3 CD CD Firefox HTML HTML XHTML CSS: HTML GET: URL POST JSP: HTML Java iv

.. 22 4.3 CSS:... 26 4.4 HTML... 33 5 36 5.1... 36 5.2... 38 5.

4 6.3 JSP DBMS phpmyadmin SELECT MySQL JDBC: Java JDBC SQL GET Ajax Model, View, Controller MVC MVC v

1 JDBC: Java... 109 9.2 JDBC... 110 9.3... 113 9.4 SQL... 114 10 119 10.1... 119 10.2 GET... 121 10.3... 122 10.

5 A C Java 147 A A A B 167 B B B B B C 178 C.1 Windows Vista XP C.2 GNU/Linux C.3 Mac OS X vi

.. 174 B.5... 176 C 178 C.1 Windows Vista XP... 178 C.2 GNU/Linux.

6 CAPTER

7 1 1.2 (Database Management System, DBMS) 2 1. OS 2. 1) 1. 2) 2. 3) 3. 4) 1) (Write Once, Run Anywhere, WORA) Java Java Java 2) PC 3) 4) JavaScript Flash 2

8 p. 69 phpmyadmin (World Wide Web, WWW, Web ) 5) 6) 1.2 7) [1] 8) 5) 6) [33] [38] 7) 3

9 1 1.3 (p. 10) \ ě 9) B.1 (p.167) Windows-31J Code Page 932 (CP932 ) MS932 Shift_JIS Windows-31J Shift_JIS 10) Windows Mac OS X GNU/Linux GNU/Linux 2 (p. 13) GNU/Linux URL URL URL URL 11) C C C AC Java Model, View, Controller 12 B 8) p.212 9) 10) Shift_JIS 11) Internet Archive ( 4

Mac OS X GNU/Linux GNU/Linux 2 (p. 13) GNU/Linux URL URL URL URL 11) 1.

10 Ĺ Ĺ Ĺ C C C C C++ Java C [5] 1 int s=0; s 0 int a[]={1,3,5}; a[2] 5 0 For for(int i=1; i<=100; ++i) s+=i; s {} If-Else if(s%2==0) printf("even\n"); else printf("odd\n"); 5

$If-Else if(s%2==0) printf("even\n"); else$

11 1 s even odd int sum(int start, int end){ int s=0; for(int i=start; i<=end; i++) s+=i; return s; } start end C C C Java 1.4 Ĺ Ĺ Ĺ Ĺ OS Ĺ HTML Ĺ HTML CSS Ĺ Ĺ 12) Ĺ 12) 6

12 C Java Java Java C Java Java C Java Java Java 13) C Java A p ) Java PHP, Perl, Ruby SQL JavaScript 3 Google Web Toolkit ( Java Java 6.0 (javax.script) JavaScript SQL Java JavaScript 7

147 13) Java PHP, Perl, Ruby SQL JavaScript 3 Google Web

13 Java Java (Integrated Development Environment, IDE) Eclipse 14) Web Tools Platform (WTP) MVC MVC ) Eclipse IDE Sun Microsystems NetBeans ( [56] IDE 8

IDE) Eclipse 14) Web Tools Platform (WTP) 1.4.3 3 MVC MVC 1.

14 1.5 1 SQL Windows Windows-31J UTF ) 1.3 HTML : 3 4 : 5 : 6 15) Apache HTTP Server Apache Tomcat Tomcat (p. 2) Apache Apache Software Foundation Apache HTTP Server 3 9

15 1 1.3 : 7 8 JDBC : 9 1. HTML CSS Java 16) Java PHP 1, 2, 4 Java 3, 5 PHP COLUMN.NET LAMP (Linux+Apache+MySQL+PHP, Perl or Ruby) J2EE (Java 2 Enterprise Edition).NET ASP.NET J2EE Struts JSF Ruby Rails ) Ruby on Rails

16 J2EE Java OS.NET GNU/Linux Mac OS X.NET Mono ( Java.NET C# ECMA-334 JIS X 3015 Perl PHP Perl PHP [75] HelloWorld MVC 11 p. 128 COLUMN Sun Web : JSP ( : ( 11

17 1 ORACLE MASTER : Oracle Master Silver Fellow (Oracle 9i) ORACLE MASTER Bronze (Oracle 10g) SQL (Database Administrator, DBA) SQL DBA Oracle ( MySQL Certifications : MySQL ( ertification/) 12

DBA) SQL DBA Oracle (http://www.oracle.co.

18 CAPTER2 CD GNU/Linux CD 1) CD Mac 2.1 CD CD 1. ( CD ISO 2. ISO CD CD-R CD LICENCE COPYING 2) 2.2 CD CD 2.1 root toor startx Eclipse Firefox CD CD-ROM USB USB touch test USB 1. USB 2. USB 1) C (p. 178) 2) USB CD 13

19 CAPTER3 1 HTML CSS HTML 3.1 Firefox Windows Internet Explorer Opera Firefox Safari Firefox 1) Ĺ Ĺ Ĺ Windows GNU/Linux, Mac OS X C (p. 178) Firefox 1) Opera 16

20 CAPTER HTML HTML 1) img image.png HelloWorld.html <html> <body> <img src= image.png alt= ></img> </body> </html> img src= src= img src " img alt img <img src= image.png />> /> br p br HTML XHTML 1) HTML JavaScript canvas 20

png alt= ></img></p> </body> </html> img src= src= http://www.example.

21 4.1 HTML 4 pre pre pre <pre>pre pre </pre> code blockquote, q (block-level quotation) blockquote Web <blockquote> (block-level quotation) blockquote Web </blockquote> q <q> q </q> q em strong em strong em strong strong strong 21

22 CAPTER (p.52) 5.1 C XAMPP RequestedParameters.jsp $CATALINA_HOME/webapps/ROOT CATALINA_HOME Tomcat Windows C:\xampp\tomcat C:\Program Files\xampp\tomcat GNU/Linux /opt/lampp/tomcat Mac OS X /Applications/xampp/xamppfiles/tomcat 1) <?xml version="1.0" encoding="utf-8"?> <%@ page language="java" contenttype="text/html; charset=utf-8" import="java.util.*"%> <%@ taglib prefix="c" uri=" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" " 1) Windows $CATALINA_HOME %CATALINA_HOME% 36

23 5.1 5 <html xmlns=" <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>requested Parameters</title> </head> <body> <table> <tr><th>name</th><th>value</th></tr><% for(enumeration e=request.getparameternames();e.hasmoreelements();){ String name=(string)e.nextelement(); for(string value:request.getparametervalues(name)){%> <tr> <td><c:out value="<%=new String(name.getBytes("ISO8859_1"),"UTF-8") %>" /></td> <td><c:out value="<%=new String(value.getBytes("ISO8859_1"),"UTF-8") %>" /></td> </tr><% } }%> </table> </body> </html> Tomcat $CATALINA_HOME/webapps/ROOT RequestedParameters. jsp Windows : %CATALINA_HOME%\bin\startup.bat Windows 5.2 Tomcat 37

24 CAPTER6 6.1 Java A p (p.17) HelloWorld.html HTML <html> <body> Hello World! </body> </html> printf "<html>\n" printf "<body>\n" printf "Hello World!\n" printf "</body>\n" printf "</html>\n"

25 6 li 100 printf "<ul>"; i=1; while [ $i -le 100 ] do printf "<li>%d</li>" $i; i=$(($i+1)); done printf "</ul>"; (p. 23) 1) printf <?xml version="1.0" encoding="utf-8"?> ; printf <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" ; printf " ; printf <html xmlns=" JSP (JavaServer Pages) JSP Java 6.1 JSP: HTML Java JSP Hello World JSP HelloWorld <html> <body> <% out.println("hello World!"); %> </body> </html> hello World! HTML Java <% %> Java 2) 1) 2) <% Java %> JSP <jsp:scriptlet> Java </jsp:scriptlet> XML 46

26 CAPTER7 1 (Database Management System, DBMS) 7.1 DBMS 7.1 DBMS DBMS HTML HTML 57

27 7 1 OS DBMS (Relational Database, RDB) RDB RDBMS (Relational Database Management System) 7.2 RDBMS 7.2 RDBMS 1 1 1) RDBMS RDBMS RDBMS MySQL MySQL RDBMS MySQL MySQL p ) MySQL RDBMS Oracle 7.2 MySQL Oracle MySQL 58

28 CAPTER SELECT (p.65) SELECT SELECT FROM WHERE SELECT 8.2(p. 80) DISTINCT mysql> SELECT DISTINCT publisher FROM books; publisher GROUP BY 8.10 p. 93 books publisher mysql> SELECT publisher, AVG(price) -> FROM books -> GROUP BY publisher; publisher AVG(price) HAVING GROUP BY 71

29 8 2 WHERE (7.4.2 p.65) 5,000 mysql> SELECT publisher, AVG(price) AS x -> FROM books -> GROUP BY (publisher) -> HAVING x>5000; publisher x ORDER BY ORDER BY price DESC mysql> SELECT title,price -> FROM books -> ORDER BY price; title price The Art of Computer Programming Volume SELECT SELECT [ ] SELECT [ALL DISTINCT DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr,... [FROM table_references [WHERE where_condition] [GROUP BY {col_name expr position} [ASC DESC],... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name expr position} [ASC DESC],...] [LIMIT {[offset,] row_count row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [INTO OUTFILE file_name export_options INTO DUMPFILE file_name 72

30 CAPTER9 RDBMS 9.1 Java JDBC (Java DataBase Connectivity) 1) JDBC 9.1 JDBC: Java Java RDBMS JDBC RDBMS MySQL MySQL Connector/J 9.1 JDBC MySQL Connector/J MySQL Connector/J %CATALINA_HOME%/common/lib mysql-connector-java- -bin.jar MySQL Connector/J C.1.6 (p. 187) MySQL Connector/J RDBMS RDBMS 7.5 (p.68) MySQL 1) JDBC ODBC (Open DataBase Connectivity) 109

31 9 mysql db mydb test 7.6 p. 69 phpmyadmin mysql> SELECT * FROM mysql.db WHERE Db= mydb \G *************************** 1. row *************************** Host: localhost Db: mydb User: test Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: N Drop_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Create_view_priv: N Show_view_priv: N Create_routine_priv: N Alter_routine_priv: N Execute_priv: Y mydb localhost mydb SELECT INSERT, UPDATE, DELETE, EXECUTE 2) RDBMS MySQL 9.2 JDBC SQL mydb samples UPDATE Jdbc.jsp JSTL 2) SELECT Views 110

32 CAPTER 10 JSP MySQL JDBC URL URL /zipcode/download.html (ken_all.lzh) (jigyosyo.lzh) CSV Windows-31J UTF-8 UTF-8N BOM UTF-8 KEN_ALL_UTF8.CSV JIGYOSYO_UTF8.CSV Windwos-31J CSV 119

33 jis 1 1 JIS old_zip 2 ( ) (5 ) 9 zip 3 (7 ) 8 addr1_ruby 4 addr2_ruby 5 addr3_ruby 6 addr1 7 4 addr2 8 5 addr3 9 6 addr4 7 establishment_ruby 2 establishment 3 mydb CREATE TABLE zips( jis CHAR(10) DEFAULT NOT NULL, old_zip CHAR(5) NOT NULL, zip CHAR(7) NOT NULL, addr1_ruby VARCHAR(10) DEFAULT NOT NULL, addr2_ruby TEXT NOT NULL, addr3_ruby TEXT NOT NULL, addr1 VARCHAR(10) DEFAULT NOT NULL, addr2 TEXT NOT NULL, addr3 TEXT NOT NULL, addr4 TEXT NOT NULL, establishment_ruby TEXT NOT NULL, establishment TEXT NOT NULL, KEY zip_idx (zip) ) DEFAULT CHARACTER SET utf8; zips UTF-8 LOAD SET NAMES utf8; LOAD DATA LOCAL INFILE "KEN_ALL_UTF8.CSV" INTO TABLE zips FIELDS TERMINATED BY, ENCLOSED BY " (jis,old_zip,zip,addr1_ruby,addr2_ruby,addr3_ruby,addr1,addr2,addr3); LOAD DATA LOCAL INFILE "JIGYOSYO_UTF8.CSV" INTO TABLE zips FIELDS TERMINATED BY, ENCLOSED BY " (jis,establishment_ruby,establishment,addr1,addr2,addr3,addr4,zip,old_zip); 120

34 CAPTER 11 Model, View, Controller model, view, controller 11.1 MVC Monolithic JSP 10 (p.119) JSP (zip.jsp) zip.jsp JSP Monolithic JSP 11.1 [47] JSP MVC 11.1 Monolithic JSP Model-View-Controller MVC 11.2 Controller : Servlet Model : JavaBeans 1) 128

35 11.2 MVC 11 View : JSP 11.2 Model-View-Controller 11.2 MVC MVC Client: zip.controller (code=194) 2. Controller: zip.model 3. Controller: zip.model (code="194") 4. Controller: zip.model 5. Model: SELECT 6. Controller: zip.model 7. Controller: View.jsp 8. View: zip.model 9. View: zip.model 1) Model JavaBeans EJB (Enterprise JavaBeans) EJB EJB 3.0 Model 129

36 CAPTER 12 internationalization 18 i18n [25] localization l10n 1 multilingualization m17n 12.1 i18n-sample.jsp JSP Firefox JSP 12.1(a) / [en-us] 12.1(b) 12.1(c) JSP i18n-sample.jsp 12.1 i18n-sample.jsp USA January 28, janvier

37 A C Java C Java A.1 1) int double C A.1.1 firstname, lastname run Person Person mypackage Person A.1 UML A.1 Person UML - + (visibility) A.1 Eclipse Eclipse 1) C 147

38 B 21 Unicode 6 Joel Spolsky[44] B.1 1) B.1 ASCII p. 51 ISO ASCII Latin 1 JIS X 0201 ASCII 158 ISO-2022-JP JIS X ISO-2022 JIS X 0201 ISO JIS JIS EUC-JP JIS X ISO-2022 Unix Shift_JIS JIS X Shift_JIS JIS JIS Windows-31J JIS X Shift_JIS PC Shift_JIS UTF-8 UCS UTF-8 Unicode 1 3 UTF-16 UCS UTF ) ASCII 167

39 C Mozilla Firefox Java SE Development Kit (JDK) Apache Tomcat MySQL Eclipse + Web Tools Platform (WTP) MySQL XAMPP XAMPP MySQL Apache HTTP Server PHP MySQL phpmyadmin p. 69 OS C.1 Windows Vista XP Windows Vista XP 1) Vista XP 2) C.1.1 Windows Windows. Windows XP C.1 1) VMware Server 1.0 Windows Vista RC1 Windows XP 2) Windows (Administrator) Windows Vista Windows XP 178

40 212 [1] p. 35 [2] Alan Beaulieu. Learning SQL. Oreilly & Associates Inc., SQL., p. 86, 106 [3] Hans Bergsten. JavaServer Pages. O Reilly & Associates, Inc., 2nd edition, JavaServer Pages.. 2, p. 52, 141 [4] T. Berners-Lee, R. Fielding, and L. Masinter. RFC3986: Uniform resource identifier (URI): Generic syntax H-Hash. cgi-bin/rfc.cgi?3986. p. 175 [5] Kernighan B.W. and Ritchie D.M. The C Programming Language. Prentice Hall, 2nd edition, C., 2, p. 5 [6] Masakatz Canada.. i/tech/mailaddrmatch/. p. 156 [7] Joe Celko. Joe Celko s SQL for Smarties: Advances SQL Programming. Academic Press, 2nd edition, SQL., 2, (p.106) [8] Joe Celko. Joe Celko s SQL Puzzles and Answers. Morgan Kaufmann Pub., 2nd edition, p. 106 [9] David Crane, Eric Pascarello, and Darren James. Ajax in Action. Manning Pubns Co., 2005.,,. Ajax., p. 123 [10] C&R. SQL., p. 77, 106 [11] Ian F. Darwin. Java Cookbook. Oreilly & Associates Inc., 2nd edition, 2004.,. Java., p. 166 [12] C. J. Date. An Introduction to Database Systems. Addison-Wesley Pub., 8th edition, , p. 106 [13] Andrew Deitsch and David Czarnecki. Java Internationalization. Oreilly & Associates Inc., JAVA., p. 146 [14] David Ewing Duncan. Calendar: Humanity s Epic Struggle to Determine a True and Accurate Year. Bard, , p. 157 [15] R. Fielding, et al. RFC2616: Hypertext transfer protocol http/ ocols/rfc2616/rfc2616.html, H-Hash. HTTP/ p. 43 [16] Martin Fowler. UML Distilled: A Brief Guide to the Standard Object Modeling Language. Addison- Wesley Pub., 3rd edition, UML., 3, p. 166 [17] Eric Freeman, Elisabeth Freeman, Kathy Sierra, and Bert Bates. Head First Design Patterns. Oreilly & Associates Inc., 2004.,. HeadFirst., p. 141 [18] Jeffrey E. Friedl. Mastering Regular Expressions. Oreilly & Associates Inc., 3rd edition, , 2, p. 166 [19] Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides. Design Patterns: Elements of Reusable Object-Oriented Software. Addison-Wesley Pub., and..,, p. 141 [20] GIJOE. PHP., p. 141 [21] Stephen Jay Gould. Questioning the Millennium. Random House Inc., , p. 156

41 [22] Jim Gray and Andreas Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann Pub., BP, p. 106 [23] Robert Hess.? rosoft.com/japan/msdn/columns/hess/hess aspx, p. 35 [24] John E. Hopcroft, Rajeev Motwani, and Jeffrey D. Ullman. Introduction to Automata Theory, Languages, and Computation. Addison Wesley Longman, 2nd edition, I II., 2, p. 153 [25] I18nGuy. Origin of the abbreviation i18n. p. 142 [26] Klensin, J., editor. RFC2821: Simple mail transfer protocol. ftp://ftp.isi.edu/in-notes/rfc282 1.txt, srgia p. 156 [27] Donald Ervin Knuth. The Art of Computer Programming. Addison Wesley, 3rd edition, , p. 104 [28] Mark A. Kolb. The expression language. /j-jstl0211.html, ( -jstl0211.html). p. 52 [29] Ken Lunde. CJKV Information Processing. Oreilly & Associates Inc., 1998.,. CJKV., p. 74 [30] L. Masinter, et al. RFC2718: Guidelines for new URL schemes. 8.txt, p. 175 [31] Brett McLaughlin. Head Rush Ajax. Oreilly & Associates Inc., HeadRushAjax., p. 123 [32] Eric A. Meyer. DOCTYPE grid. p. 24 [33] Peter Morville. Ambient Findability. Oreilly & Associates Inc., , p. 3 [34] Jakob Nielsen. Jakob Nielsen Alertbox. p. 35 [35] Jakob Nielsen. Alertbox. RBB PRESS, p. 35 [36] Donald A. Norman. The Psychology of Everyday Things. Basic Books, , p. 35 [37] Peter Norvig. Teach yourself programming in ten years. yomoyomo, technique/21-daysj.html, p. iii [38] Morville P. and Rosenfeld L. Information Architecture for the World Wide Web. Oreilly & Associates Inc., 3rd edition, Web., 2, p. 3, 35 [39] Arnold Robbins and Nelson H.F. Beebe. Classic Shell Scripting. O Reilly Media, , p. 197 [40] Dave Shea and Molly E. Holzschlag. The Zen of CSS Design: Visual Enlightenment for the Web. Peachpit Press, CSS Zen Garden Book., p. 35 [41] Kathy Sierra, Bryan Basham, and Bert Bates. Head First Servlets & JSP. Oreilly & Associates Inc., p. 141 [42] Kathy Sierra and Bert Bates. Head First Java. Oreilly & Associates Inc., 2nd edition, , 2, p. 166 [43] Ishida So p. 44 [44] Joel Spolsky. Joel on Software. Apress, Joel on Software., p. 167 [45] Sun Microsystems, Inc. Java FAQ. c/intl/faq_ja.jsp. p. 146 [46] Sun Microsystems, Inc. JavaServer Pages (jsp) v2.0 syntax reference

42 cts/jsp/syntax/2.0/syntaxref20.html. p. 47, 52 [47] Bruce Tate. Bitter Java. Manning Pubns Co., Java. BP, p. 128 [48] Jenifer Tidwell. Designing Interfaces. Oreilly & Associates Inc., , p. 35 [49] W3C. Cascading Style Sheets, level 2 specification : p. 30 [50] W3C. Web content accessibility guidelines Miki Ofuji ts/wcag10/. p. 35 [51] W3C. Recommended list of DTDs p. 24 [52] Robin Williams. The Non-Designer s Design Book. Peachpit Pr., 2nd edition, , 2, p. 35 [53] W3C HTML working group. XHTML 1.0 the extensible hypertext markup language. w3.org/tr/2000/rec-xhtml /, XHTML 1.0: p. 35 [54] Satoh Yoshiyuki. RFC p. 44 [55] Jeremy D. Zawodny and Derek J. Balling. High Performance Mysql: Optimization, Backups, Replication and Balancing. Oreilly & Associates Inc., MySQL., p. 106 [56]. Java NetBeans Java GUI & WEB., p. 8 [57]. Web XHTML CSS Web., p. 24, 27, 33, 35 [58]. Web p. 35 [59]. MySQL., p. 106 [60].., p. 100, 106 [61]. CSS., p. 35 [62].!! MySQL p. 81 [63].!! PostgreSQL vs MySQL. /index.html, p. 107 [64]. Java.,, p. 141 [65].., p. 170 [66].., p. 79 [67]. RDBMS., p. 106 [68]. JIS.,, p. 170, 177 [69]. Java., p. 166 [70]. Windows-31J p. 168 [71].. ess.co.jp/www/column/ogata/. p. 177 [72],,,.., p. 177 [73]. RFC., p. 44 [74].., p. 74, 177 [75]. Java Perl rltips/javaperl.htm, p. 11 [76]. HTML & XHTML & CSS., p. 24, 27,

43 [77]. Web Designer 2.0 Web., p. 35 [78],. Ajax., p. 123 [79].., p. 168 [80]. DB&DM Web XML P2P. CQ, p. 106 [81].,, pp , p. 170 [82]. Shift_JIS. t_jis.html. p. 168 [83]. JIS p. 177 [84].., p. 79 [85]. MySQL., p. 106 [86]. HTML/XHTML p. 35 [87] Paul Dubois. MySQL Cookbook. Oreilly & Associates Inc., 2nd edition, 2006 p. 106 [88] Anthony Molinaro. SQL Cookbook. Oreilly & Associates Inc., 2005.,. SQL p. 106 [89] Jonathan Gennick. SQL Pocket Guide. Oreilly & Associates Inc., SQL p. 106 [90]. Web., 2006 [91]. Web /, 2004 [92]. List 3. ips/136java026.html, 2005 [93] Shelley Powers. Learning JavaScript. O Reilly Media, Inc., 2006.,. JavaScript., p. 52 [94] Thomas H. Cormen and Charles E. Leiserson. Introduction to Algorithms. MIT Press, , 2, p. 102 [95] Douglas R. Hofstadter. Metamagical Themas. Basic Books Inc., ,, p

44 20, 26 20, 26.htaccess 172.inputrc 207.mo 200.NET 10 < 25 > 25 << 93 = 97 >> 93 & 25 & 25 ' 26 > 25 < 25 " 26 ^ 93 ~ \ 4 \e 75 ě 4 Override A ABS 92 ACOS 92 action 39 ADDDATE 92 Administrator 178 Adobe Reader Adobe-Japan , 170 Adobe-Japan Ajax 51, 122 All-in-one Eclipse 188 ALTER DATABASE 74 ALTER TABLE 62 alt 20 ANALYZE TABLE 101 ANY 97 Apache Derby see Derby Apache HTTP Server 9, 34, 172, 178 Tomcat 125 Apache Tomcat see Tomcat API 153 application 133 ArrayList 161 Arrays 164 ASCII 167 ASIN 92 ATAN 92 AUTO_INCREMENT 61, 114 AUTOCOMMIT 82 AVG 93 a 43, 175 B background-attachment 32 background-color 29, 32 backqround-image 32 background-position 32 background-repeat 32 bash 208 BASIC 126 Berners-Lee, Tim 23 bf 20 BINARY_DOUBLE 62 BINARY_FLOAT 62 BIT 62 BIT_COUNT 93 BLOB 62 blockquote 21 body 24 BOM 179 border 31 border-collapse 32 border-color 32 border-style 19, 32 border-width 29, 32 br 20 Byte Order Mark see BOM B 100 C c:choose 55 c:foreach 54 c:if 54

45 c:out 54 C# 11 CACHE see Calc (OpenOffice.org) 84 Calendar 156 Callisto 194 canvas 20 caption 19 Cascading Style Sheets see CSS CASE 91 CATALINA_HOME 36 catch 152 CEIL 92 CHAR 62 CHAR_LENGTH 91 Character Identifier see CID characterencoding 173 charset 24 CID 168 class 28, 29 clear 32 Client VM 51, 181 CLOB 62 Code Page 932 see CP932 code 21 Collections 164 color 29, 32 colspan 40 Comparable 165 compare 165 CONCAT 91 Connector 176 CONSTRAINT 61, 104 contenttype 47 content 32 context.xml 116, 118, 126 Controller 128 controller 132 cookie 138 COS 92 COT 92 CotEditor 207 COUNT 93 CP932 4, 75 cp , 173 CRC32 92 CREATE DATABASE 59 CREATE INDEX 100 CREATE TABLE 60, 81 CSS 16, 26 CSV 119 CURRENT_DATE 92 CURRENT_TIME 92 CURRENT_TIMESTAMP 92 cursor 32 cut 84 Cygwin 75 C 5 D Data Tools Platform see DTP Database Administrator see DBA DataBase Management System see DBMS datasource 116 DATE 62 DATEDIFF 92 datestyle 145 DATETIME 62 DB2 107, 118 DBA 12 DBMS 2, 10, 57 DCL 82 DDL 82 dd 18 DECIMAL 62 DEFAULT 61 DEGREES 92 DELETE 68 Derby 107 DESC 61, 72 DESCRIBE 61 dhcpcd 199 DIGEST 126 dir2mo 200 display 32 DISTINCT 71 DIV 92 div 30 dl 18 DML 82 DOCTYPE see doget 132 dopost 132 DOUBLE 62 DROP DATABASE 60 DROP INDEX 100 DROP TABLE 61 DTP 75 dt 18 DUAL 67 E Eclipse 8 (GNU/Linux) 204 (Mac OS X) 210 (Windows) EDITOR 76 EJB 129 EL 52, 139 Emacs 179, 207 EmEditor Free 179 em 25 em 21 enctype 43 ENGINE 81 Enterprise JavaBeans see EJB 217

46 en 25 ER 79 EUC-CN 176 EUC-JP 167, 176 Excel 84 EXISTS 97 EXP 92 EXPLAIN 99 Expression Language see EL extension (Firefox) 180 EXTRACT 92 F fdisk 199 fileupload 52 find 106 Firebird 108 FireBug 180 Firefox 16, 179, 201 HTML Validator 22 Live HTTP Headers 145 (GNU/Linux) 201 (Mac OS X) 208 (Windows) 179 Flash 2 FLOAT 62 float 32 FLOOR 92 fmt:formatdate 145 fmt:message 144, 146 fmt:param 146 fmt:setbundle 144 font-family 32 font-size 27, 29, 32 font-style 29, 32 font-weight 32 font 27 for FOREIGN KEY 104 FORMAT 93 FORM 125, 126 form 39 FULLTEXT 105 G GB GET 42, 43 getattribute 55 getter 149 GNU Emacs see Emacs GNU/Linux 197 Google Web Toolkit 7 GPL 107 GREATEST 92 GregorianCalendar 157 GROUP BY 71 H h1 h6 17 HashMap 163 HashSet 162 HAVING 71 head 24, 172 height 32 HEX 91 Hibernate 141 href 175 HTML 9, HTML Tidy 180 HTML Validator 22, 27 Html Validator 180 html 24 HTTP 42 httpd.conf 172 HTTP 180 I i18n see IANA 172 ibatis 141 IBM 169 ICU 159 IDE 8 id 29 IE Tab 180 IF , 201, 203 ifconfig 34, 199 img 20, 43, 138 import 47, 114 IN 97 INDEX 105 InnoDB 81, 108 input 40 INSERT 63, 99 INSERT IGNORE 65 INT 62 INTEGER 62 International Components for Unicode see ICU internationalization see Internet Explorer 16, 180 ipconfig 34, 199 IP 34, 199 IS NOT NULL 77 IS NULL 77 ISO ISO-2022-JP 167 ISO , 167, 176 ISO/IEC J J2EE 10 J2SE Development Kit see JDK J2SE Runtime Environment see JRE JakartaCommons fileupload

47 Java , 172 Java 2 Enterprise Edition see J2EE Java DataBase Connectivity see JDBC Java DB 107 Java Persistence API see JPA Java Studio Creator 141 java.util.japaneseimperial Calendar 158 JAVA_HOME 183 JavaBeans 128 javac 172 JavaScript 2, 7, 51, 150 JavaServer Pages see JSP javax.script 7 JDBC 10, 109, JDBCRealm 125 JDK 181 (GNU/Linux) 201 (Mac OS X) 208 (Windows) 181 JIS X JIS X JIS X JIS X JIS X JIS 171 join 84 JPA 141 JRE 181 JSF 141 JSP 46, , 176 JSP Standard Tag Library see JSTL JSP 46 JSTL JUnit 141 K Knoppix 197 Konqueror 199 L l10n see label 40 LAMP 10 language 47 Latin 1 74, 167 LEAST 92 LEFT 91 LF 83 LGPL 107 LIMIT 121 LinkedList 160 Linux see GNU/Linux List 162 list-style-image 32 list-style-type 18, 32 Live CD see CD Live HTTP Headers 44, 138, 145, 180 li 18 LN 92 LOAD 82 local see localization see LOCATE 91 LOG 92 login-config 125 LONG 62 LONGBLOB 62 LONGTEXT 62 Ludia 105 M m17n see Mac OS X 108, 207 Map 164 margin 31 margin 32 MAX 93 MD5 93 Meadow 179 MEDIUMBLOB 62 MEDIUMTEXT 62 MemoryRealm 125 mata 172 method 39, 43 Microsoft Excel 84 MIN 93 mkdir 200 mkfs 199 MOD 67, 92 mod_proxy_ajp 125 Model 128 model 130 module (Slax) see (Slax) Mono 11 Monolithic JSP 128 mount 199, 200 MS932 4, 169 multilingualization see MVC 8, 11 MyISAM 81, 100, 108 MySQL mysql 184 MySQL Certifications 12 MySQL Connector/J 109, 187 mysqldump 105 N native2ascii 144 NEC 169 NetBeans 8 Network File System see NFS 219

48 NFS 199 NOT NULL 61 NOT NULL 104 NTFS Utils 182 NULL 61 NUMBER 62 O O/R 141 ODBC 109 ol 18 OpenOffice.org Calc 84 OpenType 168 Opera 16 OperaView 181 OPTIMIZE TABLE 101 Oracle 107 ORACLE MASTER 12 ORDER BY 72 out 50 P padding 31 padding 32 page 133 pagecontext 55 pageencoding 47 page 47, 150 PATH 182 Pattern 154 Perl 11 PHP 10, 11, 108, 178 phpmyadmin 69, 75, 178 PI 92 Plain Old Java Object see POJO POJO 130 position 32 POST 43 PostgreSQL 105, 107 POWER 92 PreparedStatement 115 pre 21 PRIMARY KEY 62 Properties Editor 188, 194 Prototype 123 Proxy Server 194 p 17 Q QR Code 181 q 21 R RADIANS 92 Rails see Ruby on Rails RAND 92 RDB 58 RDBMS 58 REAL 62 Realm 125 REFERENCES 104 Relational Database Management System see RDBMS REPEAT 91 REPLACE 91 request 133 RESET QUERY CACHE 99 REVOKE 69 RFC RFC RGB 29 ROUND 92 rows 112 rowspan 40 Ruby on Rails 10, 141 S Safari 16 sc 187 scote 133 script 43, 138 sed 200 SELECT 65, 112 Selenium 141 semantic web see Senna 105 Server VM 51, 181 Servlet 128, session 133, 137 session-timeout 137 Set 163 SET NAMES 75 setattribute 55 setmaxrows 121 setter 149 SGML Parser 180 SHA1 93 Shift_JIS 4, SHOW CREATE 75, 100 SHOW DATABASES 60 SHOW TABLES 61 SHOW WARNING 81 SIGN 92 SIN 92 SJIS 169 sjis 169 Slax 197, 198 SOURCE 75, 105 span 27, 30 SQL 7, 106 SQL Server 107 SQL sql:query 112 sql:update 112 SQLite 107 SQL 9, 114 SQRT 92 src 20, 43, 138 SSL 126 Statement 121 STDDEV 93 STDDEV_POP 93 STDDEV_SAMP

49 stdout.log 50 stored procedure see String 153 StringBuffer 153 strong 21 Struts 141 style 27 SUBSTR 67, 91 SUBSTRING_INDEX 91 SUM 93 Sun Web 11 SYSIBM.SYSDUMMY1 67 T table 19, 31 taglib 54, 55, 144, 176 TAN 92 TCP/IP 44 td 19 TeraTerm 75 TEXT 62 text-align 29, 32 text-decoration 32 text/css 28 this 149 throw 152 th 19 TIMEDIFF 92 TIMESTAMP 62 timestyle 145 title 23 Tomcat 9, 172 (GNU/Linux) 202 (Mac OS X) 210 (Windows) tostring 50 TreeMap 164 TreeSet 164 TRIM 91 TRUNCATE 68, 82, 92 try 152 tr 19 type 40, 145 U UCS 167, 168 UCS Transformation Format see UTF ul 18 UML 147, 151 UNHEX 91 Unicode 167, 168, 170, 171 Unicode 168 Unihan Database Search Page 170 UNION 98 UNION ALL 98 Universal multi-octet coded Character Set see UCS Unix 84 UPDATE 67, 112 URI 175 URL 42 url-patterl 133 USE 60 usebodyencodingforuri 176 UTF-16 24, 167 UTF-8 9, 24, 167, 171, 179 UTF-8N 83, 179 V value 40 VAR_POP 93 VAR_SAMP 93 VARCHAR 62 VARCHAR2 62 View 129 view 134 View Source Chart 181 visibility see visibility 32 VLOOKUP 84 VMware Server 198 W W3C 35 Web see Web Developer 180 Web Server see Web Tools Platform see WTP web-app 126 web.xml 126, 133, 172 Web 11 WHERE 65 width 29, 32 Wikipedia 175 Windows Vista 178 Windows XP 178 Windows-31J 4, 9, 75, , 173 windows-31j 169 WORA 2 World Wide Web see Write Once, Run Anywhere see WORA WTP 8, WWW see X XAMPP (Windows) 187 (GNU/Linux)

50 (Mac OS X) 208 (Windows) XHTML XHTML 1.0 Strict 23, 195 XHTML 1.0 Transitional 195 xml-stylesheet 28 XML 46 XML 24 XML 106 XSS see xyzzy 179 Z z-index 32 Zero Width No-Break Space see ZWNBS zsh 208 ZWNBS , , see see ě , 179, (Firefox) see cookie 29, , C 147, see UCS Pro-VI (SQL) see Controller

51 60 (Tomcat) see Servlet 46 see EL see ER 58 17, 20, , , , 79 Java 153 MySQL , 104 MySQL 185 XAMPP see session , 25, HTML 25 GNU/Linux 13 Mac OS X GNU/Linux 200 Mac OS X 207 Windows RDBMS , see DBMS see web.xml (XHTML) , MySQL 185 XAMPP see \ 199 see padding see View HTML 19 RDB see JSTL 223

52 , , , , 194 (Eclipse) see Properties Editor (HTTP) Java 147 SQL see border see margin , 167 HTML 24 Java 169 MySQL 74 Wikipedia (Slax) see Model CD 13, see RDB see RDBMS (Tomcat) (Eclipse)

ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3

Web 2.0 Web Web Web Web Web Web Web I II I ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3 1. 1.1 Web... 1 1.1.1... 3 1.1.2... 3 1.1.3... 4 1.2... 4 I 2 5 2. HTMLCSS 2.1 HTML...