操作MySql 汇总

1 查询数据

@RequestMapping(value = "/getUsers",method = RequestMethod.GET)
@ResponseBody
/*
* 读取
* List 里的对象是Map对象，而Map对象是
* 由一个String类型的键和Object类型的值组成
* */
public List<Map<String,Object>> getUsers(){
String sql="select * from user";//SQL查询语句
List<Map<String,Object>> list=jdbcTemplate.queryForList(sql);
return list;
}

2 写入

@RequestMapping(value = "/addUser",method = RequestMethod.POST)
@ResponseBody
public void addUser(String id,String email){

String sql = "insert into user values(?,?)";
System.out.print(email);
Object[] args = {id,email};
int a= jdbcTemplate.update(sql,args);
System.out.print(a);
}
}