java - 如何在MS Access中显示开始日期和结束日期之间的日期

Question

我的代码有错误

net.ucanaccess.jdbc.UcanaccessSQLException: 
     UCAExc:::3.0.7 unexpected token: 2016 required: AND

这是我的代码

try{
    String sql = "Select id,nama,grup,tanggal from kuli where  tanggal between '"+ctgl.getText()+"' 'AND' '"+ctgl1.getText()+"'";
    pst = conn.prepareStatement(sql);
    rs = pst.executeQuery();
    jTable1.setModel(DbUtils.resultSetToTableModel(rs));
}
catch(Exception e)
{
    System.out.println(e);
}

Answer 1

SQL 应该是这样的:

String sql = "Select id, nama, grup, tanggal from kuli where tanggal between #" + ctgl.getText() + "# and #" + ctgl1.getText() + "#";

和ctgl.getText()和ctgl1.getText()必须返回格式为:2016/11/05

的字符串