Springboot + MySQL+ JPA Ⅰ 项目新建

素颜马尾好姑娘i 2023-10-02 15:08 19阅读 0赞

最近在学习JPA的，在此跟大家分享一下，持续更新中。。。（开发工具IDEA）

#### **一、new project 选择 Spring Initializr Next** ####

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16][]

####  **二、自定义项目名（我这边时smjdemo）** ####

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

####  **三、选择需要依赖的包（Lombok(本人喜欢用，可以不加)、Spring Web、JDBC API、Spring Data JPA、MySQL Driver）**![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 2][] ####

####  **四、在 application.yml 添加配置** ####

a）url：后面跟自己的数据库地址

b）username 和 password ：自己数据库的账号和密码

c）jpa.show-sql： 是否显示执行的sql语句

d）server.port：自己的测试端口

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 3][]注：如果出现上图 com.mysql.cj.jdbc.Driver 报红需要去pom.xml文件删除<scope>runtime</scope>

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

#### **五、在数据库中创建 jpatext库，并创建student表** ####

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 5][]

####  **六、新建 pojo、dao、service、control 文件** ####

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 6][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 7][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 8][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 9][]

####  **七、执行 SmjdemoApplication 类启动项目，在浏览器中输入地址+端口+接口，测试成功** ####

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 10][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 11][]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/4a19de114bdc4e6c95724ac778ad093b.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/88fb1aa175624fef9119df80c83ab60c.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/19fdeb8110d8440f9aad3d3d747a8d5b.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/693acbf29ac44081bef967df3697044d.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/5fcc5c208df1465981ff65521e7b6ba1.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 5]: https://img-blog.csdnimg.cn/b50ae73e1bde4da4ac3537d8f77e7b63.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 6]: https://img-blog.csdnimg.cn/a9a7bf0eebcf4a7cb7b827e7632035e5.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 7]: https://img-blog.csdnimg.cn/c77b601770cf4188881f2ef696aefe9c.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 8]: https://img-blog.csdnimg.cn/bda59097b1914ca8bd26247a152eb923.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 9]: https://img-blog.csdnimg.cn/37c406a44fea409ead73f5c6f9735688.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 10]: https://img-blog.csdnimg.cn/621251741b0d44259f83627d7ea431fd.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA6Iul5Y2a6LGG_size_20_color_FFFFFF_t_70_g_se_x_16 11]: https://img-blog.csdnimg.cn/7ce86e6b785b4d17b428ceed309f5f88.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6Iul5Y2a6LGG,size_20,color_FFFFFF,t_70,g_se,x_16