每日一练(20171109)

一、	Java
数组(Array)和列表(ArrayList)有什么区别？什么时候应该使用Array而不是ArrayList？
Array是数组，ArrayList是List集合，数组定义需要定义固定的长度，而ArrayList不需要定义长度，长度会随着添加的内容增加而增加
二、	MySql编程题
表名 students
 
查询出只选修了一门课程的全部学生的学号和姓名
Select  username,id from students where count(course)=1group  by username
三、	Js编程题
输入某年某月某日，判断这一天是这一年的第几天？
var i;
var j;

function check(a,b,c){
	if(a%400==0){
		i=1;
	}else if(a%4 == 0 && a%100!=0){
		i=1;
	}else{
		i=2;
	}
	if(i==1){
		switch(b){
			case 1:
			j=c;
			break;
			case 2:
			j=31+c;
			break;
			case 3:
			j=31+29+c;
			break;
			case 4:
			j=31+29+31+c;
			break;
			case 5:
			j=31+29+31+30+c;
			break;
			case 6:
			j=31+29+31+30+31+c;
			break;
			case 7:
			j=31+29+31+30+31+30+c;
			case 8:
			j=31+29+31+30+31+30+31+c;
			break;
			case 9:
			j=31+29+31+30+31+30+31+31+c;
			break;
			case 10:
			j=31+29+31+30+31+30+31+31+30+c;
			break;
			case 11:
			j=31+29+31+30+31+30+31+31+30+31+c;
			break;
			case 12:
			j=31+29+31+30+31+30+31+31+30+31+30+c;
			break;
		}
		document.write(j);
	}else if(i=2){
		switch(b){
			case 1:
			j=c;
			break;
			case 2:
			j=31+c;
			break;
			case 3:
			j=31+28+c;
			break;
			case 4:
			j=31+28+31+c;
			break;
			case 5:
			j=31+28+31+30+c;
			break;
			case 6:
			j=31+28+31+30+31+c;
			break;
			case 7:
			j=31+28+31+30+31+30+c;
			break;
			case 8:
			j=31+28+31+30+31+30+31+c;
			break;
			case 9:
			j=31+28+31+30+31+30+31+31+c;
			break;
			case 10:
			j=31+28+31+30+31+30+31+31+30+c;
			break;
			case 11:
			j=31+28+31+30+31+30+31+31+30+31+c;
			break;
			case 12:
			j=31+28+31+30+31+30+31+31+30+31+30+c;
			break;
		}
		document.write(j);
	}
}