编写代码,当鼠标划过文本框,自动选中文本框中的内容。 3.将字符09转换成十进制数字。 4.将1234567890转换成1,234,567,890 每3位用逗号隔开的形式。 5.关于HTML和CSS的,忘记了。 6.在文本框中输入一个年份,判断其生肖,并输出在文本框旁边。 对html和javaServlet都要求写出。 7.Ajax从服务器取数据 {id:123, name:"baidu", username:"mm",checked:true}; 分析name对应的值("baidu").(题目较长,不记得了) 8.谈关于客户体验的问题。 第二部分: 1.Ajax,数据库触发器,GUI,中断机制的共同思想。谈一谈该种思想(机制)。 2.把一篇英文文档中所有单词的首字母转为大写,文档存在doc.txt中。可以在多种编程语言中选择(C\C++,JAVA,PHP...)写出你的思路,尽量优化你的程序。 3.关于树的数据结构. 4.数据库优化: 有一个表 PRODUCT(ID,NAME,PRICE,COUNT); 在执行一下查询的时候速度总是很慢: SELECT * FROM PRODUCT WHERE PRICE=100; 在price字段上加上一个非聚簇索引,查询速度还是很慢。 (1)分析查询慢的原因。 (2)如何进行优化。 5.CREATE TABLE topid{ topicId int not null primary key auto_increment, title text, author varchar(30), content blob, isDeleted int ...... //好像在author上定义了一个索引 } CREATE TABLE reply{ topicId int foreign key, replyId int primary key auto_increment, replyAuthor varchar(30), replyTime datetime, context blob ....... //定义了一个索引和key } 一个为主题表,一个为回复表。 1.问从性能上考虑,这样做有什么不足。 2.查询回复时间不超过一个特定的时间段,回复的作者名字以MIKE开头的主题 的title,以如下的查询: select * from topic where replyid in (select replyid from reply where replyAuthor like 'mike%' and (currentTime()-replyTime 从性能上考虑上述的查询语句有什么不足? 如何进行优化? 【公司面试题之:Yahoo! PHP 笔试题】 1. Which of the following will not add john to the users array? 1). $users[] = 'john'; 2). array_ add($users,'john'); 3). array_push($users,'john'); 4). $users ||= 'john'; 2. What's the difference between sort(), asort() and ksort? Under what circumstances would you use each of these? 3. What would the following code print to the browser? Why? $num = 10; function multiply(){ $num = $num * 10; } multiply(); echo $num; 4. What is the difference between a reference and a regular variable? How do you pass by reference &; why would you want to? 5. What functions can you use to add library code to the currently running script? 6. What is the difference between foo() &; @foo()? 7. How do you debug a PHP application? 8. What does === do? What's an example of something that will give true for '==', but not '==='? 9. How would you declare a class named “myclass” with no methods or properties? 10. How would you create an object, which is an instance of “myclass”? 11. How do you access and set properties of a class from within the class? 12. What is