java - SQL未在java方法中执行

Question

我在java中编写了一个方法来执行一些SQL，但它似乎没有执行（在调试器中它没有向我显示返回的任何值，只是将sql作为字符串）。我认为我插入 ID 存在问题，因为它会重复但不知道如何解决。

 public void addPrevious(TodaysDate Date){
        String id = ("SELECT ID FROM table1 where DATE_ = (SELECT ID FROM _DATE WHERE ID = ( SELECT MAX(ID) FROM _DATE WHERE ID < ( SELECT MAX(ID) FROM _DATE ) ))");
        String paymentDate = ("SELECT PAYMENTDATE FROM table1  where DATE = (SELECT ID FROM _DATE WHERE ID = ( SELECT MAX(ID) FROM _DATE WHERE ID < ( SELECT MAX(ID) FROM _DATE ) ))");
        String reportingUnit = ("SELECT REPORTING_UNIT FROM table1  where DATE = (SELECT ID FROM _DATE WHERE ID = ( SELECT MAX(ID) FROM _DATE WHERE ID < ( SELECT MAX(ID) FROM _DATE ) ))");
        String insertLastDate =  ("INSERT INTO table1(PAYMENTDATE, REPORTING_UNIT, DATE) VALUES  ("+id+" ,"+paymentDate+", "+amount+", "+asOfDate+")");

    }

我正在尝试将前几天的结果添加到具有更新日期的同一个表中，以便它也显示当前日期，程序仅显示当前日期结果。TodaysDate 类处理获取当前日期

标签： javasql