单表的curd
数据库
image.png
model层
/**
* BZ_FUNDS_CY
* @author
*/
@Table(name="BZ_FUNDS_CY")
@Data
@NoArgsConstructor
public class BzFundsCy implements Serializable {
/**
* 主记录ID
*/
@Id
@Size(max = 32,message = "主记录id长度不能超过32位")
private String mrsId;
/**
* 所属培训班
*/
@Size(max = 32,message = "所属培训班长度不能超过32位")
private String termId;
/**
* 购买方名称
*/
@NotBlank(message = "购买方名称不能为空")
@Size(max = 32,message = "购买方名称不能超过32位")
private String buyer;
/**
* 发票销售方
*/
@Size(max = 32,message = "发票销售方长度不能超过32位")
private String saller;
/**
* 发票编号
*/
@Size(max = 20,message = "发票编号长度不能超过20位")
private String billNo;
/**
* 开票日期
*/
@JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")
@DateTimeFormat(pattern="yyyy-MM-dd")
private Date billDate;
/**
* 价税合计
*/
@Digits(integer = 10,fraction = 2)
private BigDecimal billSum;
/**
* 相关说明
*/
@Size(max = 500,message = "相关说明长度不能超过500位")
private String otherDesc;
/**
* 复印件路径
*/
@Size(max = 100,message = "复印件路径不能超过100位")
private String picPath;
/**
* 文件名称
*/
@Size(max = 50,message = "文件名称长度不能超过50位")
private String picName;
/**
* 文件扩展名
*/
@Size(max = 10,message = "文件扩展名长度不能超过10位")
private String picExt;
/**
* 创建时间
*/
@JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")
private Date createDate;
/**
* 创建人ID
*/
@Size(max = 32,message = "创建人id长度不能超过32位")
private String createId;
/**
* 修改时间
*/
@JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")
private Date modifyDate;
/**
* 修改人
*/
@Size(max = 32,message = "修改人长度不能超过32位")
private String modifyId;
@Transient
@Valid
private List<BzFundsDetailCy> bzFundsDetailCyList;
private static final long serialVersionUID = 1L;
dao层 继承通用Mapper适合于单表的增删改查
@Repository
public interface BzFundsCyDAO extends Mapper<BzFundsCy> {
}
.xml文件也放在dao层下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kingomedia.szpx.cy.dao.BzFundsCyDAO">
<!--<select id="selectBzFoundsCyList">
select bz.MRS_ID,bz.TERM_ID,bz.BUYER,bz.SALLER,bz.BILL_NO,to_char(bz.BILL_DATE,'yyyy-mm-dd')as BILL_DATE,bz.BILL_SUM
from BZ_FUNDS_CY bz
where 1=1
</select>-->
<select id="selectBzFoundsCyList">
select b.mrs_id,b.bill_no,b.bill_sum,t1.org_name as buyer,t2.org_name as saller,to_char(b.bill_date,'yyyy-mm-dd') as bill_date,b.create_id,to_char(b.create_date,'yyyy-mm-dd') as create_date
from bz_funds_cy b inner join bz_org_tree t1 on b.buyer=t1.org_id inner join bz_org_tree t2 on b.saller=t2.org_id
</select>
<select id="selectBzFoundsCyListCount">
select count(1)
from bz_funds_cy b
where 1=1
</select>
</mapper>
service层包含接口和实现类
public interface IBzFundsCy {
//增加
public ResultMap insertBzFundsCy(BzFundsCy bzFundsCy);
//删除
public ResultMap deleteBzFundsCyById(String id);
//更新
public ResultMap updateBzFundsCy(BzFundsCy bzFundsCy);
//查询
public ResultMap selectBzFundsCyById(String id);
//自定义查询语句
public ServiceResult getBzFundsCyList(Map<String, Object> whereMap);
}
@Service
public class BzFundsCyService implements IBzFundsCy{
@Autowired
BzFundsCyDAO bzFundsCyDAO;
@Autowired
GetWhereFromMap getWhereFromMap;
/**
* 新增
* @param bzFundsCy
* @return
*/
public ResultMap insertBzFundsCy(BzFundsCy bzFundsCy) {
if(null == bzFundsCy.getMrsId() || bzFundsCy.getMrsId().equals("")){
// bzFundsCy.setMrsId((int)(Math.random() * 1000) + "");
bzFundsCy.setMrsId(PersonController.getUUID32());
bzFundsCy.setTermId(PersonController.getUUID32());
// bzFundsCy.setBillDate(new Date());
bzFundsCy.setCreateId(PersonController.getUUID32());
bzFundsCy.setModifyId(PersonController.getUUID32());
bzFundsCy.setCreateDate(new Date());
bzFundsCy.setModifyDate(new Date());
bzFundsCyDAO.insertSelective(bzFundsCy);
}
return ResultMap.success("数据处理成功",null);
}
/**
* 删除
* @param id
* @return
*/
public ResultMap deleteBzFundsCyById(String id) {
int i = bzFundsCyDAO.deleteByPrimaryKey(id);
return ResultMap.success("数据处理成功",null);
}
/**
* 更新
* @param bzFundsCy
* @return
*/
public ResultMap updateBzFundsCy(BzFundsCy bzFundsCy) {
if(bzFundsCy.getMrsId() != null || !bzFundsCy.getMrsId().equals("")){
bzFundsCyDAO.updateByPrimaryKeySelective(bzFundsCy);
}
return ResultMap.success("数据处理成功",null);
}
/**
* 查询
* @param id
* @return
*/
public ResultMap selectBzFundsCyById(String id) {
BzFundsCy bzFundsCy = bzFundsCyDAO.selectByPrimaryKey(id);
return ResultMap.success("数据处理成功",null);
}
/**
* 根据用户自定义的sql语句查询记录
* @param whereMap
* @return
*/
public ServiceResult getBzFundsCyList(Map<String, Object> whereMap){
String namespace="com.kingomedia.szpx.cy.dao.BzFundsCyDAO";
String baseKey = "selectBzFoundsCyList";
String countKey = "selectBzFoundsCyListCount";
//String baseSql = jdbcBaseNamedParameterDao.getSqlString(namespace, baseKey);
//String countSql = jdbcBaseNamedParameterDao.getSqlString(namespace, countKey);
// return getWhereFromMap.getOracleListByPage(baseSql,countSql,whereMap);
return getWhereFromMap.getOracleListByPage(namespace,baseKey,countKey,whereMap);
}
}
controller层
@Controller
public class BzFundsCyController {
@Autowired
BzFundsCyService bzFundsCyService;
/**
* 新增
* @param bzFundsCy
* @return
*/
@RequestMapping("/insert")
@ResponseBody
public ResultMap insert(@RequestBody @Validated BzFundsCy bzFundsCy){
return bzFundsCyService.insertBzFundsCy(bzFundsCy);
}
/**
* 删除
* @param mrsId
* @return
*/
@RequestMapping("/delete")
@ResponseBody
public ResultMap delete(String mrsId){
return bzFundsCyService.deleteBzFundsCyById(mrsId);
}
/**
* 更新
* @param bzFundsCy
* @return
*/
@RequestMapping("/update")
@ResponseBody
public ResultMap update(@RequestBody @Validated BzFundsCy bzFundsCy){
return bzFundsCyService.updateBzFundsCy(bzFundsCy);
}
/**
* 查询
* @param mrsId
* @return
*/
@RequestMapping("/select")
@ResponseBody
public ResultMap select(String mrsId){
return bzFundsCyService.selectBzFundsCyById(mrsId);
}
/**
* 自定义查询
* @return
*/
@RequestMapping("/selectList")
@ResponseBody
public ServiceResult selectList(@RequestBody Map<String,Object> whereMap){
return bzFundsCyService.getBzFundsCyList(whereMap);
}
}
网友评论