/**
* 添加
* @param nickName
* @param sex
* @param age
* @param introduce
* @return
*/
int AddInfo(@Param("nickName")String nickName,
@Param("sex")int sex,
@Param("age")int age,
@Param("introduce")String introduce);
/**
* 修改
* @param nickName
* @param id
* @return
*/
int UpdateInfo(@Param("nickName")String nickName,
@Param("id")int id);
/**
* 删除
* @param id
* @return
*/
int DeleteById(@Param("id")int id);
<insert id="AddInfo">
insert into users values(0,Now(),"${nickName}",${sex},${age},"${introduce}");
</insert>
<update id="UpdateInfo">
update users set nickName="${nickName}" where id=#{id}
</update>
<delete id="DeleteById">
delete from users where id=#{id}
</delete>
public static void main(String[] args) throws IOException {
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession sqlSession = sessionFactory.openSession();
UsersMapper db = sqlSession.getMapper(UsersMapper.class);
//添加
int rows = db.AddInfo("安琦", 0, 20, "美貌");
System.out.println(rows>0?"添加成功":"添加失败");
rows = db.UpdateInfo("安琦", 5);
System.out.println(rows>0?"修改成功":"修改失败");
rows = db.DeleteById(6);
System.out.println(rows>0?"删除成功":"删除失败");
sqlSession.commit();
sqlSession.close();
}
执行效果: