Mybatis获取Sql数据库自动生成的主键信息并设置它与映射对象的关系-----Mybatis框架

墨蓝 2024-03-08 08:51 7阅读 0赞

>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="com.powernode.mybatis.Mapper.CarMapper">
>         <delete id="deleteBatch">
>             delete from
>                 t_car
>             where
>                 car_num
>             in
>                 (${carNums});
>         </delete>
>     
>     
>         <insert id="insertCarUserGeneratedKey" useGeneratedKeys="true" keyProperty="id">
>             insert into
>                 t_car
>             values(null,#{carNum},#{brand},#{guidePrice},#{produceTime},#{carType});
>         </insert>
>         <select id="selectByBrand" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             where
>     --             brand like '%${brand}%'
>     --             brand like concat('%',#{brand},'%')
>                 brand like concat('%','${brand}','%')
>                 brand like concat("%"#{brand}"%")
>         </select>
>         <select id="selectByCarType" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             where
>                 car_type = #{carType}
>         </select>
>         <select id="selectAllByAscOrDesc" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             order by
>                 guide_price ${DescOrAsc};
>         </select>
>     </mapper>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="com.powernode.mybatis.Mapper.CarMapper">
>         <delete id="deleteBatch">
>             delete from
>                 t_car
>             where
>                 car_num
>             in
>                 (${carNums});
>         </delete>
>     
>     
>         <insert id="insertCarUserGeneratedKey" useGeneratedKeys="true" keyProperty="id">
>             insert into
>                 t_car
>             values(null,#{carNum},#{brand},#{guidePrice},#{produceTime},#{carType});
>         </insert>
>         <select id="selectByBrand" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             where
>     --             brand like '%${brand}%'
>     --             brand like concat('%',#{brand},'%')
>                 brand like concat('%','${brand}','%')
>                 brand like concat("%"#{brand}"%")
>         </select>
>         <select id="selectByCarType" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             where
>                 car_type = #{carType}
>         </select>
>         <select id="selectAllByAscOrDesc" resultType="Car">
>             select
>                 id as id,
>                 car_num as carNum,
>                 brand as brand,
>                 guide_price as guidePrice,
>                 produce_time as produceTime,
>                 car_type as carType
>             from
>                 t_car
>             order by
>                 guide_price ${DescOrAsc};
>         </select>
>     </mapper>

>     package com.powernode.mybatis.Mapper;
>     
>     import com.powernode.mybatis.POJO.Car;
>     
>     import java.util.List;
>     
>     public interface CarMapper
>     {
>         int insertCarUserGeneratedKey(Car car);
>         //根据汽车类型,获取汽车信息
>         List<Car> selectByCarType(String carType);
>         //查询所有的汽车信息,通过DESC或者ASC升降序
>         List<Car> selectAllByAscOrDesc(String AscOrDesc);
>         //根据ID进行批量删除
>         int deleteBatch(String carNums);
>         List<Car> selectByBrand(String brand);
>     }
> 
>     package com.powernode.mybatis.Mapper;
>     
>     import com.powernode.mybatis.POJO.Car;
>     
>     import java.util.List;
>     
>     public interface CarMapper
>     {
>         int insertCarUserGeneratedKey(Car car);
>         //根据汽车类型,获取汽车信息
>         List<Car> selectByCarType(String carType);
>         //查询所有的汽车信息,通过DESC或者ASC升降序
>         List<Car> selectAllByAscOrDesc(String AscOrDesc);
>         //根据ID进行批量删除
>         int deleteBatch(String carNums);
>         List<Car> selectByBrand(String brand);
>     }

>     package com.powernode.mybatis.Test;
>     
>     import com.powernode.mybatis.Mapper.CarMapper;
>     import com.powernode.mybatis.Mapper.LogMapper;
>     import com.powernode.mybatis.POJO.Car;
>     import com.powernode.mybatis.POJO.Log;
>     import com.powernode.mybatis.utils.SqlSessionUtils;
>     import org.apache.ibatis.session.SqlSession;
>     import org.junit.Test;
>     
>     import java.util.Iterator;
>     import java.util.List;
>     
>     public class CarMapperTest
>     {
>         @Test
>         public void TestGenerate()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             CarMapper mapper = sqlSession.getMapper(CarMapper.class);
>             Car car = new Car(null, "9991", "长安", 10.0, "2020-11-11", "燃油车");
>             int num = mapper.insertCarUserGeneratedKey(car);
>             sqlSession.commit();
>             SqlSessionUtils.close(sqlSession);
>             System.out.println(num);
>         }
>     }
> 
>     package com.powernode.mybatis.Test;
>     
>     import com.powernode.mybatis.Mapper.CarMapper;
>     import com.powernode.mybatis.Mapper.LogMapper;
>     import com.powernode.mybatis.POJO.Car;
>     import com.powernode.mybatis.POJO.Log;
>     import com.powernode.mybatis.utils.SqlSessionUtils;
>     import org.apache.ibatis.session.SqlSession;
>     import org.junit.Test;
>     
>     import java.util.Iterator;
>     import java.util.List;
>     
>     public class CarMapperTest
>     {
>         @Test
>         public void TestGenerate()
>         {
>             SqlSession sqlSession = SqlSessionUtils.openSession();
>             CarMapper mapper = sqlSession.getMapper(CarMapper.class);
>             Car car = new Car(null, "9991", "长安", 10.0, "2020-11-11", "燃油车");
>             int num = mapper.insertCarUserGeneratedKey(car);
>             sqlSession.commit();
>             SqlSessionUtils.close(sqlSession);
>             System.out.println(num);
>         }
>     }