匿名网友
北京麦吉斯特，java开发工程师，不过笔试的题跟java关系不大，我把记得的最后两道大题写出来。
javascript创建简历
<HTML>
<HEAD>
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
<TITLE>田本真的简历</TITLE>
</HEAD>
<BODY>
<script type=”text/javascript” language=”JavaScript”>
function printvalue() {
var print_string = “”;
for (var prop in this)
{
if (prop != “printvalue”) {
print_string = print_string + “<option value=” + this[prop] + “>” + prop + “</option>”;
}
}
return print_string;
}
function obj(name, age, sex, address){
this.name = name;
this.age = age;
this.sex = sex;
this.address = address;
this.printvalue = printvalue;
}
function schange(sobi) {
win = window.open(“a.html”,”newwindow”,”width=300,height=200″);
var s = “您选择的 ” + sobj.options[sobj.selectedIndex].text + ” 属性，其值为 ” + sobi.value;
win.document.write(s);
}
var newguy =new obj(“田本真”,”24″,”男”,”北京市海淀区清河镇”);
document.write(“<select name=’a’ onchange=’schange(this)’>”);
document.write(newguy.printvalue());
document.write(“</select>”);
</script>
</BODY>
</HTML>
CREATE table register(id int(7),
name varchar(3),
regedate date);
CREATE table t3 (id int(7),
name2 varchar(3));
1.统计表register中每个月的注册人数；
select sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 1 then 1 else 0 end) ‘2008年1月’,
sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 2 then 1 else 0 end) ‘2008年2月’,
sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 3 then 1 else 0 end) ‘2008年3月’,
sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 4 then 1 else 0 end) ‘2008年4月’,
sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 5 then 1 else 0 end) ‘2008年5月’,
sum(case when date_format(regedate,’%Y’) = 2008 and date_format(regedate,’%c’) = 6 then 1 else 0 end) ‘2008年6月’
from register;
2.查出表register中有相同name的数据的条数；
select COUNT(name) FROM (SELECT count(id) c,name from register GROUP BY name) d where d.c > 1;
3.把表register中存在相同name的数据的name值插入到表t3中；
insert into t3(name2) (select name FROM (SELECT count(id) c,name from register GROUP BY name) d where d.c > 1 );
4.表register中id字段可能有多个相同，name字段也可能有多个相同，存在name相同的数据要保留表中注册时间最大的那一条，其余删除。
delete rg from register rg,
(select r,name FROM (SELECT max(regedate) r,count(id) c,name from register GROUP BY name) d where d.c > 1) e
where rg.name = e.name and rg.regedate != e.r;
