将oracel中date类型的数据以to_char方式查找出来:
rs=stmt.executeQuery("select gamedata.name , game.no ,place.name ,to_char(game.stime,'YYYY-MM-DD HH24:MI:SS' ),to_char(game.etime,'YYYY-MM-DD HH24:MI:SS') ,gamedata.type from game,gamedata,place where game.gameid=gamedata.id and game.placeid=place.id and game.no="+No);
对查出来的数据进行修改:
sql="update game set gameID='"+tgameID;
sql=sql+"',placeid='"+tplaceid;
sql=sql+"',stime=to_date('"+stime.getText();
sql=sql+"','YYYY-MM-DD HH24:MI:SS'),etime=to_date('"+etime.getText();
sql=sql+"','YYYY-MM-DD HH24:MI:SS'), where no="+No;
stmt.executeUpdate(sql);
报错:java.sql.SQLException: ORA-01747: 无效的用户.表.列,表.列,或列规格
问题描写完毕 哪位大侠来帮忙看看
rs=stmt.executeQuery("select gamedata.name , game.no ,place.name ,to_char(game.stime,'YYYY-MM-DD HH24:MI:SS' ),to_char(game.etime,'YYYY-MM-DD HH24:MI:SS') ,gamedata.type from game,gamedata,place where game.gameid=gamedata.id and game.placeid=place.id and game.no="+No);
对查出来的数据进行修改:
sql="update game set gameID='"+tgameID;
sql=sql+"',placeid='"+tplaceid;
sql=sql+"',stime=to_date('"+stime.getText();
sql=sql+"','YYYY-MM-DD HH24:MI:SS'),etime=to_date('"+etime.getText();
sql=sql+"','YYYY-MM-DD HH24:MI:SS'), where no="+No;
stmt.executeUpdate(sql);
报错:java.sql.SQLException: ORA-01747: 无效的用户.表.列,表.列,或列规格
问题描写完毕 哪位大侠来帮忙看看
谢谢各位高手的帮忙