向oracle插入数据要注意:
插入字符串用单引号,如:insert table(col1) values('test')
插入日期型数据要格式化,如:insert table(col1) values(to_date('20031205','YYYYMMDD'))
插入字符串用单引号,如:insert table(col1) values('test')
插入日期型数据要格式化,如:insert table(col1) values(to_date('20031205','YYYYMMDD'))
首先确定,再SQLPLUS能显示正常吗?
sql=sql+" values('"+User_Name+"','"+User_Password+"','"+User_Sex+"','"+User_Email+"','"+User_Address+"','"+User_Mobile+"','"+User_Oicq+"','"+User_Birthday+"','"+User_Icon+"','"+User_Sign+"',0,1,'新手上路','"+yy.getTime()+"','在线','1')";
这段语句有问题吗?
access与oracle有不对应类型
修改为:
sysdate
/sport/bbs/queryuser.jsp:91: Undefined variable or class name: sysdate
sql=sql+" values('"+User_Name+"','"+User_Password+"','"+User_Sex+"','"+User_Email+"','"+User_Address+"','"+User_Mobile+"','"+User_Oicq+"','"+User_Birthday+"','"+User_Icon+"','"+User_Sign+"',0,1,'\u65b0\u624b\u4e0a\u8def','"+sysdate.getTime()+"','\u5728\u7ebf','1')";
^
Note: E:\resin\doc\WEB-INF\work\_sport\_bbs\_queryuser__jsp.java uses or
overrides a deprecated API. Recompile with "-deprecation" for details.
1 error, 2 warnings
改了就报错!