简单的JDBC配置和测试
平常没有记笔记的习惯,但是最近暑假闲来无事,尝试着写写,将自己的理解和踩坑记录下来,哈哈,给同学们分享一下。
1.导入依赖
<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>
2.连接数据库
application.yml
spring:
datasource:
username: root
password: newpassword
url: jdbc:mysql://localhost:3306/test?userUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.jdbc.Driver
3.测试数据库连接
4.创建JDBCController
注入Jdbctemplete
@RestController
public class JDBCController {
@Autowired
JdbcTemplate jdbcTemplate;
//查询数据库的所有信息并且显示在网页上
@GetMapping("/userlist")
public List<Map<String, Object>> userlist() {
String sql="select * from user";
List<Map<String,Object>>maps=jdbcTemplate.queryForList(sql);
return maps;
}
//添加数据
@GetMapping("/adduser")
public String adduser(){
String sql="insert into user(id,name,pwd) values(9,'wuwuwu','123')";
jdbcTemplate.update(sql);
return "ok";
}
//修改数据
@GetMapping("/edtuser/{id}")
public String edtuser(@PathVariable("id") int id){
String sql="update user set name=?,pwd=? where id ="+id;
//封装
Object[] objects=new Object[2];
objects[0]="xiaoxiao";
objects[1]="7758";
jdbcTemplate.update(sql,objects);
return "edt ok";
}
//删除数据
@GetMapping("/deluser/{id}")
public String deluser(@PathVariable("id") int id){
String sql="delete from user where id = ?";
jdbcTemplate.update(sql,id);
return "del ok";
}
}
5.启动tomcat服务器,测试
localhost:8080/userlist