SpringBoot+JDBC

• 1.引入依赖
• 2.controller
• 3.DO
• 4.user.html

 
        
            org.springframework.boot
            spring-boot-starter-thymeleaf
        
        
        
            mysql
            mysql-connector-java
        
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
        
            org.springframework.boot
            spring-boot-starter-thymeleaf
        
        
            org.springframework.boot
            spring-boot-starter-web
            RELEASE
            compile
        
    

@Controller
@RequestMapping("/jdbc")
public class JdbcController {

    @Resource
    private JdbcTemplate jdbcTemplate;

    @RequestMapping("/user")
    @ResponseBody
    public List list(ModelMap map) {
        String sql = "SELECt * FROM user";
        List userList = jdbcTemplate.query(sql, new RowMapper() {
            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.setAge(rs.getString("age"));
                return user;
            }
        });
        for (User user : userList) {
            System.out.println(user.toString());
        }
        return userList;

    }

    @RequestMapping("/userList")
    public String userList(ModelMap map) {
        String sql = "SELECt * FROM user";
        List userList = jdbcTemplate.query(sql, new RowMapper() {
            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.setAge(rs.getString("age"));
                return user;
            }
        });
        map.addAttribute("users", userList);
        return "user";
    }
}

public class User implements Serializable {

	//用户id
	private String id;

	//用户名称
	private String name;

	//户年龄
	private String age;

	//用户性别


	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getAge() {
		return age;
	}

	public void setAge(String age) {
		this.age = age;
	}



	@Override
	public String toString() {
		return "User{" +
				"id='" + id + ''' +
				", name='" + name + ''' +
				", age='" + age + ''' +
				'}';
	}
}

    
    




    

        
id
        
用户名称
        
年龄
        
性别