/var/lib/sharelatex/data/compiles/5b35c6e168aeba3d a72a7acd11f6ba07fbbff68/output.dvi

Size: px

Start display at page:

Download "/var/lib/sharelatex/data/compiles/5b35c6e168aeba3d a72a7acd11f6ba07fbbff68/output.dvi"

ゆあかわらい
5 years ago
Views:

1 SuperSQL SSedit SSedit ssql FROM WHERE (image ) (link FOREACH ) URL (anchor ) ( ) asc desc null SQL

2 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 (ua ) /public html/ssql SuperSQL HTML /public html/ssql /ssql/xxxx.html URL ua test.ssql ssql ua012345/ssql/test.html URL SSedit ( ) ua012345% ssedit 2

3 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

4 (!) : Name! Tel (%) : Name % Tel ([ ]) ( [ ], ) ( ) Q1.ssql [e.name! e.byear], ( [ ]! ) ( ) Q2.ssql [e.name, e.byear]!

5 4.3 Q3.ssql [d.name]!, [i.name]!, [i.price]! FROM item i, dept d WHERE i.dept = d.id g 3295 Q4.ssql [d.name![i.name, i.price]!]! FROM item i, dept d WHERE i.dept = d.id 300g g Q5.ssql e.name 3 5

6 [ 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

7 2 : {, Name}! {, Tel} 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

8 : 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

9 ; 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 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

10 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}]! (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

11 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 titles.ssql film.ssql actor.ssql theater.ssql town.ssql link FOREACH (%) FOREACH 5MB link FOREACH link1 FOREACH1 link1 FOREACH1 (Q13.ssql e.id ) 11

12 7.2 URL (anchor ) anchor anchor a anchor( URL) a( SuperSQL, ) image anchor image_anchor( PATH, URL ) img_a( icon/ssql.png, ) 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

13 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]! (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 / Q18.ssql 13

14 (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 /* demo.css } --,shop s 10 db-ta18@db.ics.keio.ac.jp (24-205,209) SuperSQL Tutorial SuperSQL 14

3 3.1 SSedit ua012345% ssedit SuperSQL config.ssql log.txt( logs.txt) SSedit SSedit 3.2 ssql Putty SSedit ua012345% ssql HTML /public html/ssql.ssql 4

3 3.1 SSedit ua012345% ssedit SuperSQL config.ssql log.txt( logs.txt) SSedit SSedit 3.2 ssql Putty SSedit ua012345% ssql HTML /public html/ssql.ssql 4 SuperSQL SuperSQL 2016 12 13 1 SuperSQL ITC 2 SuperSQL 2.1 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/