diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
index db34ebe..668bc3b 100644
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -1,13 +1,15 @@
 # ??MySQL??
 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
-spring.datasource.url=jdbc:mysql://localhost:3306/groupone_db\
+spring.datasource.url=jdbc:mysql://localhost:3306/llksh\
 ?useSSL=false\
 &serverTimezone=Asia/Shanghai\
 &characterEncoding=utf8\
 &allowPublicKeyRetrieval=true
 
 spring.datasource.username=root
-spring.datasource.password=Rfw@2935
+spring.datasource.password=wuxiaorui123
+# src/main/resources/application.properties
+spring.jpa.database-platform=org.hibernate.dialect.MySQL8Dialect
 
 # ???????????
 spring.datasource.hikari.maximum-pool-size=10
@@ -16,4 +18,12 @@
 spring.datasource.hikari.connection-timeout=30000
 
 # ???? MyBatis ?????
-mybatis.configuration.map-underscore-to-camel-case=true
\ No newline at end of file
+mybatis.configuration.map-underscore-to-camel-case=true
+
+
+
+# ?????????
+mybatis.type-aliases-package=edu.bjtu.groupone.backend.domain.entity
+
+# ????????
+mybatis.mapper-locations=classpath:mapper/*.xml
\ No newline at end of file
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 6cf60f3..2d79bf4 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -15,9 +15,9 @@
 
   datasource:
     driver-class-name: com.mysql.cj.jdbc.Driver
-    url: jdbc:mysql://localhost:3306/groupone_db?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8
+    url: jdbc:mysql://localhost:3306/llksh?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8
     username: root
-    password: "Rfw@2935"
+    password: "wuxiaorui123"
     hikari:
       maximum-pool-size: 10
       minimum-idle: 5
diff --git a/src/main/resources/mapper/CategoryMybatisMapper.xml b/src/main/resources/mapper/CategoryMybatisMapper.xml
new file mode 100644
index 0000000..1a8e7e0
--- /dev/null
+++ b/src/main/resources/mapper/CategoryMybatisMapper.xml
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<!-- 修改1：使用全限定类名 -->
+<mapper namespace="edu.bjtu.groupone.backend.mapper.CategoryMybatisMapper">
+
+    <!-- 查询所有分类 -->
+    <select id="findAll"
+            resultType="edu.bjtu.groupone.backend.domain.entity.Category">
+        SELECT * FROM categories
+    </select>
+
+    <!-- 根据父分类ID查询 -->
+    <select id="findByParentId" parameterType="Long"
+            resultType="edu.bjtu.groupone.backend.domain.entity.Category">
+        SELECT * FROM categories WHERE parent_id = #{parentId}
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/WorkMybatisMapper.xml b/src/main/resources/mapper/WorkMybatisMapper.xml
new file mode 100644
index 0000000..dd0d444
--- /dev/null
+++ b/src/main/resources/mapper/WorkMybatisMapper.xml
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+
+<mapper namespace="edu.bjtu.groupone.backend.mapper.WorkMybatisMapper">
+
+    <!-- 结果集映射 -->
+    <resultMap id="WorkResultMap" type="Work">
+        <id property="id" column="id"/>
+        <result property="title" column="title"/>
+        <result property="description" column="description"/>
+        <result property="categoryId" column="category_id"/>
+        <result property="createTime" column="create_time"/>
+    </resultMap>
+
+    <!-- 查询所有作品 -->
+    <select id="findAll" resultMap="WorkResultMap">
+        SELECT id, title, description, category_id, create_time
+        FROM works
+    </select>
+
+    <!-- 根据分类ID列表分页查询 -->
+    <select id="findByCategoryIdIn" resultMap="WorkResultMap">
+        SELECT * FROM works
+        <where>
+            <if test="categoryIds != null and categoryIds.size() > 0">
+                category_id IN
+                <foreach item="categoryId" collection="categoryIds"
+                         open="(" separator="," close=")">
+                    #{categoryId}
+                </foreach>
+            </if>
+        </where>
+        ORDER BY create_time DESC
+        LIMIT #{pageable.pageSize} OFFSET #{pageable.offset}
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 823ecdf..beb0cc7 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -1,3 +1,4 @@
+-- 使用反引号包裹保留字表名
 CREATE TABLE `user` (
                         `user_id` INT PRIMARY KEY AUTO_INCREMENT,
                         `username` VARCHAR(255) NOT NULL UNIQUE,
@@ -6,27 +7,25 @@
                         `address` VARCHAR(255),
                         `role` VARCHAR(50) NOT NULL DEFAULT 'user',
                         `profile_pic` VARCHAR(255),
-                        `registration_date` DATETIME NOT NULL,  -- 推荐用时间类型（而非字符串）
-                        `identification_number` VARCHAR(18),    -- 身份证号建议用 VARCHAR(18)
+                        `registration_date` DATETIME NOT NULL,
+                        `identification_number` VARCHAR(18),
                         `avatar` VARCHAR(255),
-                        `isfollowed` BOOLEAN NOT NULL DEFAULT FALSE,
-                        INDEX `idx_user_id` (`user_id`)          -- 可选：主键通常自带索引
+                        `isfollowed` BOOLEAN NOT NULL DEFAULT FALSE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
-
-
+-- 外键表同样使用反引号
 CREATE TABLE user_follow (
-                             follower_id INT NOT NULL,
-                             followed_id INT NOT NULL,
-                             created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-                             PRIMARY KEY (follower_id, followed_id),
-                             FOREIGN KEY (follower_id) REFERENCES user(user_id),
-                             FOREIGN KEY (followed_id) REFERENCES user(user_id)
+                             `follower_id` INT NOT NULL,
+                             `followed_id` INT NOT NULL,
+                             `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+                             PRIMARY KEY (`follower_id`, `followed_id`),
+                             FOREIGN KEY (`follower_id`) REFERENCES `user`(`user_id`),
+                             FOREIGN KEY (`followed_id`) REFERENCES `user`(`user_id`)
 );
 
+-- 插入语句使用反引号包裹表名和列名
 INSERT INTO `user` (
-    username, email, password, registration_date, identification_number, role
+    `username`, `email`, `password`, `registration_date`, `identification_number`, `role`
 ) VALUES (
-             'admin', 'admin@example.com', 'admin123', NOW(), 87654321, 'admin'
-         );
-
+             'admin', 'admin@example.com', 'admin123', NOW(), '87654321', 'admin'
+         );
\ No newline at end of file