mybatis 日期类型及布尔类型数据更新插入

最新推荐文章于 2024-06-14 10:07:40 发布

qq_38599908

最新推荐文章于 2024-06-14 10:07:40 发布

阅读量737

点赞数

分类专栏：自学笔记文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/qq_38599908/article/details/125809843

版权

自学笔记专栏收录该内容

36 篇文章 0 订阅

订阅专栏

mybatis 日期类型及布尔类型数据更新插入

数据库结构: 涉及整形、字符型、布尔型、字符型、浮点型、字符串型数据类型

DROP TABLE IF EXISTS `basicdata`;
CREATE TABLE `basicdata`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `sid` int NULL DEFAULT NULL,
  `first_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `last_name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `gender` bit(1) NULL DEFAULT b'0',
  `age` tinyint NULL DEFAULT 100,
  `member` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '\0',
  `chinese_score` float(5, 2) NULL DEFAULT 1.11,
  `math_score` float(5, 2) NULL DEFAULT 2.22,
  `english_score` float(5, 2) NULL DEFAULT 3.33,
  `political_score` float(5, 2) NULL DEFAULT 4.44,
  `total_score` float(6, 2) NULL DEFAULT NULL,
  `ip_address` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ABCDE',
  `contact_phone` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '01234567',
  `join_date` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

xxxx.java 节选[接口文件]

Integer addBasicdataInfo(Basicdata basicdata);

xxxxMapper.xml节选

<insert id="addBasicdataInfo" parameterType="Basicdata">
        insert into basicdata(sid,first_name,last_name,email,gender,age,member,chinese_score,math_score,english_score,political_score,total_score,ip_address,address,contact_phone,join_date)
            values(#{sid},#{firstName},#{lastName},#{eMail},#{gender},#{age},#{member},#{chineseScore},#{mathScore},#{englishScore},#{politicalScore},#{totalScore},#{ipAddress},#{address},#{contactPhone},#{joinDate,jdbcType=DATE})
</insert>

调用测试文件节选

@Test
public void testaddBasicdataInfo() {
    int num = sqlSession.insert("addBasicdataInfo",new Basicdata(21002022,"aaa11","bbb11","ssss@abc.com", (char) 1,28,Boolean.FALSE,
            80.5F,89.00F,18.5F,25.00F,0.00F,"11.11.11.11","aabbcc","13311112222", Date.valueOf("2021-2-5")));
    System.out.println(num);
}

划重点：
 布尔型数据输入格式：Boolean.FALSE 或 Boolean.TURE 只有两种选择
 字符型数据输入格式：(char) 1
 日期型数据输入格式：Date.valueOf("yyyy-mm-dd"), XML 中参数渗格式要有限定：#{joinDate,jdbcType=DATE}