题目:判断101-200之间有多少个素数,并输出所有素数。
public class Demo { public static void main(String[] args) { // TODO Auto-generated method stub int count = 0; for (int i = 101; i < 200; i += 2) { boolean b = false; for (int j = 2; j <= i; j++) { if (i % j == 0) { b = false; break; } else { b = true; } } if (b == true) { count++; System.out.println(i); } } System.out.println("素数个数是: " + count); } }
|
Student表的定义
字段名 | 字段描述 | 数据类型 | 主键 | 外键 | 非空 | 唯一 | 自增 |
Id | 学号 | INT(10) | 是 | 否 | 是 | 是 | 是 |
Name | 姓名 | VARCHAR(20) | 否 | 否 | 是 | 否 | 否 |
Sex | 性别 | VARCHAR(4) | 否 | 否 | 否 | 否 | 否 |
Birth | 出生年份 | YEAR | 否 | 否 | 否 | 否 | 否 |
Department | 院系 | VARCHAR(20) | 否 | 否 | 是 | 否 | 否 |
Address | 家庭住址 | VARCHAR(50) | 否 | 否 | 否 | 否 | 否 |
Score表的定义
字段名 | 字段描述 | 数据类型 | 主键 | 外键 | 非空 | 唯一 | 自增 |
Id | 编号 | INT(10) | 是 | 否 | 是 | 是 | 是 |
Stu_id | 学号 | INT(10) | 否 | 否 | 是 | 否 | 否 |
C_name | 课程名 | VARCHAR(20) | 否 | 否 | 否 | 否 | 否 |
Grade | 分数 | INT(10) | 否 | 否 | 否 | 否 | 否 |
Student数据:
Score数据:
-- 创建student和score表 DROP TABLE IF EXISTS Student; CREATE TABLE Student( Id INT(10) PRIMARY KEY auto_increment, Name VARCHAR(20) NOT NULL, Sex VARCHAR(4), Birth YEAR, Department VARCHAR(20) NOT NULL, Address VARCHAR(50) ); DROP TABLE IF EXISTS Score; CREATE TABLE Score( Id INT(10) PRIMARY KEY auto_increment, Stu_id INT(10) NOT NULL, C_name VARCHAR(20), Grade INT(10) );
-- 为student表和score表增加记录 INSERT INTO Student values(901,"张老大","男",1985,"计算机系","北京市海淀区"); INSERT INTO Student values(902,"张老二","男",1986,"中文系","北京市昌平市"); INSERT INTO Student values(903,"张三","女",1990,"中文系","海南省永州市"); INSERT INTO Student values(904,"李四","男",1990,"英语系","辽宁省阜新市"); INSERT INTO Student values(905,"王五","女",1991,"英语系","福建省厦门市"); INSERT INTO Student values(906,"王六","男",1988,"计算机系","湖南省衡阳市");
INSERT INTO Score VALUES(id,901,"计算机",98); INSERT INTO Score VALUES(id,901,"英语",80); INSERT INTO Score VALUES(id,902,"计算机",65); INSERT INTO Score VALUES(id,902,"中文",88); INSERT INTO Score VALUES(id,903,"中文",95); INSERT INTO Score VALUES(id,904,"计算机",70); INSERT INTO Score VALUES(id,904,"英语",92); INSERT INTO Score VALUES(id,905,"英语",94); INSERT INTO Score VALUES(id,906,"计算机",90); INSERT INTO Score VALUES(id,906,"英语",85);
-- 查询student表的所有记录 SELECT * FROM Student;
-- 查询student表的第2条到4条记录 SELECT * FROM Student LIMIT 1,3;
-- 从student表查询所有学生的学号(id)、姓名(name)和院系(department)的信息 SELECT id,name,department FROM Student;
-- 从student表中查询计算机系和英语系的学生的信息 SELECT * FROM Student WHERE department in("计算机系","英语系");
-- 从student表中查询年龄28~31岁的学生信息 SELECT * FROM Student WHERE 2017-Birth between 28 AND 31;
-- 从student表中查询每个院系有多少人 SELECT department,count(id) "人数" FROM Student GROUP BY department;
-- 从score表中查询每个科目的最高分 SELECT C_name,max(Grade) "最高分" FROM Score GROUP BY C_name;
-- 查询李四的考试科目(c_name)和考试成绩(grade) SELECT C_name,Grade FROM Score WHERE Stu_id = ( SELECT id FROM Student WHERE Name = "李四" );
-- 用连接的方式查询所有学生的信息和考试信息 select * FROM Student LEFT JOIN Score on Student.id = Score.Stu_id;
-- 计算每个学生的总成绩 SELECT Name,sum(Grade) "总成绩" FROM Student LEFT JOIN Score on Student.id = Score.Stu_id GROUP BY Name;
-- 计算每个考试科目的平均成绩 SELECT C_name,avg(Grade) FROM Score GROUP BY C_name;
-- 查询计算机成绩低于95的学生信息 SELECT * FROM Student WHERE id in( SELECT Stu_id FROM Score WHERE C_name = "计算机" AND Grade<95 );
-- 查询同时参加计算机和英语考试的学生的信息 SELECT * FROM Student WHERE id in ( SELECT Stu_id FROM Score where C_name="英语" AND Stu_id in( SELECT Stu_id FROM Score where C_name="计算机" ) );
-- 将计算机考试成绩按从高到低进行排序 SELECT Grade FROM Score WHERE C_name="计算机" ORDER BY Grade DESC;
-- 从student表和score表中查询出学生的学号,然后合并查询结果 SELECT id FROM Student UNION SELECT Stu_id FROM Score;
-- 查询姓张或者姓王的同学的姓名、院系和考试科目及成绩 select Name,Department,C_name,Grade FROM Student LEFT JOIN Score on Student.id = Score.Stu_id WHERE NAME LIKE "张%" or NAME LIKE "王%";
-- 查询都是湖南的学生的姓名、年龄、院系和考试科目及成绩 select Name,2017-Birth "年龄",Department,C_name,Grade FROM Student LEFT JOIN Score on Student.id = Score.Stu_id WHERE Address LIKE "湖南%"; |
页面上输入一个年份(需验证),判断是否是闰年(能被4整除却不能被100整除的年份;能被400整除的是闰年),需在页面上显示提示信息。
<!doctype html> <html> <head> <title>闰年</title> <meta charset="utf-8"> </head> <body> <form> 请输入年份:<input id="year" type="text"/> <span id="check"></span> </form>
<script> var input = document.getElementById("year"); var tip = document.getElementById("check"); //输入框失去焦点触发事件 input.onblur = function(){ var year = input.value.trim(); //年份由4位数字组成 if(/^\d{4}$/.test(year)){ //能被4整除却不能被100整除的年份;能被400整除的是闰年 if((year%4==0&&year%100!=0)||(year%400==0)){ tip.innerHTML = "闰年"; }else{ tip.innerHTML = "非闰年"; } }else{ tip.innerHTML = "年份格式不正确请重新输入"; } } </script> </body> </html> |