01下载免安装版MySQL
02安装MySQL
a)将MySQL压缩包解压到合适的位置,以C:\programmer\Tools\mysql-5.7.20-winx64路径为例;
b)新建系统变量,变量名MYSQL_HOME,值C:\programmer\Tools\mysql-5.7.20-winx64;
c)在系统变量path中追加%MYSQL_HOME%\bin;
d)在C:\programmer\Tools\mysql-5.7.20-winx64\bin目录中创建my.ini配置文件,配置内容如下
[client]default-character-set=utf8[mysqld]#数据库目录
basedir=%MYSQL_HOME%
#数据库数据目录
datadir=%MYSQL_HOME%\data
port= 3306default-character-set=utf8
e)以管理员身份打开命令行,输入如下命令
命令:mysqld --initialize #初始化mysql,生成data文件夹中的文件
命令:mysqld -install #安装mysql
命令:net start mysql #启动服务器
f)设置数据库密码
在C:\programmer\Tools\mysql-5.7.20-winx64\data目录下DESKTOP-LVJ3R7C.err文件中可以看到mysql启动时,生成了临时密码
[Note] A temporary password is generated for root@localhost: aUq3td)UV-DR
登录数据库并修改密码
mysql -u root -p #回显后,输入日志中密码
alter user 'root'@'localhost' identified by 'dyd';#修改数据库密码为dyd
g)新建数据库
create database dyd;#新建dyd数据库
03新建SpringBoot工程,application.yml中添加数据库配置如下
spring:
datasource:
url: jdbc:mysql://localhost/dyd
username: root
password: dyd
driver-class-name: com.mysql.jdbc.Driver
jpa:
show-sql: true
hibernate:
ddl-auto: create-drop #启动时,表存在则删除创建,不存在则创建。仅用于开发环境
04Maven的POM配置文件
org.springframework.boot
spring-boot-starter-data-jpa
mysql
mysql-connector-java
runtime
05Bean对象
packagecom.dyd.entity.bean;importjavax.persistence.Entity;importjavax.persistence.GeneratedValue;importjavax.persistence.GenerationType;importjavax.persistence.Id;importlombok.Data;importlombok.NonNull;
@Entity
@Data //使用了lombokpublic classUser {
@Id
@GeneratedValue(strategy= GenerationType.AUTO)private longid;
@NonNullprivateString name;
@NonNullprivateString email;
}
06DAO类
packagecom.dyd.entity.dao;importorg.springframework.data.repository.CrudRepository;importcom.dyd.entity.bean.User;public interface UserRepository extends CrudRepository{
}
07数据库操作示例
packagecom.dyd.controller;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.GetMapping;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.ResponseBody;importorg.springframework.web.bind.annotation.RestController;importcom.dyd.entity.bean.User;importcom.dyd.entity.dao.UserRepository;
@RestController
@RequestMapping("/user")public classUserController {
@AutowiredprivateUserRepository userRepository;
@GetMapping("/add")public@ResponseBody String add() {//增
User user = new User("Bob", "666@hotmail.com");
userRepository.save(user);//查
Iterable all =userRepository.findAll();//改
for(User u : all) {
u.setEmail("999@hotmail.com");
userRepository.save(u);
}//删
userRepository.delete(user);return "Success";
}
@GetMapping("/all")public @ResponseBody Iterableall() {returnuserRepository.findAll();
}
}
08常见mysql命令
启动:net start mysql
停止:net stop mysql
控制台:mysqld --console
卸载: mysqld -remove