php转java 系列2 Spring boo 链接数据库jdbc详解编程语言

<dependency> 
<groupId>org.springframework.boot</groupId> 
<artifactId>spring-boot-starter-jdbc</artifactId> 
</dependency> 
 
<dependency> 
<groupId>org.springframework.boot</groupId> 
<artifactId>spring-boot-starter-web</artifactId> 
</dependency> 
 
<dependency> 
<groupId>mysql</groupId> 
<artifactId>mysql-connector-java</artifactId> 
<scope>runtime</scope> 
</dependency> 
 
<dependency> 
<groupId>org.springframework.boot</groupId> 
<artifactId>spring-boot-starter-test</artifactId> 
<scope>test</scope> 
</dependency>

#访问根路径 
 
#应用名称 
spring.application.name=springboot-demo 
 
#访问端口号 
server.port=8080 
 
#编码格式 
server.tomcat.uri-encoding=utf-8 
 
#数据库相关配置 
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver 
spring.datasource.url=jdbc:mysql://111:3306/wangzhan 
spring.datasource.username=111 
spring.datasource.password=111 
spring.datasource.max-idle=10 
spring.datasource.max-wait=10000 
spring.datasource.min-idle=5 
spring.datasource.initial-size=5 
 
#session生命周期 
 
server.servlet.session.timeout=30m

package com.example.demo; 
import java.util.*; 
import org.springframework.boot.SpringApplication; 
import org.springframework.boot.autoconfigure.SpringBootApplication; 
import org.springframework.stereotype.Controller; 
import org.springframework.web.bind.annotation.RequestMapping; 
import org.springframework.web.bind.annotation.ResponseBody; 
import org.springframework.beans.factory.annotation.Autowired; 
import org.springframework.jdbc.core.JdbcTemplate; 
 
@Controller 
@SpringBootApplication 
public class DemoApplication { 
    @Autowired 
    private final JdbcTemplate jdbcTemplate; 
 
    public DemoApplication(JdbcTemplate jdbcTemplate) { 
        this.jdbcTemplate = jdbcTemplate; 
    } 
    public static void main(String[] args) { 
        SpringApplication.run(DemoApplication.class, args); 
    } 
 
    @ResponseBody 
    @RequestMapping("hello1") 
 
    public String hello1() { 
        Object dddd="fwef"; 
        Object[] ff=new Object[]{"111","1"}; 
        System.out.print("输入你的姓名："); 
        System.out.print("输入你的姓名1："); 
        System.out.print("输入你的姓名2："); 
//        String sql = "insert into t_user(username, password) values(?, ?)"; 
// 
//        jdbcTemplate.update(sql, new Object[]{"111","1"}); 
 
        String sql = "SELECT * FROM t_user"; 
        List<Map<String, Object>> list = jdbcTemplate.queryForList(sql); 
        for (Map<String, Object> map : list) { 
            System.out.println(map); 
        } 
        return "1"; 
    } 
 
 
 
}