在网上找了好久,不是方法过时,就是转的类型不匹配String riqi=((ZiChanLeiBieGuanLi)jf).goumairiqi.getText();
DateFormat df=new SimpleDateFormat("yyyy-MM-dd");
Date day = null;
try {
day = df.parse(riqi);
} catch (ParseException ex1) {
}
PreparedStatement写的SQL语句内含有 ?
用setDate(1,day);
语法不给通过
DateFormat df=new SimpleDateFormat("yyyy-MM-dd");
Date day = null;
try {
day = df.parse(riqi);
} catch (ParseException ex1) {
}
PreparedStatement写的SQL语句内含有 ?
用setDate(1,day);
语法不给通过
多查查API。这些都有的。
推荐第二种 PreparedStatement p = ...
String str = "2008-12-13";
// 方法1
p.setDate(1, java.sql.Date.valueOf(str));
// 方法2
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
java.util.Date d = null;
try {
d = df.parse(str);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (d != null) {
p.setDate(1, new java.sql.Date(d.getTime()));
}
程序是可以执行成功,但是日期和输入的不一样.......
s.executeUpdate("insert into gudingzichan(zichanName,zichanleibie,zichanxinghao,zichanmoney,zichanday,zichanzhuangtai,zichanshiyongzhe,beizhu) values('"+mingchen+"','"+leibie+"','"+xinghao+"',"+jiazhi+","+new java.sql.Date(d.getTime())+",'"+zhuangtai+"','"+shiyongzhe1+"','"+beizhu1+"')");输2007-12-22 数据库里添加的1905-5-22 郁闷了
没有执行可选特性这个是啥?贴上来看看,至少是哪一句报这个错误?
日期不能用Statement?
否则不行。即使你本地能用,传到其它操作系统上,就不能用了!
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterDate(JdbcOdbc.java:809)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setDate(JdbcOdbcPreparedStatement.java:824)
at project.XinXiXiouGaiJianTingQi.actionPerformed(XinXiXiouGaiJianTingQi.java:44)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
ODBC 不支持 setDate(); 哈哈哈
你换 JDBC 吧!!!