mysql mybatis自增长id赋值_myBatis+mysql获取插入数据的自增长id | 学步园

com.giantstone.ntga.mapping.message.xml

insert into message2(content,sender_id,create_time,deleted) values(

#{content}

,#{senderId}

,now()

,'0'

)

com.giantstone.ntga.dao.MessageMapper.java

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.javapackage 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;

@Service

public class MessageService {

@Autowired

private MessageMapper messageMapper;

@Autowired

private MessageReceiverMapper messageReceiverMapper;

public void addMessage(Message message,String receivers) throws Exception{

Map map = new HashMap();

map.put("message", message);

System.out.println("before当前插入的id为"+message.getMessageId());

int id = messageMapper.insertMessage(message);

System.out.println("after当前插入的id为"+message.getMessageId());

}

}