javaFX Problemi nella selezione della listView

[paul78]

ragazzi io per la modifica scrivo questo:

String query = "UPDATE persone SET nome=?, cognome=? where id=?";           			        

						

ps = (PreparedStatement) conn.prepareStatement(query);       			        			        			       			
        			
ps.setInt(1, updateID);					         			
ps.setString(2, updateNome);
ps.setString(3, updateCognome);					
ps.executeUpdate();

ma mi da sempre errore!!!

[andbin]

String query = "UPDATE persone SET nome=?, cognome=? where id=?";           			        

ps.setInt(1, updateID);					         			
ps.setString(2, updateNome);
ps.setString(3, updateCognome);

ma mi da sempre errore!!!

Il primo ? è per il nome e tu gli passi il updateID (int).
Il secondo ? è per il cognome e tu gli passi il nome.
Il terzo ? è per il id di filtro e tu gli passi il cognome (String).

Secondo te?

[paul78]

String query = "UPDATE persone SET nome=?, cognome=? where id=?";           			        							
ps = (PreparedStatement) conn.prepareStatement(query);       			        			        			       			
        			
ps.setString(1, updateNome);
ps.setString(2, updateCognome);
ps.setInt(3, updateID);					         									
										       			
ps.executeUpdate();

già fatto!!! ma mi da lo stesso errore!!!

[andbin]

ma mi da lo stesso errore!!!

Dando ora per scontato che almeno i parametri sono appropriati .... quale errore? Se hai una eccezione dicci quale.

[paul78]

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'id' in 'where clause'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:20 02)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2427)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2345)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2330)
at EsempioJDBC$2.handle(EsempioJDBC.java:265)
at EsempioJDBC$2.handle(EsempioJDBC.java:1)
at com.sun.javafx.event.CompositeEventHandler.dispatc hBubblingEvent(Unknown Source)
at com.sun.javafx.event.EventHandlerManager.dispatchB ubblingEvent(Unknown Source)
at com.sun.javafx.event.EventHandlerManager.dispatchB ubblingEvent(Unknown Source)
at com.sun.javafx.event.CompositeEventDispatcher.disp atchBubblingEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.EventUtil.fireEventImpl(Unkno wn Source)
at com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
at javafx.event.Event.fireEvent(Unknown Source)
at javafx.scene.Node.fireEvent(Unknown Source)
at javafx.scene.control.Button.fire(Unknown Source)
at com.sun.javafx.scene.control.behavior.ButtonBehavi or.mouseReleased(Unknown Source)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase $1.handle(Unknown Source)
at com.sun.javafx.scene.control.skin.BehaviorSkinBase $1.handle(Unknown Source)
at com.sun.javafx.event.CompositeEventHandler$NormalE ventHandlerRecord.handleBubblingEvent(Unknown Source)
at com.sun.javafx.event.CompositeEventHandler.dispatc hBubblingEvent(Unknown Source)
at com.sun.javafx.event.EventHandlerManager.dispatchB ubblingEvent(Unknown Source)
at com.sun.javafx.event.EventHandlerManager.dispatchB ubblingEvent(Unknown Source)
at com.sun.javafx.event.CompositeEventDispatcher.disp atchBubblingEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.BasicEventDispatcher.dispatch Event(Unknown Source)
at com.sun.javafx.event.EventDispatchChainImpl.dispat chEvent(Unknown Source)
at com.sun.javafx.event.EventUtil.fireEventImpl(Unkno wn Source)
at com.sun.javafx.event.EventUtil.fireEvent(Unknown Source)
at javafx.event.Event.fireEvent(Unknown Source)
at javafx.scene.Scene$MouseHandler.process(Unknown Source)
at javafx.scene.Scene$MouseHandler.access$1800(Unknow n Source)
at javafx.scene.Scene.impl_processMouseEvent(Unknown Source)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Un known Source)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$Mo useEventNotification.run(Unknown Source)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$Mo useEventNotification.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.ha ndleMouseEvent(Unknown Source)
at com.sun.glass.ui.View.handleMouseEvent(Unknown Source)
at com.sun.glass.ui.View.notifyMouse(Unknown Source)
at com.sun.glass.ui.win.WinApplication._runLoop(Nativ e Method)
at com.sun.glass.ui.win.WinApplication.access$300(Unk nown Source)
at com.sun.glass.ui.win.WinApplication$4$1.run(Unknow n Source)
at java.lang.Thread.run(Unknown Source)

[paul78]

EsempioJDBC.java:265

SI TROVA ESATTEMENTE AL ps.executeUpdate();

[andbin]

Unknown column 'id' in 'where clause'

La tua tabella 'persone' ha la colonna "id"? Puoi mostrare come l'hai creata? (la tabella intendo, se da script SQL)

[paul78]

l'ho creato con interfaccia grafica di mysql.

cmq ora vado a controllare lo script in mysql

[paul78]

ragazzi!!!

l'id era "idpersone"

eppure ero certo di aver scritto solo id!!!

cmq grazie a te ho capito che devo anche rivedere lo script di mysql!

grazie mille!!!