怎么获取到sql的主键id值？

Question

sql = "insert into news_base(fid,title,date,author) values("+fid+",'"+title+"','"+dateValue+"','Admin')";            statement = connection.createStatement();            statement.executeUpdate(sql);                        sql1 = "insert into news_content (cid,fid,content) values("+cid+","+fid+",'"+content+"')";            statement1 = connection.createStatement();            statement1.executeUpdate(sql1);news_content表的cid，我要用news_base的id来传进入。。关键是怎么获取到news_base表的主键id？

Answer 1

SELECT LAST_INSERT_ID();