day7/14

Hashmap

Hashmap特点
//1.key-value形式
//2.集合里面数据是无序的
//3.key不能重复，value可以重复
//数组的特点
//1.规定数据类型
//2.规定数据长度
//有序

	//ArrayList的特点
	//数据类型不固定，长度不固定   有序

import java.util.HashMap;

public class MapTest {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//Hashmap特点
		//1.key-value形式
		//2.集合里面数据是无序的
		//3.key不能重复，value可以重复
		
		//数组的特点
		//1.规定数据类型
		//2.规定数据长度
		//有序
		
		//ArrayList的特点
		//数据类型不固定，长度不固定   有序
		
			HashMap map=new HashMap();
			map.put("aa", 11);
			map.put("bb", "阿双方都是");
			//通过key获取value
			System.out.println(map.get("aa"));
			
	}

}

sql

use java10;

alter table student add subject varchar(10) null;

select * from student;

update student set subject = ‘语文’;

insert into student (name,id,score,classname,subject)
values (‘是的发’,‘1’,‘44’,‘Java10’,‘英语’);

insert into student (name,id,score,classname,subject)
select name,id,score,classname,'数学’from student where subject=‘语文’;
select avg(score) from student where classname = ‘java10’;
select avg(score) from student where classname = ‘java10’ group by subject;

– 每班语文成绩大80人数
select count() ,classname
from student
where subject =‘语文’ and score >80 group by classname;
– 查询优秀人数大于1的班级
– where 和 having 的区别？1，分组以后再过滤只能用having ,group by后面只能用having
– where用于表名的后面，用来过滤查询结果
select count() ,classname
from student
where subject =‘语文’ and score >80
group by classname having count(*)>1;
– 排序

select * from student where classname=‘java10’
and subject=‘语文’ order by score;

select * from student where classname=‘java10’
and subject=‘语文’ order by score desc;