SpringBoot 使用JDBC连接Mysql数据库

1

2

3

4

5

6

7

8

9

<!--JDBC-->

<dependency>

    <groupId>mysql</groupId>

    <artifactId>mysql-connector-java</artifactId>

</dependency>

<dependency>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-jdbc</artifactId>

</dependency>

1

2

3

4

5

6

7

8

9

10

11

12

13

############################################################

#

# mysql

#

############################################################

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.max-idle=10

spring.datasource.max-wait=10000

spring.datasource.min-idle=5

spring.datasource.initial-size=5

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

/**

 * @author oyc

 * @Description:用户实体类

 * @date 2018/7/8 22:51

 */

public class User {

    //用户id

    private String id;

    //用户名称

    private String name;

    //户年龄

    private String age;

    //用户性别

    private String sex;

    //此处省略getter、setter方法

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

/**

 * @author oyc

 * @Description: 用户控制类

 * @date 2018/7/8 22:10

 */

@Controller

@RequestMapping("/jdbc")

public class JdbcController {

    @Resource

    private JdbcTemplate jdbcTemplate;

    @RequestMapping("/userlist")

    public String getUserList(ModelMap map){

        String sql = "SELECT * FROM user";

        List<User> userList = jdbcTemplate.query(sql, new RowMapper<User>() {

            User user = null;

            @Override

            public User mapRow(ResultSet rs, int rowNum) throws SQLException {

                user = new User();

                user.setId(rs.getString("id"));

                user.setName(rs.getString("name"));

                user.setSex(rs.getString("sex"));

                user.setAge(rs.getString("age"));

                return user;

            }});

        for(User user:userList){

            System.out.println(user.getName());

        }

        map.addAttribute("users", userList);

        return "user";

    }

}