MyBatis无xml配置
1.查询:@SelectProvider
2.更新:@UpdateProvider
3.删除: @DeleteProvider
4.插入:@InsertProvider
CSRCReportsMapper.java
//查询条件获取表中数据
@SelectProvider(type = CSRCReportsMapperProvider.class, method = "getRowsMbyWhere")
public List<TParColumValueVO> getRowsMbyWhere(@Param("colums") List<TParFuncColumVO> colums,
@Param("maps") Map<String, String> maps);
//更新表中数据
@UpdateProvider(type = CSRCReportsMapperProvider.class, method = "updateTable")
public void updateTable(@Param("clomList") List<TParFuncColumVO> clomList,
@Param("listvalue") List<TParColumValueVO> listvalue);
//删除数据
@DeleteProvider(type = CSRCReportsMapperProvider.class, method = "deleteTable")
public void deleteTable(@Param("table") String table, @Param("id") Integer id);
//插入数据
@InsertProvider(type = CSRCReportsMapperProvider.class, method = "insertTable")
public void insertTable(@Param("table") String table,
@Param("clomList") List<TParFuncColumVO> clomList,
@Param("listvalue") List<TParColumValueVO> listvalue,
@Param("opdate") String opdate);
CSRCReportsMapperProvider.java
public class CSRCReportsMapperProvider {
/**
* 动态查询表数据
*/
public String getRowsM(final Map<String,Object> map){
List<TParFuncColumVO> colums = (List<TParFuncColumVO>)map.get("colums");
StringBuffer sb = new StringBuffer("select ");
String table ="";
StringBuffer from = new StringBuffer("");
if (null != colums && colums.size() > 0) {
for (int i = 0; i < colums.size(); i++) {
TParFuncColumVO curfield = colums.get(i);
String curTable = curfield.getFuncid();
if (i == colums.size() - 1) {
sb.append(colums.get(i).getOthername()+"."+colums.get(i).getColumname2() + &#