基于JaveWeb+SpringBoot在线课程学习网站

我就是我 2024-04-01 12:51 17阅读 0赞

采用 Jave Web 技术开发 Web 技术课程网站，网站主要实现教学大纲、课程介绍等教学内容的浏览，教学课件和视频资料的浏览下载，简单的留言和回复功能。

#### 1.框架 ####

前端：layui  
后端：SpringBoot MyBatis

##### MyBatis 设计 #####

User 为例

*  实体类

@Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class User {
        
    
        private Integer user_id;
        private String user_name;
        private String user_password;
        private String user_avatar;
        private String user_signature;
    
        public User(String user_name, String user_password) {
        
            this.user_name = user_name;
            this.user_password = user_password;
        }
    }

*  Mapper 接口

@Mapper
    public interface UserMapper {
        
    
    
        @Select("select * from user")
        List<User> getAllUser();
    
        @Insert("insert into user (user_name,user_password,user_signature) values" +
                " (#{user.user_name},#{user.user_password},#{user.user_signature})")
        void addUser(@Param("user") User user);
    
        @Select("select * from user where user_name=#{name}")
        List<User> selectUserByName(@Param("name") String userName);
    
        @Insert("insert into userMoreMessage (user_id) values (#{user_id})")
        void addPersonMessage(@Param("user_id") int user_id);
    
        @Select("select * from userMoreMessage where user_id=#{user_id}")
        List<UserMoreMessage> selectMessage(@Param("user_id") int user_id);
    
        @Update("update user set user_avatar=#{user.user_avatar} where user_name=#{user.user_name}")
        void updateAvatar(@Param("user") User user);
    
        @Update("update user set user_name=#{user.user_name} where user_id=#{user.user_id}")
        void updateUserName(@Param("user") User user);
    
        @Update("update user set user_signature=#{user.user_signature} where user_id=#{user.user_id}")
        void updateUserSignature(@Param("user") User user);
    
        @Update("update userMoreMessage set user_address=#{userMoreMessage.user_address}," +
                "user_website=#{userMoreMessage.user_website},user_introduction=#{userMoreMessage.user_introduction} where user_id=#{userMoreMessage.user_id}")
        void updateUserMessage(@Param("userMoreMessage") UserMoreMessage userMoreMessage);
    
        @Select("select * from user where user_id=#{user_id}")
        User selectUserById(@Param("user_id") int user_id);
    
    }

*  实现 Dao

@Component
    public class UserDao implements UserMapper{
        
    
        @Autowired
        SqlSession sqlSession;
    
        @Override
        public List<User> getAllUser() {
        
            return sqlSession.selectList("com.dao.UserMapper.getAllUser");
        }
    
        @Override
        public void addUser(User user) {
        
            sqlSession.insert("com.dao.UserMapper.addUser",user);
        }
    
        @Override
        public List<User> selectUserByName(String userName) {
        
            return sqlSession.selectList("com.dao.UserMapper.selectUserByName",userName);
        }
    
        @Override
        public void addPersonMessage(int user_id) {
        
            sqlSession.insert("com.dao.UserMapper.addPersonMessage",user_id);
        }
    
        @Override
        public List<UserMoreMessage> selectMessage(int user_id) {
        
            return sqlSession.selectList("com.dao.UserMapper.selectMessage",user_id);
        }
    
        @Override
        public void updateAvatar(User user) {
        
            sqlSession.update("com.dao.UserMapper.updateAvatar",user);
        }
    
        @Override
        public void updateUserName(User user) {
        
            sqlSession.update("com.dao.UserMapper.updateUserName",user);
        }
    
        @Override
        public void updateUserSignature(User user) {
        
            sqlSession.update("com.dao.UserMapper.updateUserSignature",user);
        }
    
        @Override
        public void updateUserMessage(UserMoreMessage userMoreMessage) {
        
            sqlSession.update("com.dao.UserMapper.updateUserMessage",userMoreMessage);
        }
    
        @Override
        public User selectUserById(int user_id) {
        
            return sqlSession.selectOne("com.dao.UserMapper.selectUserById",user_id);
        }
    
    
    }

![在这里插入图片描述][f67a9a325ef441a2984ca3c8ed9b2efd.png_pic_center]  
![在这里插入图片描述][1f584d8adee3486ab7a7e62055f10e62.png_pic_center]  
![在这里插入图片描述][e6c09f2ce85240b9bea0cbefc049cb2a.png_pic_center]  
![在这里插入图片描述][474af8725cfb47e1b4967ee5770e1a93.png_pic_center]  
![在这里插入图片描述][5efa7ca2c51043cdb98564cbb5eb3139.png_pic_center]  
![在这里插入图片描述][bed63959173b43b082c77bbb92c43de4.png_pic_center]  
![在这里插入图片描述][7588404fb58b4380aa918a7eaccd1239.png_pic_center]  
![在这里插入图片描述][fd0472c671584c92af1be524ab372bac.gif_pic_center]  
![在这里插入图片描述][07fd99b03ddf4d5e99389662915920d4.png_pic_center]  
![在这里插入图片描述][6c23a4eb772c41bebe8a5f20f6f1b78d.png_pic_center]  
![在这里插入图片描述][1ec397bafe0e4a2ead0ff87f48454764.png_pic_center]  
![在这里插入图片描述][47e001c207714f51b445d353db0bc65a.png_pic_center]  
![在这里插入图片描述][0c3ea83f07d34973bd2b343f101f65c1.gif_pic_center]  
![在这里插入图片描述][f4dc8e93c21d4ce1a0f5cb88af437572.png_pic_center]  
![在这里插入图片描述][af0e5f33c0b74707830dba6d5ce198a1.png_pic_center]

[f67a9a325ef441a2984ca3c8ed9b2efd.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/9946b15f417a49b1829054af17e725e7.png
[1f584d8adee3486ab7a7e62055f10e62.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/33a82c9f6ed7417ebe61a158bb068f85.png
[e6c09f2ce85240b9bea0cbefc049cb2a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/426521acccd94928b1c0cb5792d43569.png
[474af8725cfb47e1b4967ee5770e1a93.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/38cef3837cc84bdab5eaa10415a9c173.png
[5efa7ca2c51043cdb98564cbb5eb3139.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/d0db2412004541fdbc48d89465b7afdb.png
[bed63959173b43b082c77bbb92c43de4.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/7fe9c83b301c4f53b247e2e3277a3f1b.png
[7588404fb58b4380aa918a7eaccd1239.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/b8ea42706a2547d08d70c8d691287ad3.png
[fd0472c671584c92af1be524ab372bac.gif_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/738b312706ad4658a9b3c93c8cb5b3d2.gif
[07fd99b03ddf4d5e99389662915920d4.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/94f4b25852c746dc88df345cb7041874.png
[6c23a4eb772c41bebe8a5f20f6f1b78d.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/c8480e497f5447979e364e1aeae2624c.png
[1ec397bafe0e4a2ead0ff87f48454764.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/1bd6d3a9b6a545aaab1ced0a49f1d58c.png
[47e001c207714f51b445d353db0bc65a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/6077e061f2094f99943235a27168c0ce.png
[0c3ea83f07d34973bd2b343f101f65c1.gif_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/b2a99496bbd04fc8910f07d094fd2501.gif
[f4dc8e93c21d4ce1a0f5cb88af437572.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/c125b90fcc384cc7936e5f5756b5d153.png
[af0e5f33c0b74707830dba6d5ce198a1.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/cb8c7445a26640ed9ce2538a17c836ce.png