SuperSQL 2018 7 5 1 2 2 2 2.1.................................... 2 2.2 SSedit....................................... 2 3 2 3.1 SSedit..................................... 2 3.2 ssql................................. 3 4 3 4.1.......................................... 3 4.2.......................................... 4 4.3..................................... 5 4.4....................................... 5 4.5...................................... 6 4.6 FROM WHERE................................ 7 5 7 5.1.................... 9 6 (image ) 10 7 10 7.1 (link FOREACH ).................... 10 7.2 URL (anchor )......................... 12 8 ( ) 12 8.1 asc desc........................................ 12 8.2 null......................................... 13 9 13 9.1......................................... 13 9.2......................................... 13 9.3 SQL....................................... 14 9.4......................................... 14 10 14 1
1 SuperSQL ITC 2 SuperSQL 2.1 public html/ssql HTML SQL sql ssql ( ) ( /SQL) ( /public html/ssql) 2.2 SSedit SSedit (3.1 ) postgresql (ua123456 ) 131.113.101.124 /public html/ssql SuperSQL HTML /public html/ssql http://user.keio.ac.jp/ /ssql/xxxx.html URL ua012345 test.ssql ssql http://user.keio.ac.jp/ ua012345/ssql/test.html URL 3 3.1 SSedit ( ) ua012345% ssedit 2
SuperSQL config.ssql log.txt( logs.txt) SSedit SSedit 3.2 ssql ( Putty SSedit ) ua012345% ssql HTML /public html/ssql.ssql 4 SuperSQL SQL SELECT GENERATE< media >< TFE > GENERATE < media > HTML PDF Excel L A TEX HTML < TFE > Target Form Expression 4.1 (,) (!) (%) 3 (,) : Name, Tel 03-1111 - 2222 3
(!) : Name! Tel 03-1111 - 2222 (%) : Name % Tel 03-1111 - 2222 4.2 ([ ]) ( [ ], ) ( ) Q1.ssql [e.name! e.byear], 1978 1980 1990 ( [ ]! ) ( ) Q2.ssql [e.name, e.byear]! 1978 1980 1990 4
4.3 Q3.ssql [d.name]!, [i.name]!, [i.price]! FROM item i, dept d WHERE i.dept = d.id 198 800 300g 3295 Q4.ssql [d.name![i.name, i.price]!]! FROM item i, dept d WHERE i.dept = d.id 300g 500 600g 800 3000 6000 4.4 Q5.ssql e.name 3 5
[ TFE ],number! number [name],5! [ TFE ]!number, number [name]!5, [ TFE ],number% number [name],5% [ TFE ]!number% number [name]!5% [ TFE ],number1!number2% number1 [name],5!4% number2 [ TFE ]!number1,number2% number1 [name]!5,4% number2 Q5.ssql [e.name],3! Q6.ssql e.name e.salary 3 5 Q6.ssql [e.name, e.salary],3!5% 4.5 SuperSQL TFE 1 :! [Name]! 6
2 : {, Name}! {, Tel} 03-1111 - 2222 4.6 FROM WHERE SuperSQL FROM WHERE SQL FROM dept d, store s WHERE d.store = s.id 5 SuperSQL ( ) <TFE>@{ < > } =, : width (px) : width=200 : height (px) : height=20 ( ): padding (px) : padding=2 : align(left/center/right) : align= left : valign(top/center/bottom) : valign= top : background-color, bgcolor( : bgcolor= red /bgcolor= FF0000 : color, font-color : color= red /color= FF0000 : size, font-size(px) : font-size=20 : font-weight : font-weight= bold 7
: font-style : font-style= italic CSS : style : style= font-variant: small-caps; font-weight: 900 CSS Java Script : class : class= item CSS Java Script ) id : id : id= item : table-align, talign :table-align= center Name@{align= center, font-color= blue, font-size= 20} width 100px 200px 300px 300px [ A, B ]! [ A@{width= 100}, B@{width= 200}]! 300px [ {A@{width=100},B@{width=200}}@{width=300}]! 100,200px 300px : cssfile : cssfile= demo.css CSS CSS CSS cssfile= demo1.css, demo2.css CSS JavaScript : jsfile : jsfile= demo.js js CSS 8
; charset : charset= utf-8 : author : author= takehiko : background : background= neko.gif :page-bgcolor, pbgcolor :page-bgcolor= red : table-align : table-align= center : tableborder : tableborder=1 Q7.ssql { { [e.name@{class= name },e.salary@{class= salary }, e.byear@{class= birth }]! }@{title= MEMBER,table-align= center } }@{cssfile= demo.css,charset= euc-jp } Q7.ssql css cssfile= demo.css demo.css demo.css http://ssql.db.ics.keio.ac.jp/demo.css 5.1 HTML dept color bgcolor color (Yellow ) Q8.ssql [(asc)d.floor, d.name@{bgcolor = dc.fcolor}]! FROM dept d, deptcolor dc WHERE dc.floor = d.floor 2 asc 8 9
6 (image ) image image(, ) path SuperSQL HTML ( /public html/ssql) image width 755 : 200 ( pict /public html/ssql/picts/ ) Q9.ssql [e.name, image(e.pict,./picts )@{width=200}]! 7 7.1 (link FOREACH ) link FOREACH (%) (%) link FOREACH link FOREACH (%) Q10.ssql Q10.ssql [e.name % {e.salary, e.syear}]! link FOREACH Q11.ssql Q12.ssql Q11.ssql [link(e.name, Q12.ssql, e.id)]! 10
Q12.ssql FOREACH e.id [e.salary, e.syear]! Q11.ssql Q12.ssql link FOREACH link FOREACH URL ( ) 2 ( 2 ) link FOREACH (,) FOREACH link null NO DATA FOUND link FOREACH link FOREACH link link Q13.ssql [link(e.name@{target= _new }, Q12.ssql, e.id)]! link FOREACH http://ssql.db.ics.keio.ac.jp/demo/link/index.html titles.ssql film.ssql actor.ssql theater.ssql town.ssql http://ssql.db.ics.keio.ac.jp/demo/link/titles.html link FOREACH (%) FOREACH 5MB link FOREACH link1 FOREACH1 link1 FOREACH1 (Q13.ssql e.id ) 11
7.2 URL (anchor ) anchor anchor a anchor( URL) a( SuperSQL, http://ssql.db.ics.keio.ac.jp/ ) image anchor image_anchor( PATH, URL ) img_a( icon/ssql.png, http://ssql.db.ics.keio.ac.jp/ ) 8 ( ) 8.1 asc desc SuperSQL asc desc (ascending order): (asc) id : (asc)e.id (descending order): (desc) : (desc)e.salary id Q14-1.ssql [(asc)e.salary, (desc)e.id, e.name]! Q14-2.ssql [(asc1)e.salary, (desc2)e.id, e.name]! id Q15.ssql 12
Q15.ssql [ (asc)d.id, [ (desc)e.id,e.name]! ]! FROM dept d, employee e WHERE d.manager=e.manager 8.2 null null Q16.ssql [null((desc1)e.salary), e.name]! 9 9.1 (max) (min) (avg) (sum) (count) max[ ], min[ ], avg[ ], sum[ ], count[ ] Q17.ssql avg max min Q17.ssql [ e.name ]!, avg[e.salary] 9.2 SuperSQL TFE +, -, /, *, % Q18 e.salary / 113 113 Q18.ssql 13
(1 =113 ) [e.id, e.name, (e.salary / 113) ]! 9.3 SQL SuperSQL DBMS & SQL SuperSQL REPLACE Q19.ssql [e.name, &replace(e.name,, )]! 9.4 SuperSQL /* */ --( 2 ) --( 2 ) Q20.ssql { [e.name /*@{class= name }*/, e.salary]! }/*@{cssfile= demo.css }*/ --,shop s /* */ @{cssfile= demo.css } --,shop s 10 db-ta18@db.ics.keio.ac.jp (24-205,209) SuperSQL http://ssql.db.ics.keio.ac.jp/tutorial/ Tutorial SuperSQL 14