Questions for students (one question per day)

August 24: How to Implement linked list using Java;

August 25: compile a method to determine the number of times a string appears in another string;

April August 26: Write SQL statements

The table structure is as follows:

Sid (student ID) CID (course number) S (score)

0011 1 77

0011 2 78

0011 3 68

0012 1 70

...

 

Three courses are known, with course Numbers: 1, 2, 3

 

The query result is:

Sid course 1 score course 2 score course 3 score

0011 77 78 68

0012 70 60 80

...

 

April August 27: compile a method to verify that the string entered by the user is a valid date. The required date format is 1988-10-11.

December August 28: compile a method to sort integers.