怎么获取到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();