SELECT
LAST_INSERT_ID()
INSERT INTO DC_BG_RISK_SCAN(
ID
,NAME
,RISK
,DETAIL
,EDU_INFO
,ID_CARD_NO
,DETAIL_URL
,GMT_CREATE
,GMT_MODIFIED
)VALUES(
#{id,jdbcType=BIGINT}
, #{name,jdbcType=VARCHAR}
, #{risk,jdbcType=CHAR}
, #{detail,jdbcType=VARCHAR}
, #{eduInfo,jdbcType=VARCHAR}
, #{idCardNo,jdbcType=VARCHAR}
, #{detailUrl,jdbcType=VARCHAR}
, #{gmtCreate,jdbcType=TIMESTAMP}
, #{gmtModified,jdbcType=TIMESTAMP}
)
UPDATE DC_BG_RISK_SCAN
SET
ID = #{id,jdbcType=BIGINT}
,NAME = #{name,jdbcType=VARCHAR}
,RISK = #{risk,jdbcType=CHAR}
,DETAIL = #{detail,jdbcType=VARCHAR}
,EDU_INFO = #{eduInfo,jdbcType=VARCHAR}
,ID_CARD_NO = #{idCardNo,jdbcType=VARCHAR}
,DETAIL_URL = #{detailUrl,jdbcType=VARCHAR}
,GMT_CREATE = #{gmtCreate,jdbcType=TIMESTAMP}
,GMT_MODIFIED = #{gmtModified,jdbcType=TIMESTAMP}
WHERE
ID = #{id,jdbcType=BIGINT}
DELETE FROM
DC_BG_RISK_SCAN
WHERE
ID = #{id,jdbcType=BIGINT}
SELECT *
FROM DC_BG_RISK_SCAN
WHERE
ID = #{id,jdbcType=BIGINT}
select
name,risk
from
DC_BG_RISK_SCAN
where
id_card_no=#{idCardNo}
or
id_card_no=#{idCardNoXX,jdbcType=VARCHAR}
limit 1
select
name,risk
from
DC_BG_RISK_SCAN
where
id_card_no=#{idCardNo}
and
name in
#{name,jdbcType=VARCHAR}
limit 1
select
name,risk
from
DC_BG_RISK_SCAN
where
id_card_no=#{idCardNo}
and
name in
#{name,jdbcType=VARCHAR}
```
## 生成结果
```xml
RiskScanDOMapper.xml
ID,NAME,RISK,DETAIL,EDU_INFO,ID_CARD_NO,DETAIL_URL,GMT_CREATE,GMT_MODIFIED
SELECT
LAST_INSERT_ID()
INSERT INTO DC_BG_RISK_SCAN(
ID
,NAME
,RISK
,DETAIL
,EDU_INFO
,ID_CARD_NO
,DETAIL_URL
,GMT_CREATE
,GMT_MODIFIED
)VALUES(
#{id,jdbcType=BIGINT}
, #{name,jdbcType=VARCHAR}
, #{risk,jdbcType=CHAR}
, #{detail,jdbcType=VARCHAR}
, #{eduInfo,jdbcType=VARCHAR}
, #{idCardNo,jdbcType=VARCHAR}
, #{detailUrl,jdbcType=VARCHAR}
, #{gmtCreate,jdbcType=TIMESTAMP}
, #{gmtModified,jdbcType=TIMESTAMP}
)
UPDATE /*MS-AUTODALGEN-DC-BG-RISK-SCAN-UPDATE*/ DC_BG_RISK_SCAN
SET
ID = #{id,jdbcType=BIGINT}
,NAME = #{name,jdbcType=VARCHAR}
,RISK = #{risk,jdbcType=CHAR}
,DETAIL = #{detail,jdbcType=VARCHAR}
,EDU_INFO = #{eduInfo,jdbcType=VARCHAR}
,ID_CARD_NO = #{idCardNo,jdbcType=VARCHAR}
,DETAIL_URL = #{detailUrl,jdbcType=VARCHAR}
,GMT_CREATE = #{gmtCreate,jdbcType=TIMESTAMP}
,GMT_MODIFIED = #{gmtModified,jdbcType=TIMESTAMP}
WHERE
ID = #{id,jdbcType=BIGINT}
DELETE /*MS-AUTODALGEN-DC-BG-RISK-SCAN-DELETEBYPRIMARY*/ FROM
DC_BG_RISK_SCAN
WHERE
ID = #{id,jdbcType=BIGINT}
```
```java
package com.alibaba.recruit.datacenter.risk.dal.mapper;
import com.alibaba.recruit.datacenter.risk.dal.dataobject.RiskScanDO;
import com.alibaba.recruit.datacenter.risk.dal.resultmap.MyResult;
import java.util.List;
/**
*The Table DC_BG_RISK_SCAN.
*风险扫描
*/
public interface RiskScanDOMapper{
/**
*desc:插入表:DC_BG_RISK_SCAN.
*descSql = SELECT LAST_INSERT_ID() INSERT INTO DC_BG_RISK_SCAN( ID ,NAME ,RISK ,DETAIL ,EDU_INFO ,ID_CARD_NO ,DETAIL_URL ,GMT_CREATE ,GMT_MODIFIED )VALUES( #{id,jdbcType=BIGINT} , #{name,jdbcType=VARCHAR} , #{risk,jdbcType=CHAR} , #{detail,jdbcType=VARCHAR} , #{eduInfo,jdbcType=VARCHAR} , #{idCardNo,jdbcType=VARCHAR} , #{detailUrl,jdbcType=VARCHAR} , #{gmtCreate,jdbcType=TIMESTAMP} , #{gmtModified,jdbcType=TIMESTAMP} )
*@param RiskScanDO RiskScanDO
*@return Long
*/
Long insert(entity RiskScanDO);
/**
*desc:更新表:DC_BG_RISK_SCAN.
*descSql = UPDATE DC_BG_RISK_SCAN SET ID = #{id,jdbcType=BIGINT} ,NAME = #{name,jdbcType=VARCHAR} ,RISK = #{risk,jdbcType=CHAR} ,DETAIL = #{detail,jdbcType=VARCHAR} ,EDU_INFO = #{eduInfo,jdbcType=VARCHAR} ,ID_CARD_NO = #{idCardNo,jdbcType=VARCHAR} ,DETAIL_URL = #{detailUrl,jdbcType=VARCHAR} ,GMT_CREATE = #{gmtCreate,jdbcType=TIMESTAMP} ,GMT_MODIFIED = #{gmtModified,jdbcType=TIMESTAMP} WHERE ID = #{id,jdbcType=BIGINT}
*@param RiskScanDO RiskScanDO
*@return Long
*/
Long update(entity RiskScanDO);
/**
*desc:根据主键删除数据:DC_BG_RISK_SCAN.
*descSql = DELETE FROM DC_BG_RISK_SCAN WHERE ID = #{id,jdbcType=BIGINT}
*@param id id
*@return Long
*/
Long deleteByPrimary(Long id);
/**
*desc:根据主键获取数据:DC_BG_RISK_SCAN.
*descSql = SELECT *FROM DC_BG_RISK_SCAN WHERE ID = #{id,jdbcType=BIGINT}
*@param id id
*@return RiskScanDO
*/
RiskScanDO getByPrimary(Long id);
/**
*desc:自定义ResultMap.
*descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} or id_card_no=#{idCardNoXX,jdbcType=VARCHAR} limit 1
*@param idCardNo idCardNo
*@param idCardNoXX idCardNoXX
*@return MyResult
*/
MyResult getMyResultMap(String idCardNo,String idCardNoXX);
/**
*desc:foreach支持.
*descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} and name in #{name,jdbcType=VARCHAR} limit 1
*@param idCardNo idCardNo
*@param names names
*@return MyResult
*/
MyResult getListParams(String idCardNo,List names);
/**
*desc:foreach支持 many.
*descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} and name in #{name,jdbcType=VARCHAR}
*@param idCardNo idCardNo
*@param names names
*@return List
*/
List getListParamsMany(String idCardNo,List names);
}
```
### 增加分页支持
```xml
multiplicity="paging" --标记为此方法需要走分页查询
paging="QueryRisk" --分页查询参数类名称
--自动生成DAO类,通过Spring 自动扫描方法注入,不提供xml配置项目生成了.
--DOMapper接口与DAO类区别在于对分页的支持
select
name,risk
from
DC_BG_RISK_SCAN
where
id_card_no=#{idCardNo}
and
name in
#{name,jdbcType=VARCHAR}
order by gmt_modified desc
Mapper.xml结果
DOMapper.java
/**
* desc:foreach支持 many.
* descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} and name in #{name,jdbcType=VARCHAR} order by gmt_modified desc
* @param queryRisk queryRisk
* @return int
*/
int getListParamsPageCount(QueryRiskPage queryRisk);
/**
* desc:foreach支持 many.
* descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} and name in #{name,jdbcType=VARCHAR} order by gmt_modified desc
* @param queryRisk queryRisk
* @return List
*/
List getListParamsPageResult(QueryRiskPage queryRisk);
DAO.java
/**
* desc:foreach支持 many.
* descSql = select name,risk from DC_BG_RISK_SCAN where id_card_no=#{idCardNo} and name in #{name,jdbcType=VARCHAR} order by gmt_modified desc
* @param queryRisk queryRisk
* @return QueryRiskPage
*/
public QueryRiskPage getListParamsPage(QueryRiskPage queryRisk){
int total = riskScanDOMapper.getListParamsPageCount(queryRisk);
if(total>0){
queryRisk.setDatas(riskScanDOMapper.getListParamsPageResult(queryRisk));
}
queryRisk.setTotal(total);
return queryRisk;
}
如需分页会自动创建分页类 BasePage.java
```