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()好象!!!!