MyBatis增删查改【java基础】

------------------------------------------------------
-----------------自定义-查询举例----------------------
------------------------------------------------------
-------------------------mapper.xml:-------------------------

select * 
 from sys_project
 where id=#{id}
 order by createDate

-----------------------mapper:------------------------


List queryListById(@Param("id") String id);

---------------------serviceImpl:---------------------
@Autowired
private ProjectMapper projectMapper;

List projectModel=projectMapper.queryListById(id.toString());
-----------------------------------------------------
-----------------自定义-删除举例---------------------
-----------------------------------------------------
-----------------------mapper.xml:--------------------------

delete from sys_project
 where id=#{id}

-----------------------mapper:-----------------------

int deleteById(@Param("id") Integer id);

--------------------serviceImpl:---------------------
@Autowired
private ProjectMapper projectMapper;
//直接写删除方法。
projectMapper.deleteById(id);

-----------------------------------------------------
-----------------自定义-修改举例---------------------
-----------------------------------------------------
-----------------------mapper.xml:--------------------------

update sys_project set projectName=#{projectName} where id=#{id}

-----------------------mapper:-----------------------

int updateByIdData(@Param("projectName") String projectName, @Param("id") Integer id);

--------------------serviceImpl:---------------------
@Autowired
private ProjectMapper projectMapper;
//更新数据：
projectMapper.updateByIdData(proName,id);

-----------------------------------------------------
-----------------自定义-添加举例---------------------
-----------------------------------------------------
----------------------mapper.xml:--------------------------




insert into sys_project

	
		id,
	
	
		projectTitle,
	
	.....
	
	.....


	
		#{id,jdbcType=INTEGER},
	
	
		#{projectTitle,jdbcType=VARCHAR},
	
	.....
	


-----------------------mapper:-----------------------

Integer insertSelectiveData(ProjectModel data);

--------------------serviceImpl:---------------------
@Autowired
private ProjectMapper projectMapper;

ProjectModel projectModel=new ProjectModel();
projectModel.setProjectTitle(xxxx);
.....
.....
//添加数据：
projectMapper.insertSelectiveData(projectModel);

//若使用自动生成的，不用写mapper和xml，直接用自动生成的xml中的insert即可。
//举例：
int i=projectMapper.insertSelective(data); 
if(i>0){
logger.info("添加"+xxx+"数据成功。");
}
--------------------------------------------------------------------------
--------------------------------------------------------------------------