idea创建maven项目并连接数据库详细步骤

╰半橙微兮° 2023-08-17 16:29 153阅读 0赞

1.先看项目的目录结构  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70]  
2.创建maven项目  
2.1  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 1]  
2.2  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 2]  
2.3  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 3]  
3.配置文件  
3.1创建配置文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 4]  
在resources目录创建一个mybatis文件夹，在mybatis文件夹创建mybatis-config.xml和创建mapper文件夹，在mapper文件夹创建UserMapper.xml文件。

## 创建 mybatis-config.xml ##

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    
    </configuration>

## 创建UserMapper.xml ##

<?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="com.xf.bootweb.dao.UserDao">
    
        <select id="getUser" resultType="com.xf.bootweb.entity.UserPojo">
            select * from user where id=#{id}
        </select>
    
    </mapper>

## 创建application.yml文件 ##

spring:
      datasource:
        #   数据源基本配置
        username: root
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/jdbc?serverTimezone=UTC
    #    type: com.alibaba.druid.pool.DruidDataSource
    #    引用mybatis的配置文件
    mybatis:
      config-location: classpath:mybatis/mybatis-config.xml
      mapper-locations: classpath:mybatis/mapper/*.xml

4.创建各个类

**创建UserPojo**

package com.xf.bootweb.entity;
    
    public class UserPojo {
    
        private int id;
        private String username;
        private String userpasswd;
    
        @Override
        public String toString() {
            return "UserPojo{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", userpasswd='" + userpasswd + '\'' +
                    '}';
        }
    
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getUserpasswd() {
            return userpasswd;
        }
    
        public void setUserpasswd(String userpasswd) {
            this.userpasswd = userpasswd;
        }
    }

**创建UserController**

package com.xf.bootweb.controller;
    
    
    import com.xf.bootweb.dao.UserDao;
    import com.xf.bootweb.entity.UserPojo;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class UserController {
    
        @Autowired
        UserDao userDao;
    
        @RequestMapping("/User/{id}")
        public UserPojo getUser(@PathVariable("id") int id){
            UserPojo user= userDao.getUser(id);
            return user;
        }
    }

**创建UserDao**

package com.xf.bootweb.dao;
    
    
    import com.xf.bootweb.entity.UserPojo;
    import org.apache.ibatis.annotations.Mapper;
    
    @Mapper
    public interface UserDao {
        UserPojo getUser(int id);
    }

结果：  
![在这里插入图片描述][20190928212645559.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70]: /images/20230810/220ec89d3ad0402d9963cde220f70fed.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 1]: /images/20230810/f8634a7a924b42fda45e1114780416a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 2]: /images/20230810/8eb12f2a3b204b46aba35b2d1766d6ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 3]: /images/20230810/9215b940343e45e69123615e2d05b62c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 4]: /images/20230810/e5fbbccd2cd144aca7e2aebaf668fe61.png
[20190928212645559.png]: /images/20230810/aa67618bcece4096aaec16f6153d349a.png