springboot+jpa显示完整sql_SpringBoot整合springdata和缓存



org.springframework.boot spring-boot-starter-data-jpa



mysqlmysql-connector-java


com.alibabadruid1.0.9


spring.datasource.driver-class-name&＃61;com.mysql.cj.jdbc.Driver
spring.datasource.url&＃61;jdbc:mysql://localhost:3306/kaoshi1?useUnicode&＃61;true&charsetEncoding&＃61;utf-8&useSSL&＃61;true&serverTimezone&＃61;GMT%2b8
spring.datasource.username&＃61;root
spring.datasource.password&＃61;rootspring.datasource.type&＃61;com.alibaba.druid.pool.DruidDataSource
mybatis.type-aliases-package&＃61;com.cyj.pojo
spring.jpa.hibernate.ddl-auto&＃61;update
spring.jpa.show-sql&＃61;true

package com.cyj.pojo;import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;&＃64;Entity
&＃64;Table(name &＃61; "t_users")
public class Users {&＃64;Id&＃64;GeneratedValue(strategy &＃61; GenerationType.IDENTITY)&＃64;Column(name &＃61; "id")private Integer id;&＃64;Column(name &＃61; "name")private String name;&＃64;Column(name &＃61; "age")private Integer age;&＃64;Column(name &＃61; "address")private String address;public Integer getId() {return id;}public void setId(Integer id) {this.id &＃61; id;}public String getName() {return name;}public void setName(String name) {this.name &＃61; name;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age &＃61; age;}public String getAddress() {return address;}public void setAddress(String address) {this.address &＃61; address;}&＃64;Overridepublic String toString() {return "Users [id&＃61;" &＃43; id &＃43; ", name&＃61;" &＃43; name &＃43; ", age&＃61;" &＃43; age &＃43; ", address&＃61;" &＃43; address &＃43; "]";}
}

package com.cyj.dao;
import com.cyj.pojo.Users;
importorg.springframework.data.jpa.repository.JpaRepository;
/*** &＃64;author cyj* &＃64;date 2019-11-21 10:49*/
public interface UsersRepository extends JpaRepository {
}


org.springframework.bootspring-boot-starter-test


package com.cyj;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/*** &＃64;author cyj* &＃64;date 2019-11-19 14:37*/
&＃64;SpringBootApplication
public class App {public static void main(String[] args) {SpringApplication.run(App.class, args);}
}

&＃64;Autowired
private UsersRepository usersRepository;&＃64;Test
public void testSave() {Users users &＃61; new Users();users.setAddress("北京市海淀");users.setAge(20);users.setName("张三");this.usersRepository.save(users);
}

package com.cyj.pojo;import javax.persistence.*;
import java.util.HashSet;/*** &＃64;author cyj* &＃64;date 2019-11-21 11:08*/
&＃64;Entity
&＃64;Table(name &＃61; "t_menus")
public class Menus {&＃64;Id&＃64;GeneratedValue(strategy &＃61; GenerationType.IDENTITY)&＃64;Column(name &＃61; "menusid")private Integer menusid;&＃64;Column(name &＃61; "menusname")private String menusname;&＃64;Column(name &＃61; "menusurl")private String menusurl;&＃64;Column(name &＃61; "fatherid")private Integer fatherid;&＃64;ManyToMany(mappedBy &＃61; "menus")private Set roles &＃61; new HashSet<>();public Integer getMenusid() {return menusid;}public void setMenusid(Integer menusid) {this.menusid &＃61; menusid;}public String getMenusname() {return menusname;}public void setMenusname(String menusname) {this.menusname &＃61; menusname;}public String getMenusurl() {return menusurl;}public void setMenusurl(String menusurl) {this.menusurl &＃61; menusurl;}public Integer getFatherid() {return fatherid;}public void setFatherid(Integer fatherid) {this.fatherid &＃61; fatherid;}public Set getRoles() {return roles;}public void setRoles(Set roles) {this.roles &＃61; roles;}&＃64;Overridepublic String toString() {return "Menus [menusid&＃61;" &＃43; menusid &＃43; ", menusname&＃61;" &＃43; menusname &＃43; ", menusurl&＃61;" &＃43; menusurl &＃43; ", fatherid&＃61;" &＃43; fatherid &＃43; "]";}
}

&＃64;Autowired
private RolesRepository rolesRepository;/*** 添加测试 */
&＃64;Test
public void testSave() { //创建角色对象 Roles r &＃61; new Roles();r.setRolename("项目经理"); //创建菜单对象 Menus menus &＃61; new Menus();menus.setMenusname("xxxx 管理系统");menus.setFatherid(0);Menus menus2 &＃61; new Menus();menus2.setFatherid(1);menus2.setMenusname("项目管理"); //关联 r.getMenus().add(menus);r.getMenus().add(menus2);menus.getRoles().add(r);menus2.getRoles().add(r); //保存 this.rolesRepository.save(r);
}

#连接数据库
spring.datasource.driverClassName&＃61;com.mysql.jdbc.Driver
spring.datasource.url&＃61;jdbc:mysql://localhost:3306/ssm?useSSL&＃61;false
spring.datasource.username&＃61;root
spring.datasource.password&＃61;root
#指定连接池
spring.datasource.type&＃61;com.alibaba.druid.pool.DruidDataSource#开启正向工程
spring.jpa.hibernate.ddl-auto&＃61;update
spring.jpa.hibernate.generate-ddl&＃61;true
#运行时,打印sql语句
spring.jpa.show-sql&＃61;true