MyBatis学习之注解式开发

最新推荐文章于 2024-11-09 15:56:43 发布

优降宁

最新推荐文章于 2024-11-09 15:56:43 发布

阅读量229

点赞数

分类专栏： mybatis学习笔记文章标签： mybatis 学习

本文链接：https://blog.csdn.net/yjnlovepy/article/details/131967832

版权

mybatis学习笔记专栏收录该内容

14 篇文章 0 订阅

订阅专栏

文章展示了MyBatis中如何使用注解进行数据库操作，包括@Insert用于插入数据，@Delete删除记录，@Update更新条目，以及@Select查询信息。此外，还提到了@Results注解用于映射查询结果到对象属性。

摘要由CSDN通过智能技术生成

mybatis中也提供了注解式开发方式，采用注解可以减少Sql语句的维护带来的成本

原则：简单sql可以注解，复杂sql使用xml

@Insert

// CarMapper.java
@Insert("insert into t_car values(null,#{carNum},#{brand},#{guidePrice},#{produceTime},#{carType})")
int insert(Car car);

//test文件
@Test
public void test(){
	SqlSession sqlSession = SqlSessionUtil.openSession();
	CarMapper mapper = sqlSession.getMapper(CarMapper.class);
	Car car = new Car(null,null,null,null,null,null,null);
	int count = mapper.insert(car);
	System.out.println(count);
	sqlSession.commit();
	sqlSession.close();
}

@Delete

@Delete( "delete from t_car where id = #{id}")
int deleteById(Long id);

//test文件
@Test
public void test2(){
	SqlSession sqlSession = SqlSessionUtil.openSession();
	CarMapper mapper = sqlSession.getMapper(CarMapper.class);
	int count = mapper.deleteById(5L);
	System.out.println(count);
	sqlSession.commit();
	sqlSession.close();
}

@Update

@Update("updeate t_car set car_num=#{carNum} , brand=#{brand} , guide_price=#{guidePrice} produce_time=#{produceTime} , car_type=#(carType} where id=#{id}" )
int update(Car car);

//test文件
@Test
public void test3(){
	SqlSession sqlSession = SqlSessionUtil.openSession();
	CarMapper mapper = sqlSession.getMapper(CarMapper.class);
	Car car = new Car(6L,null,null,null,null,null,null);
	int count = mapper.update(car);
	System.out.println(count);
	sqlSession.commit();
	sqlSession.close();
}

@Select

@select( "select * from t_car where id =#{id}")
Car selectById(Long id);

//test文件
@Test
public void test4(){
	SqlSession sqlSession = SqlSessionUtil.openSession();
	CarMapper mapper = sqlSession.getMapper(CarMapper.class);
	int count = mapper.select(5L);
	System.out.println(count);
	sqlSession.commit();
	sqlSession.close();
}

@Results

@Select( "select * from t_car where id = #{id}")
@Results({
	@Result(property = "id" , column = "id"),
	@Result(property = "carNum",column = "car_num"),
	@Result(property = "brand" , column = "brand")，
	@Result(property = "guidePrice" , column = "guide_price"),
	@Result(property = "produceTime" , column = "produce_time"),
	@Result(property = "carType", column = "car_type ")
})
Car selectById(Long id);