mybatis的mapper.xml中获取自增后的id值在别的表使用这是开发中经常要用到的那要怎样用呢
首先在DAO接口插入方法
List<User> find();
int add(User u);
int addUID(Object id);
xxMapper.xml中写上
<insert id="add" useGeneratedKeys="true" keyProperty="id">
insert user values(null,#{name},#{password})
</insert>
<insert id="addUID">
insert userid values(null,#{id})
</insert>
在java中调用即可
controller层
package com.mhys.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.mhys.bean.User;
import com.mhys.service.UserService;
@Controller
public class UserController {
@Autowired
UserService us;
@RequestMapping("/")
public String find(Model model) {
List<User> list=us.find();
model.addAttribute("list", list);
return "userList.jsp";
}
@RequestMapping("/addUser")
public String addUser(Model model,User u) {
int num=us.add(u);
/* int uid= */
Object id=u.getId();
int uid=us.addUID(id);
return "/";
}
}
这段是重点不能删除要不然就掉用不到了