feat: add springboot+jpa+sqlite

niumoo · niumoo · commit 39c0d444bedb · 2024-02-27T23:43:46.000+08:00
diff --git a/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/SpringBootSqliteApp.java b/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/SpringBootSqliteApp.java
@@ -3,6 +3,9 @@
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
 
+/**
+ * @author https://www.wdbyte.com
+ */
 @SpringBootApplication
 public class SpringBootSqliteApp {
 
diff --git a/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/controller/SqliteController.java b/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/controller/SqliteController.java
@@ -13,8 +13,7 @@
 import org.springframework.web.bind.annotation.RestController;
 
 /**
- * @author niulang
- * @date 2024/02/27
+ * @author https://www.wdbyte.com
  */
 @Slf4j
 @RestController
@@ -47,6 +46,9 @@ public String init() {
     @GetMapping("/sqlite/find")
     public String findByUsername(String username) {
         WebsiteUser websiteUser = userRepository.findByUsername(username);
+        if (websiteUser == null) {
+            return null;
+        }
         return websiteUser.toString();
     }
 
diff --git a/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/repository/WebsiteUserRepository.java b/springboot/springboot-sqlite-jpa/src/main/java/com/wdbyte/springsqlite/repository/WebsiteUserRepository.java
@@ -7,5 +7,10 @@
 @Repository
 public interface WebsiteUserRepository extends CrudRepository<WebsiteUser, Long> {
 
+    /**
+     * 根据 username 查询数据
+     * @param name
+     * @return
+     */
     WebsiteUser findByUsername(String name);
 }
diff --git a/springboot/springboot-sqlite-jpa/src/main/resources/application.properties b/springboot/springboot-sqlite-jpa/src/main/resources/application.properties
@@ -1,7 +1,7 @@
 spring.datasource.url=jdbc:sqlite:springboot-sqlite-jpa.db
 spring.datasource.driver-class-name=org.sqlite.JDBC
-
 # JPA Properties
 spring.jpa.database-platform=org.hibernate.community.dialect.SQLiteDialect
+# create ?????????update?????????
 spring.jpa.hibernate.ddl-auto=update
-spring.jpa.show-sql=true
+spring.jpa.show-sql=true
