# javapro **Repository Path**: tk_tk/javapro ## Basic Information - **Project Name**: javapro - **Description**: 这是一个git初始化文件，教学使用 - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2024-05-20 - **Last Updated**: 2024-05-25 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README 一、Git版本控制器综合使用 TK@DESKTOP-1SCHDTC MINGW64 ~ $ git config --global user.name "仰望星海恋你" TK@DESKTOP-1SCHDTC MINGW64 ~ $ git config --global user.email "2045968484@qq.com" TK@DESKTOP-1SCHDTC MINGW64 ~ $ git config user.name 仰望星海恋你 TK@DESKTOP-1SCHDTC MINGW64 ~ $ git config user.email 2045968484@qq.com TK@DESKTOP-1SCHDTC MINGW64 ~ $ cd desktop TK@DESKTOP-1SCHDTC MINGW64 ~/desktop $ cd javapro TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro $ git init Initialized empty Git repository in C:/Users/TK/Desktop/javapro/.git/ TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ touch Student.java StudentDAO.java StudentService.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add . TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git commit -m "提交三个空文件到本地仓库(添加到缓存区)" [master (root-commit) 66d26d9] 提交三个空文件到本地仓库(添加到缓存区) 3 files changed, 0 insertions(+), 0 deletions(-) create mode 100644 Student.java create mode 100644 StudentDAO.java create mode 100644 StudentService.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add Student.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git commit -m "修改添加三个属性和一个构造器到Student.java" [master 375d6ee] 修改添加三个属性和一个构造器到Student.java 1 file changed, 11 insertions(+) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add StudentDAO.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git commit -m "修改添加insert(Students)和selectAll()两个方法定义到StudentDAO.java" [master 629f47d] 修改添加insert(Students)和selectAll()两个方法定义到StudentDAO.java 1 file changed, 14 insertions(+) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add StudentService.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git commit -m "修改添加一行注释到StudentService.java" [master fe91123] 修改添加一行注释到StudentService.java 1 file changed, 3 insertions(+) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git status On branch master nothing to commit, working tree clean TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git reflog fe91123 (HEAD -> master) HEAD@{0}: commit: 修改添加一行注释到StudentService.java 629f47d HEAD@{1}: commit: 修改添加insert(Students)和selectAll()两个方法定义到StudentDAO.java 375d6ee HEAD@{2}: commit: 修改添加三个属性和一个构造器到Student.java 66d26d9 HEAD@{3}: commit (initial): 提交三个空文件到本地仓库(添加到缓存区) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git reset --hard 66d26d9 HEAD is now at 66d26d9 提交三个空文件到本地仓库(添加到缓存区) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git reset --hard fe91123 HEAD is now at fe91123 修改添加一行注释到StudentService.java TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git remote add origin https://gitee.com/tk_tk/javapro.git TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git push -u origin master Enumerating objects: 12, done. Counting objects: 100% (12/12), done. Delta compression using up to 2 threads Compressing objects: 100% (11/11), done. Writing objects: 100% (12/12), 1.53 KiB | 313.00 KiB/s, done. Total 12 (delta 2), reused 0 (delta 0), pack-reused 0 remote: Powered by GITEE.COM [GNK-6.4] To https://gitee.com/tk_tk/javapro.git * [new branch] master -> master branch 'master' set up to track 'origin/master'. TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ cd desktop bash: cd: desktop: No such file or directory TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ cd javapro bash: cd: javapro: No such file or directory TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ touch README.md TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add README.md TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git add . TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git commit -m "提交步骤文档" [master 9217810] 提交步骤文档 1 file changed, 103 insertions(+) create mode 100644 README.md TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git remote add origin http://gitee.com/tk_tk/javapro.git error: remote origin already exists. TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git remote -v origin https://gitee.com/tk_tk/javapro.git (fetch) origin https://gitee.com/tk_tk/javapro.git (push) TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git remote remove origin TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git remote add origin http://gitee.com/tk_tk/javapro.git TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ git push -u origin master warning: redirecting to https://gitee.com/tk_tk/javapro.git/ Enumerating objects: 4, done. Counting objects: 100% (4/4), done. Delta compression using up to 2 threads Compressing objects: 100% (3/3), done. Writing objects: 100% (3/3), 1.30 KiB | 666.00 KiB/s, done. Total 3 (delta 1), reused 0 (delta 0), pack-reused 0 remote: Powered by GITEE.COM [GNK-6.4] To http://gitee.com/tk_tk/javapro.git fe91123..9217810 master -> master branch 'master' set up to track 'origin/master'. TK@DESKTOP-1SCHDTC MINGW64 ~/desktop/javapro (master) $ cd .. TK@DESKTOP-1SCHDTC MINGW64 ~/desktop $ rm -rf javapro TK@DESKTOP-1SCHDTC MINGW64 ~/desktop $ git clone https://gitee.com/tk_tk/javapro.git Cloning into 'javapro'... remote: Enumerating objects: 15, done. remote: Counting objects: 100% (15/15), done. remote: Compressing objects: 100% (14/14), done. remote: Total 15 (delta 3), reused 0 (delta 0), pack-reused 0 Receiving objects: 100% (15/15), done. Resolving deltas: 100% (3/3), done. TK@DESKTOP-1SCHDTC MINGW64 ~/desktop $ 二、MySQL与SQL语句基本使用 -- 创建歌单表 CREATE TABLE playlist ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, tag VARCHAR(50), cover_url VARCHAR(255) ); -- 插入10条数据 INSERT INTO playlist (name, tag, cover_url) VALUES ('歌单1', '流行', 'http://example.com/cover1.jpg'), ('歌单2', '摇滚', 'http://example.com/cover2.jpg'), ('歌单3', '电子', 'http://example.com/cover3.jpg'), ('歌单4', '爵士', 'http://example.com/cover4.jpg'), ('歌单5', '古典', 'http://example.com/cover5.jpg'), ('歌单6', '民谣', 'http://example.com/cover6.jpg'), ('歌单7', '蓝调', 'http://example.com/cover7.jpg'), ('歌单8', '乡村', 'http://example.com/cover8.jpg'), ('歌单9', '嘻哈', 'http://example.com/cover9.jpg'), ('歌单10', '节奏布鲁斯', 'http://example.com/cover10.jpg'); -- 修改 id 为 1 的歌单标签为“经典” UPDATE playlist SET tag = '经典' WHERE id = 1; -- 修改 id 为 3 的歌单名为“新的歌单名” UPDATE playlist SET name = '新的歌单名' WHERE id = 3; -- 查询所有歌单信息 SELECT * FROM playlist; -- 查询标签为“流行”的歌单信息 SELECT * FROM playlist WHERE tag = '电子';