[JAVA] Update di una tabella MySQL

[nikynik]

scusate ho un problema devo eseguire l'update di una tabella...
devo modificare un campo ed ho un problemino...
non so che dito di execute usare....

questo è il codice della classe che si occupa della connessione al db

public void modificaScript(String statement) 
	 throws ClassNotFoundException, SQLException
		{		 		 
	     Connection conn = null;
		 Class.forName("com.mysql.jdbc.Driver");
         String connessione=doit();
         conn = (Connection) DriverManager.getConnection(connessione);
         Statement stmt = conn.createStatement();            
         stmt.executeUpdate(statement);
         stmt.close();
			
		}

questo public void riceve questa stringa statement

String statement="UPDATE script SET nomeScript = '"+nome+"' WHERE Codice='"+codiceScript+"'";

il problema è che ho provato a modificare lo Statement con Prepared Statement
ma ottengo sempre questi errori

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''+'IPT LANGUAGE="JavaScript" TYPE="text/javascript" SRC="http://adserver.libero.' at line 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1298)
	at MetaDataMapping.modificaScript(MetaDataMapping.java:189)
	at dataMapper.modificaScript(dataMapper.java:164)
	at BusinessDelegate.modificaScript(BusinessDelegate.java:152)
	at FontController.modificaScript(FontController.java:189)
	at B_visualizza$21.actionPerformed(B_visualizza.java:1216)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

potreste dirmi come aiutarmi?....

[Ascia75]

se usi prepared statement la stringa sql dovrebbe essere tipo:

"UPDATE script SET nomeScript = ? WHERE Codice=?";

poi coi metodi set (setString, setInt etc..) inserisci i parametri al posto dei punti interrogativi

ipotizzando che tu hai due variabili nomeScript e codiceScript sarà una cosa tipo:

stmt.setString(1, nomeScript);
stmt.setInt(2,codiceScript);

[R@ve M@ster]

E' probabile che "nome" e/o "codiceScript" contengano l'apice. In questo caso devi sostituire il singolo apice con due apici:

nome.replaceAll("'","''");

[hdtogo]

[OT] ah nikynik ti ho spiegato tutto ieri pomeriggio in camera tua...Ti sei già dimenticato???? :master: :master:

[nikynik]

mi sa che hai preso un grankio togo