Jump to content

Alterar dados na dados de dados


Recommended Posts


Como faço para alterar dados de dados que já estão inseridos na base de dados?

Não faço a minima como o fazer portanto agradecia que me explica-sem ao pormenor  :dontgetit:

Uso um programa chamado netbeans e é por lá que quero fazer isso. A partir do netbeans sei visualizar e inserir dados na boa! Agora alterar...


Link to post
Share on other sites

partindo do principio  q sabes JDBC

e asim

UPDATE table_name

SET column1=value, column2=value2,...

WHERE some_column=some_value

Notice the WHERE clause in the UPDATE syntax. The WHERE clause specifies which record or records that should be updated. If you omit the WHERE clause, all records will be updated!

Link to post
Share on other sites

xt = "update materialcomponentes set MarcaeModelo=/""+MarcaeModelo+"/", Preco=/""+Preco+"/", Caracteristicas=/""+Caracteristicas+"/" where IDComponentes="+ID+";";


Java, Android developerhttp://minimalcode.net

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site you accept our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.