请教Access数据库的连接?

String sql="";
sql=sql+"insert ito wglmessage";
sql=sql+"(code,";
sql=sql+"stime,";
sql=sql+"etime,";
sql=sql+"hours,";
sql=sql+"cause,";
sql=sql+"time)";

sql=sql+" values (";
sql=sql+"'"+personid+"',";
sql=sql+"'"+sdate+"',";
sql=sql+"'"+eday+"',";
sql=sql+"'"+hours+"',";
sql=sql+"'"+cause+"',";
sql=sql+"getdate())";
ResultSet rs=stmt.executeQuery(sql);
我是这样写的,但提示说"org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。"
痛苦!
----------------解决方案--------------------------------------------------------
不好意思,sql=sql+"insert ito wglmessage";这句是这样的sql=sql+"insert into wglmessage";

----------------解决方案--------------------------------------------------------

是请教这个插入语句的语法！

----------------解决方案--------------------------------------------------------

你是不是把标识例也给了??

----------------解决方案--------------------------------------------------------
用executeQuery去执行INSERT!!!!
QUERY当然是用来查询的!这个你首先要注意!

sql=sql+"getdate())";这个为什么不加单引号?


----------------解决方案--------------------------------------------------------

输出sql一下,看看有什么错误.

----------------解决方案--------------------------------------------------------

用executeupdate(sql)

----------------解决方案--------------------------------------------------------

executeupdate(sql),该语句的返回值类型是int?

----------------解决方案--------------------------------------------------------
6楼的DX,这是提示信息:"org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。"
----------------解决方案--------------------------------------------------------
首先确定你插入类型都是正确的,第二确定getdate()是正确的!因为在ACCESS中得到当前日期是date()好象!!!!

----------------解决方案--------------------------------------------------------