java springboot 使用JdbcTemplate连接MySql

最新推荐文章于 2024-08-24 19:14:27 发布

@疯子#

最新推荐文章于 2024-08-24 19:14:27 发布

阅读量151

点赞数

分类专栏： java 文章标签： java spring boot

本文链接：https://blog.csdn.net/qq_43584975/article/details/113679135

版权

java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

首先在pom.xml里面配置所需要的

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

然后建立service类

@Service
public class TestDao {
	@Autowired
	private JdbcTemplate jdbcTemplate;
	public List<Map<String, Object>> findAll() {
		String sqlString = "select * from student";
		List<Map<String, Object>> list = jdbcTemplate.queryForList(sqlString);
		return list;
	}
	
}

然后在控制器里面获取

@Controller
public class HelloController {
	@Autowired
	private TestDao dao = new TestDao();
	@ResponseBody
	@RequestMapping(value = "/say", method = RequestMethod.GET)
	public ArrayList<Student> say() {
		ArrayList<Student> studentSum = new ArrayList<>();
		List<Map<String, Object>> list = dao.findAll();
		list.forEach((e)->{
			Student student = new Student();
			student.setId((Integer)e.get("id"));
			student.setName((String)e.get("name"));
			studentSum.add(student);
		});
		return studentSum;
	}
}