我的面试宝典:一线互联网大厂Java核心面试题库
以下是我个人的一些做法,希望可以给各位提供一些帮助:
整理了很长一段时间,拿来复习面试刷题非常合适,其中包括了Java基础、异常、集合、并发编程、JVM、Spring全家桶、MyBatis、Redis、数据库、中间件MQ、Dubbo、Linux、Tomcat、ZooKeeper、Netty等等,且还会持续的更新…可star一下!
283页的Java进阶核心pdf文档
Java部分:Java基础,集合,并发,多线程,JVM,设计模式
数据结构算法:Java算法,数据结构
开源框架部分:Spring,MyBatis,MVC,netty,tomcat
分布式部分:架构设计,Redis缓存,Zookeeper,kafka,RabbitMQ,负载均衡等
微服务部分:SpringBoot,SpringCloud,Dubbo,Docker
还有源码相关的阅读学习
| version() |
±----------+
| 8.0.22 |
±----------+
1 row in set
##### []( )5\. 打印当前用户
mysql> select user();
±---------------+
| user() |
±---------------+
| root@localhost |
±---------------+
1 row in set
##### []( )6\. 查看系统运行状态的信息
mysql> show global status like ‘Thread%’;
±------------------±------+
| Variable\_name | Value |
±------------------±------+
| Threads\_cached | 2 |
| Threads\_connected | 1 |
| Threads\_created | 3 |
| Threads\_running | 2 |
±------------------±------+
4 rows in set
#### []( )搭建练习环境
说明:
–1.学生表
Student(s\_id,s\_name,s\_birth,s\_sex) –学生编号,学生姓名, 出生年月,学生性别
–2.课程表
Course(c\_id,c\_name,t\_id) – –课程编号, 课程名称, 教师编号
–3.教师表
Teacher(t\_id,t\_name) –教师编号,教师姓名
–4.成绩表
Score(s\_id,c\_id,s\_score) –学生编号,课程编号,分数
**建立学生表:**
mysql> CREATE TABLE Student
(
s_id
VARCHAR(20),
s_name
VARCHAR(20) NOT NULL DEFAULT ‘’,
s_birth
VARCHAR(20) NOT NULL DEFAULT ‘’,
s_sex
VARCHAR(10) NOT NULL DEFAULT ‘’,
PRIMARY KEY(s_id
)
);
Query OK, 0 rows affected
**建立课程表**
mysql> CREATE TABLE Course
(
c_id
VARCHAR(20),
c_name
VARCHAR(20) NOT NULL DEFAULT ‘’,
t_id
VARCHAR(20) NOT NULL,
PRIMARY KEY(c_id
)
);
Query OK, 0 rows affected
mysql>
**建立教师表**
mysql> CREATE TABLE Teacher
(
t_id
VARCHAR(20),
t_name
VARCHAR(20) NOT NULL DEFAULT ‘’,
PRIMARY KEY(t_id
)
);
Query OK, 0 rows affected
**建立成绩表**
CREATE TABLE Score
(
s_id
VARCHAR(20),
c_id
VARCHAR(20),
s_score
INT(3),
PRIMARY KEY(s_id
,c_id
)
);
插入学生表测试数据:
insert into Student values(‘01’ , ‘高胜寒’ , ‘1990-06-01’ , ‘男’);
insert into Student values(‘02’ , ‘高峰’ , ‘1990-2-21’ , ‘男’);
insert into Student values(‘03’ , ‘维度’ , ‘1990-07-20’ , ‘男’);
insert into Student values(‘04’ , ‘李云龙’ , ‘1995-08-06’ , ‘男’);
insert into Student values(‘05’ , ‘沐晨’ , ‘1991-12-01’ , ‘女’);
insert into Student values(‘06’ , ‘舒展’ , ‘1992-03-01’ , ‘女’);
insert into Student values(‘07’ , ‘李白’ , ‘1989-07-01’ , ‘女’);
insert into Student values(‘08’ , ‘白居易’ , ‘1990-01-20’ , ‘女’);
插入课程表测试数据:
insert into Course values(‘01’ , ‘语文’ , ‘02’);
insert into Course values(‘02’ , ‘数学’ , ‘01’);
insert into Course values(‘03’ , ‘英语’ , ‘03’);
insert into Course values(‘04’ , ‘化学’ , ‘04’);
插入教师表数据
insert into Teacher values(‘01’ , ‘张帅’);
insert into Teacher values(‘02’ , ‘李广’);
insert into Teacher values(‘03’ , ‘王浩’);
insert into Teacher values(‘04’ , ‘李强’);
成绩表测试数据
最后
金三银四马上就到了,希望大家能好好学习一下这些技术点
学习视频:
大厂面试真题:
频:
[外链图片转存中…(img-8x7VqUHT-1715588694946)]
大厂面试真题:
[外链图片转存中…(img-tIF9dyGB-1715588694947)]