myBatis+mysql获取插入数据的自增长id
来源:互联网 发布:彩虹网站监控源码 编辑:程序博客网 时间:2024/04/29 21:46
com.giantstone.ntga.mapping.message.xml
<?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.giantstone.ntga.dao.MessageMapper"><resultMap id="MessageMap" type="com.giantstone.ntga.model.Message"><id column="message_id" property="messageId" jdbcType="BIGINT" /><result column="content" property="content" jdbcType="VARCHAR" /><result column="sender_id" property="senderId" jdbcType="VARCHAR" /><result column="content" property="content" jdbcType="VARCHAR" /><result column="create_time" property="createTime" jdbcType="TIMESTAMP" /><result column="deleted" property="deleted" jdbcType="VARCHAR" /></resultMap><insert id="insertMessage" parameterType="com.giantstone.ntga.model.Message" useGeneratedKeys="true" keyProperty="messageId">insert into message2(content,sender_id,create_time,deleted) values(#{content},#{senderId},now(),'0') </insert></mapper>
package com.giantstone.ntga.dao;import java.util.Map;import com.giantstone.ntga.model.Message;public interface MessageMapper {/**添加消息**/public int insertMessage(Message message) throws Exception;}
com.giantstone.ntga.service.MessageService.java
package com.giantstone.ntga.service;import java.util.HashMap;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.giantstone.ntga.dao.MessageMapper;import com.giantstone.ntga.dao.MessageReceiverMapper;import com.giantstone.ntga.model.Message;import com.giantstone.ntga.model.MessageReceiver;@Servicepublic class MessageService {@Autowiredprivate MessageMapper messageMapper;@Autowiredprivate MessageReceiverMapper messageReceiverMapper;/**添加消息**/public void addMessage(Message message,String receivers) throws Exception{Map<String,Object> map = new HashMap<String,Object>();map.put("message", message);System.out.println("before当前插入的id为"+message.getMessageId());int id = messageMapper.insertMessage(message);System.out.println("after当前插入的id为"+message.getMessageId());}}
- myBatis+mysql获取插入数据的自增长id
- Mybatis获取插入记录的自增长ID
- MyBatis获取插入记录的 id 自增长字段值
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- Mybatis获取插入记录的自增长ID
- mybatis返回插入数据的自增长id
- k路归并(败者树,记录败者)
- toj2034 Just the Facts
- 理想、激情、生存——位技术管理人员的20年工作经历和感悟(1) .
- C#中的Dictionary字典类介绍
- 黑马程序员------集合框架(No.1)(概述、迭代器、List集合、Iterator)
- myBatis+mysql获取插入数据的自增长id
- 阿里巴巴笔试题
- MapReduce调度与执行原理之任务调度(续)
- C中的一些简单词法
- html整理
- 本博免责声明
- 错误信息BeanUtils.populate
- javascript常用对象
- JAVA和PHP通用的加解密整理版