思特其面试笔试总结（Stewart the interview summary）.docVIP

思特其面试笔试总结（Stewart the interview summary） JSP: 1, doGet () and doPost () distinguish 2, doGet () Chinese garbled solution 3, Unix file copy a.txt, the next 10 lines to b.txt 4, Unix, A (10.11.25.21), B (11.21.22.32) copies the A in the /data/usr/a.txt to the /usr b.txt in the B server 5, 6, window.showmodaldialog () and window.open () distinguish Window.open () opens an ordinary window that seems unable to set custom return values Window.showModalDialog () opens a modal dialog box, that is, when the window opens, the parent window will not work. A parent can pass arguments to a child, and a child can also pass a return value to the parent 7, window.showmodaldialog () open the window, the page does not refresh the solution This.button.Attributes[onclick = = var obj = showModalDialog (outputchakan.htm, verbose information, dialogWidth:620px; dialogHeight:520px; help:0;; status:0; resizeable:1); return, false;; 8, AJAX common problems and Solutions 9, AJAX, several callback Ajax requests, a total of eight Callback 10, the common Ajax framework (the best used, or the interview to ask) Data base: 11, Forgot to write SQL 12, This one and that one Chinese 8586 Math 6365 Foreign language 9096 Chinese, math, foreign languages Zhang San 856390 Li four, 866596 Select Chang three name, Sum (case, when, a=, end, then, B, else,0, language) language, Sum (case, when, a=, math, then, end, B, else,0, etc.) mathematics, Sum (case, when, a=, end, then, B, else,0, foreign language) From (select subjects a, Zhang three , B, Li four, C from dual Union Select ` language , a,85, B,86, C, from, dual Union Select Math, a,63, B,65, C, from, dual Union Select foreign language, a,90, B,96, C, from, dual) La Union all Select Li four name, Sum (case, when, a=, end, then, C, else,0, language) language, Sum (case, when, a=, math, then, end, C, else,0, etc.) mathematics, Sum (case, when, a=, end, then, C, else,0, foreign language) From (select subjects a, Zhang three , B, Li four, C from dual Union S