Mybatis通过parameterType来设置插入的信息类型-----Mybatis框架

悠悠 2024-03-08 08:55 46阅读 0赞 
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.     <properties resource="jdbc.properties"/>
  7.     <settings>
  8.         <setting name="logImpl" value="SLF4J"/>
  9.     </settings>
  10.     <typeAliases>
  11.         <package name="com.powernode.mybatis.POJO"/>
  12.     </typeAliases>
  13.     <environments default="development">
  14.         <environment id="development">
  15.             <transactionManager type="JDBC"/>
  16.             <dataSource type="POOLED">
  17.                 <property name="driver" value="${jdbc.driver}"/>
  18.                 <property name="url" value="${jdbc.url}"/>
  19.                 <property name="username" value="${jdbc.username}"/>
  20.                 <property name="password" value="${jdbc.password}"/>
  21.             </dataSource>
  22.         </environment>
  23.     </environments>
  24.     <mappers>
  25.         <package name="com.powernode.mybatis.Mapper"/>
  26.     </mappers>
  27. </configuration>
  29. <?xml version="1.0" encoding="UTF-8" ?>
  30. <!DOCTYPE configuration
  31.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  32.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  33. <configuration>
  34.     <properties resource="jdbc.properties"/>
  35.     <settings>
  36.         <setting name="logImpl" value="SLF4J"/>
  37.     </settings>
  38.     <typeAliases>
  39.         <package name="com.powernode.mybatis.POJO"/>
  40.     </typeAliases>
  41.     <environments default="development">
  42.         <environment id="development">
  43.             <transactionManager type="JDBC"/>
  44.             <dataSource type="POOLED">
  45.                 <property name="driver" value="${jdbc.driver}"/>
  46.                 <property name="url" value="${jdbc.url}"/>
  47.                 <property name="username" value="${jdbc.username}"/>
  48.                 <property name="password" value="${jdbc.password}"/>
  49.             </dataSource>
  50.         </environment>
  51.     </environments>
  52.     <mappers>
  53.         <package name="com.powernode.mybatis.Mapper"/>
  54.     </mappers>
  55. </configuration>
  57. <?xml version="1.0" encoding="UTF-8"?>
  59. <!DOCTYPE mapper
  60.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  61.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  63. <mapper namespace="com.powernode.mybatis.Mapper.StudentMapper">
  64. <!--    parameterType的作用是告诉Mybatis框架我们的属性是什么类型,但是大部分情况下自动推断后我们就不用写了-->
  65. <!--    parameterType其实可以写别名,Mybatis内置了很多别名-->
  66.     <select id="selectById" resultType="Student" parameterType="long">
  67.         select * from t_student where id = #{id,javaType=Long,jdbcType=BIGINT};
  68.     </select>
  69.     <select id="selectByName" resultType="Student" parameterType="String">
  70.         select * from t_student where name = #{name,javaType=String,jdbcType=VARCHAR};
  71.     </select>
  72.     <select id="selectByBirth" resultType="Student" parameterType="Date">
  73.         select * from t_student where birth = #{birth,javaType=Date,jdbcType=DATE};
  74.     </select>
  75.     <select id="selectBySex" resultType="Student" parameterType="Character">
  76.         select * from t_student where sex = #{sex,javaType=Character,jdbcType=CHAR}
  77.     </select>
  78.     <insert id="insertStudentsByMap">
  79.         insert into t_student(id,name,age,sex,birth,height) values(null,#{姓名},#{年龄},#{性别},#{生日},#{身高});
  80.     </insert>
  81.     <insert id="InsertStudentByPOJO" parameterType="com.powernode.mybatis.POJO.Student">
  82.         insert into t_student(id,name,age,sex,birth,height) values(null,#{name},#{age},#{sex},#{birth},#{height});
  83.     </insert>
  84. </mapper>
  86. <?xml version="1.0" encoding="UTF-8"?>
  88. <!DOCTYPE mapper
  89.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  90.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  92. <mapper namespace="com.powernode.mybatis.Mapper.StudentMapper">
  93. <!--    parameterType的作用是告诉Mybatis框架我们的属性是什么类型,但是大部分情况下自动推断后我们就不用写了-->
  94. <!--    parameterType其实可以写别名,Mybatis内置了很多别名-->
  95.     <select id="selectById" resultType="Student" parameterType="long">
  96.         select * from t_student where id = #{id,javaType=Long,jdbcType=BIGINT};
  97.     </select>
  98.     <select id="selectByName" resultType="Student" parameterType="String">
  99.         select * from t_student where name = #{name,javaType=String,jdbcType=VARCHAR};
  100.     </select>
  101.     <select id="selectByBirth" resultType="Student" parameterType="Date">
  102.         select * from t_student where birth = #{birth,javaType=Date,jdbcType=DATE};
  103.     </select>
  104.     <select id="selectBySex" resultType="Student" parameterType="Character">
  105.         select * from t_student where sex = #{sex,javaType=Character,jdbcType=CHAR}
  106.     </select>
  107.     <insert id="insertStudentsByMap">
  108.         insert into t_student(id,name,age,sex,birth,height) values(null,#{姓名},#{年龄},#{性别},#{生日},#{身高});
  109.     </insert>
  110.     <insert id="InsertStudentByPOJO" parameterType="com.powernode.mybatis.POJO.Student">
  111.         insert into t_student(id,name,age,sex,birth,height) values(null,#{name},#{age},#{sex},#{birth},#{height});
  112.     </insert>
  113. </mapper>
  115. package com.powernode.mybatis.Mapper;
  117. import com.powernode.mybatis.POJO.Student;
  119. import java.util.Date;
  120. import java.util.List;
  121. import java.util.Map;
  122. import java.util.Objects;
  124. public interface StudentMapper
  125. {
  126.     //通过POJO保存学生信息
  127.     int InsertStudentByPOJO(Student student);
  128.     //通过Map保存学生信息
  129.     int insertStudentsByMap(Map<String, Object> map);
  130.     List<Student> selectById(Long id);
  131.     List<Student> selectByName(String name);
  132.     List<Student> selectByBirth(Date birth);
  133.     List<Student> selectBySex(Character sex);
  134. }
  136. package com.powernode.mybatis.Mapper;
  138. import com.powernode.mybatis.POJO.Student;
  140. import java.util.Date;
  141. import java.util.List;
  142. import java.util.Map;
  143. import java.util.Objects;
  145. public interface StudentMapper
  146. {
  147.     //通过POJO保存学生信息
  148.     int InsertStudentByPOJO(Student student);
  149.     //通过Map保存学生信息
  150.     int insertStudentsByMap(Map<String, Object> map);
  151.     List<Student> selectById(Long id);
  152.     List<Student> selectByName(String name);
  153.     List<Student> selectByBirth(Date birth);
  154.     List<Student> selectBySex(Character sex);
  155. }
  157. package com.powernode.mybatis.Test;
  159. import com.powernode.mybatis.Mapper.StudentMapper;
  160. import com.powernode.mybatis.POJO.Student;
  161. import com.powernode.mybatis.Utils.SqlSessionUtil;
  162. import org.apache.ibatis.session.SqlSession;
  164. import java.text.SimpleDateFormat;
  165. import java.util.Date;
  166. import java.util.HashMap;
  167. import java.util.List;
  168. import java.util.Map;
  170. public class Test
  171. {
  172.     @org.junit.Test
  173.     public void Test()
  174.     {
  175.         SqlSession sqlSession = SqlSessionUtil.openSession();
  176.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  177.         List<Student> students = mapper.selectById(1L);
  178.         students.forEach(student -> {
  179.             System.out.println(student);
  180.         });
  181.         SqlSessionUtil.close(sqlSession);
  182.     }
  183.     @org.junit.Test
  184.     public void TestSelect()
  185.     {
  186.         SqlSession sqlSession = SqlSessionUtil.openSession();
  187.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  188.         List<Student> list = mapper.selectByName("李四");
  189.         list.forEach(l ->{
  190.             System.out.println(l);
  191.         });
  192.     }
  193.     @org.junit.Test
  194.     public void TestDate() throws Exception
  195.     {
  196.         SqlSession sqlSession = SqlSessionUtil.openSession();
  197.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  198.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  199.         Date birth = simpleDateFormat.parse("2000-10-11");
  200.         List<Student> list = mapper.selectByBirth(birth);
  201.         list.forEach(l -> {
  202.             System.out.println(l);
  203.         });
  204.     }
  205.     @org.junit.Test
  206.     public void TestSEX()
  207.     {
  208.         SqlSession sqlSession = SqlSessionUtil.openSession();
  209.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  210.         List<Student> list = mapper.selectBySex('男');
  211.         list.forEach(te -> {
  212.             System.out.println(te);
  213.         });
  214.     }
  215.     @org.junit.Test
  216.     public void TestInsertMap() throws Exception
  217.     {
  218.         SqlSession sqlSession = SqlSessionUtil.openSession();
  219.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  220.         Map<String,Object> map = new HashMap<>();
  221.         map.put("姓名","王五");
  222.         map.put("年龄",20);
  223.         map.put("身高",1.82);
  224.         map.put("性别",'男');
  225.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  226.         Date date = simpleDateFormat.parse("2001-08-14");
  227.         map.put("生日",date);
  228.         mapper.insertStudentsByMap(map);
  229.         sqlSession.commit();
  230.         SqlSessionUtil.close(sqlSession);
  231.     }
  232.     @org.junit.Test
  233.     public void TestInsertByPOJO()
  234.     {
  235.         SqlSession sqlSession = SqlSessionUtil.openSession();
  236.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  237.         Student student = new Student(null,"展会",20,1.8,new Date(),'女');
  238.         int i = mapper.InsertStudentByPOJO(student);
  239.         System.out.println(i);
  240.         sqlSession.commit();
  241.         SqlSessionUtil.close(sqlSession);
  242.     }
  243. }
  245. package com.powernode.mybatis.Test;
  247. import com.powernode.mybatis.Mapper.StudentMapper;
  248. import com.powernode.mybatis.POJO.Student;
  249. import com.powernode.mybatis.Utils.SqlSessionUtil;
  250. import org.apache.ibatis.session.SqlSession;
  252. import java.text.SimpleDateFormat;
  253. import java.util.Date;
  254. import java.util.HashMap;
  255. import java.util.List;
  256. import java.util.Map;
  258. public class Test
  259. {
  260.     @org.junit.Test
  261.     public void Test()
  262.     {
  263.         SqlSession sqlSession = SqlSessionUtil.openSession();
  264.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  265.         List<Student> students = mapper.selectById(1L);
  266.         students.forEach(student -> {
  267.             System.out.println(student);
  268.         });
  269.         SqlSessionUtil.close(sqlSession);
  270.     }
  271.     @org.junit.Test
  272.     public void TestSelect()
  273.     {
  274.         SqlSession sqlSession = SqlSessionUtil.openSession();
  275.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  276.         List<Student> list = mapper.selectByName("李四");
  277.         list.forEach(l ->{
  278.             System.out.println(l);
  279.         });
  280.     }
  281.     @org.junit.Test
  282.     public void TestDate() throws Exception
  283.     {
  284.         SqlSession sqlSession = SqlSessionUtil.openSession();
  285.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  286.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  287.         Date birth = simpleDateFormat.parse("2000-10-11");
  288.         List<Student> list = mapper.selectByBirth(birth);
  289.         list.forEach(l -> {
  290.             System.out.println(l);
  291.         });
  292.     }
  293.     @org.junit.Test
  294.     public void TestSEX()
  295.     {
  296.         SqlSession sqlSession = SqlSessionUtil.openSession();
  297.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  298.         List<Student> list = mapper.selectBySex('男');
  299.         list.forEach(te -> {
  300.             System.out.println(te);
  301.         });
  302.     }
  303.     @org.junit.Test
  304.     public void TestInsertMap() throws Exception
  305.     {
  306.         SqlSession sqlSession = SqlSessionUtil.openSession();
  307.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  308.         Map<String,Object> map = new HashMap<>();
  309.         map.put("姓名","王五");
  310.         map.put("年龄",20);
  311.         map.put("身高",1.82);
  312.         map.put("性别",'男');
  313.         SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
  314.         Date date = simpleDateFormat.parse("2001-08-14");
  315.         map.put("生日",date);
  316.         mapper.insertStudentsByMap(map);
  317.         sqlSession.commit();
  318.         SqlSessionUtil.close(sqlSession);
  319.     }
  320.     @org.junit.Test
  321.     public void TestInsertByPOJO()
  322.     {
  323.         SqlSession sqlSession = SqlSessionUtil.openSession();
  324.         StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
  325.         Student student = new Student(null,"展会",20,1.8,new Date(),'女');
  326.         int i = mapper.InsertStudentByPOJO(student);
  327.         System.out.println(i);
  328.         sqlSession.commit();
  329.         SqlSessionUtil.close(sqlSession);
  330.     }
  331. }

发表评论

表情：
评论列表 （有 0 条评论，46人围观）

还没有评论，来说两句吧...

相关阅读

    相关 mybatis parameterType

    parameterType可以是基本类型，引用类型（例如:String 类型），还可以是实体类类型（POJO 类）同时也可以使用实体类的包装类 基本类型和String我们可以

    怼烎@怼烎@/ 0 赞/ 220 阅读