自定义SQl的使用返回值

自定义sql

Sql sql = Sqls.create("insert into agent_document"
				+ " (document_name,document_type,document_address,create_time,create_by)"
				+ " values"
				+ " (@document_name,@document_type,@document_address,@create_time,@create_by)");
		
		sql.setParam("document_name", pic.getPic_title());
		sql.setParam("document_type", "jpg");
		sql.setParam("document_address", pic.getPic_url());
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		sql.setParam("create_time",sdf.format(new Date()));
		sql.setParam("create_by", user.getId());
		dao().execute(sql);

我该怎么拿到插入后的主键？

wendal

1楼•2851天前

用dao.insert(map)就好了, 下面是演示代码.

		dao.drop("t_test"); // 
		dao.execute(Sqls.create("create table t_test(id int AUTO_INCREMENT PRIMARY KEY , name varchar(256) )"));
		NutMap map = new NutMap(".table", "t_test");
		map.setv("+*id", 0);
		map.setv("name", "wendal");
		dao.insert(map);
		int id = map.getInt("id");

请先登陆