恒生校招java笔试数据库语法_2015恒生电子校招笔试题

一、不定项选择题

1、B  C错是因为编译后还需要链接，D函数可以单独编译，编译成目标文件

2、

3、D

4、CD

5、

6、B

7、

(1)C

(2)A

8、D

9、

10、ABCD

二、JAVA语言部分

1、B

2、C

3、AB  char型用'\u四位的16进制'表示也是正确的

4、AB

5、AB,B

三、数据库

create table S(

Sno int primary key auto_increment,

Sname varchar(20)

);

insert into S(sname) values('he');

insert into S(sname) values('wang');

create table C(

Cno int primary key auto_increment,

Cname varchar(20),

Ccredit int

);

insert into C(cname,Ccredit) values('JAVA',3);

insert into C(cname,Ccredit)  values('C',2);

Drop table if exists SC;

create table SC(

id int primary key auto_increment,

Sno int,

Cno int,

Grade int

);

insert into SC(Sno,cno,Grade) values(1,1,100);

insert into SC(Sno,cno,Grade) values(1,2,90);

insert into SC(Sno,cno,Grade) values(2,1,80);

insert into SC(Sno,cno,Grade) values(2,2,70);

insert into SC(Sno,cno,Grade,Teacher) values(3,1,80,'zhang');

insert into SC(Sno,cno,Grade,Teacher) values(3,2,70,'zhang');

1)select distinct Sname From S,SC,C where S.sno = SC.sno and c.Cno = SC.cno and

Cname='JAVA' order by Sname desc;

2)select S.Sno,Sum(Ccredit) From S,SC,C where S.sno = SC.sno and c.Cno = SC.cno

and Grade>60 group by Sno having sum(Ccredit)>80;

3)ALTER table SC ADD Teacher varchar(20) not null;

4)CREATE VIEW SCSum(sno,Ccredit) as Select S.Sno,Sum(Ccredit)  From S,SC,C

where S.sno = SC.sno and c.Cno = SC.cno group by Sno;

5)delete from SC where sno not in(select distinct S.Sno from S);

四、编程题

1、

packagehengsheng;importjava.util.Scanner;public classExe3 {public static voidmain(String[] args) {

Date date= new Date(2015,8,25);

System.out.println(days(date));

}static intdays(Date date){int day = 0;int[][] month = new int[][]{{31,28,30,31,30,31,31,31,30,31,30,31},{31,29,30,31,30,31,31,31,30,31,30,31}};int m =isrunYear(date.getYear());for(int i=0;i

day+=month[m][i];

}

day+=date.getDay();returnday;

}static int isrunYear(intyear) {if (year % 4 == 0 && year % 100 != 0 | year % 400 == 0)return 0;return 1;

}

}classDate {intyear;intmonth;intday;public Date(int year, int month, intday) {super();this.year =year;this.month =month;this.day =day;

}public intgetYear() {returnyear;

}public void setYear(intyear) {this.year =year;

}public intgetMonth() {returnmonth;

}public void setMonth(intmonth) {this.month =month;

}public intgetDay() {returnday;

}public void setDay(intday) {this.day =day;

}

}

2、

packagehengsheng;importjava.util.Scanner;public classExe2 {public static voidmain(String[] args) {

Scanner scanner= newScanner(System.in);int n =scanner.nextInt();while (n != 1) {for (int i = 2; i<=n; i++) {if(isPrime(i)) {//如果i为素数

if (n % i == 0) {//如果n能被i整数

n = n /i;

System.out.print(i+ " ");break;

}

}

}

}

}/*** 判断是否是素数

*

*@paramnum

*@return

*/

static boolean isPrime(intnum) {for (int i = 2; i <= num / 2; i++)if (num % i == 0)return false;return true;

}

}