朋友让我帮他写几个接口,因为比较简单,使用jdbc编程,后来发现数据库字段和实体类中对象属性不能实现映射,我使用mybatis框架。我使用httpClient的post方式来测试接口,项目所需包如下:
目录结构:
在src创建数据库配置文件mysql.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456
创建实体对象Goods
package pojo;
import java.math.BigDecimal;
public class Goods {
private String goodCode;
private String barCode;
private String nsUrl;
private String categoryTitle;
private String title;
private String remark;
private Integer reserve;
private Integer packge;
private BigDecimal price;
private String dicount;
private BigDecimal discountPrice;
private Integer carCount;
public String getGoodCode() {
return goodCode;
}
public void setGoodCode(String goodCode) {
this.goodCode = goodCode;
}
public String getBarCode() {
return barCode;
}
public void setBarCode(String barCode) {
this.barCode = barCode;
}
public String getNsUrl() {
return nsUrl;
}
public void setNsUrl(String nsUrl) {
this.nsUrl = nsUrl;
}
public String getCategoryTitle() {
return categoryTitle;
}
public void setCategoryTitle(String categoryTitle) {
this.categoryTitle = categoryTitle;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
public Integer getReserve() {
return reserve;
}
public void setReserve(Integer reserve) {
this.reserve = reserve;
}
public Integer getPackge() {
return packge;
}
public void setPackge(Integer packge) {
this.packge = packge;
}
public BigDecimal getPrice() {
return price;
}
public void setPrice(BigDecimal price) {
this.price = price;
}
public String getDicount() {
return dicount;
}
public void setDicount(String dicount) {
this.dicount = dicount;
}
public BigDecimal getDiscountPrice() {
return discountPrice;
}
public void setDiscountPrice(BigDecimal discountPrice) {
this.discountPrice = discountPrice;
}
public Integer getCarCount() {
return carCount;
}
public void setCarCount(Integer carCount) {
this.carCount = carCount;
}
}
创建GoodsMapper.xml
<?xml versio