努力打卡 每天学习 不浪费每一天 Day61

约瑟夫环问题

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class 约瑟夫环问题 {
    public static void main(String[] args) {
        Scanner sc=new Scanner(System.in);
        int n=sc.nextInt();
        int m=sc.nextInt();
        sovle(n,m);
    }

    private static void sovle(int n, int m) {
        List<Integer> list=new ArrayList<>();
        for (int i = 1; i <= n; i++) {
            list.add(i);
        }
        int count=1;
        for(int i=0;list.size()!=1;i++){
            if(i==list.size()){
                i=0;
            }
            if(count%m==0){
                System.out.println(list.get(i));
                list.remove(i--);
                System.out.println(list);
            }
            count++;
        }
    }
}

---

DQL基础查询

 

INSERT INTO stu(id,NAME,age,sex,address,math,english,hire_date)
VALUES
(1,'马斯克',55,'男','天津',66,78,'1995-09-01'),
(2,'马',45,'男','北京',90,89,'1995-05-01'),
(3,'马克',25,'男','福建',91,59,'1996-02-01'),
(4,'德玛西亚',18,'男','武汉',55,52,'1999-03-01');

SELECT * from stu;

-- 基础查询========

-- 查询 name age两列
select name,age from stu;

-- 查询所有列的数据

select address from stu;
-- 去重
select DISTINCT address from stu;
-- 全部查询
select * from stu;
-- 起别名
select id AS 学号,name AS 名字 from stu;

条件查询

 

 

-- 如果英语为null 变成0
SELECT NAME,math 数学,english 英语,math+IFNULL(english,0) 总分 from stu;

SELECT * FROM stu WHERE age<=30 And age>=20;
SELECT * FROM stu WHERE age BETWEEN 20 and 30;
SELECT * FROM stu WHERE age=20 OR age=22 OR age=45;
SELECT * FROM stu WHERE age IN(20,22,45);
-- null值不能使用等号去判断
SELECT * FROM stu WHERE english is NULL;
SELECT * FROM stu WHERE english is NOT NULL;

 

---

成为大佬不是一朝一夕的  准备接下来边学习数据结构边学习MySQL  加油!

2022-10-14 00:57:57