数据库是可以连接上的,前台调用请求,后台如何获得前台的数据,加入到sql语句中进行查询?
新手刚开始搞这个,最简单的一个数据查询功能
简单看下jsp页面
Name/form:label
Postcode/form:label
Address/form:label
controller
@Controller
@RequestMapping(value = "/person")
public class PersonController {
private Logger logger = LoggerFactory.getLogger(PersonController.class);
@Autowired
private PersonDao personDao;
@RequestMapping(value = "list", method = RequestMethod.GET)
public String getAddressList(Model model) {
model.addAttribute("people", personDao.selectAll());
return "person/list";
}
@RequestMapping(value = "create", method = RequestMethod.POST)
public String create(@Valid Person person, BindingResult result) {
if (result.hasErrors()) {
logger.warn(result.getFieldErrors().toString());
return "person/form";
}
this.personDao.insert(person);
return "redirect:/person/list";
}
}
public class Person {
private Long id;
@NotEmpty
private String name;
@NotEmpty
private String postcode;
@NotEmpty
private String address;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPostcode() {
return postcode;
}
public void setPostcode(String postcode) {
this.postcode = postcode;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
表单会提交到create这个方法,这个时候会用Person 去自动获取表单里面对应的值。
这个时候你可以使用get方法获取里面的任何属性的值,然后再把值插入到数据库,另外还有传统的request.getParameter和@requestParam等可以获取表单的值,下面的例子你可以参考
https://github.com/komamitsu/Spring-MVC-sample-using-iBatis
http://wenku.baidu.com/view/6f5fb91c650e52ea55189824.html
http://download.csdn.net/download/zhimin568/4659367
给你俩个地址。参考下。。
你所需要的是springmvc方面的基础知识,去看下jinnianshilongnian的专栏吧,[url]http://www.iteye.com/blogs/subjects/kaitao-springmvc?page=2[/url]
:idea: