一 后端
最简单的jdbc取数据
package com.neusoft.player.hello.datasource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.sql.DataSource;
@RestController
public class SoupDataSource {
@Autowired
private DataSource dataSource;
@Autowired
private JdbcTemplate jdbcTemplate;
@GetMapping("/du")
private String soupContext(){
String sql="select title from soup where id = ";
int id=(int) (Math.random()*(510-10+1)+10);
sql +=id;
String title=jdbcTemplate.queryForObject(sql,String.class);