[Java][MySQL] ¡Help! Insert

[Nasty]

Well this is my database:

And this Java code:

1. You must be registered for see links
   btnAlta = new
   You must be registered for see links
   ("Alta");
2. btnAlta.addActionListener(new
   You must be registered for see links
   () {
3. public void actionPerformed(
   You must be registered for see links
   arg0) {
4. labelResultado.setText("");
5. try {
6. You must be registered for see links
   conexion=
   You must be registered for see links
   .getConnection("jdbc:mysql://localhost/bd1","root" ,"");
7. You must be registered for see links
   comando=conexion.createStatement();
8. comando.executeUpdate("insert into articulos(descripcion,precio) values ('"+tf1.getText()+"',"+tf2.getText()+")");
9. conexion.close();
10. labelResultado.setText("se registraron los datos");
11. tf1.setText("");
12. tf2.setText("");
13. } catch(
    You must be registered for see links
    ex){
14. setTitle(ex.toString());
15. } }
16. });

Now I want to do is:
Each time you give to "High" in the table field "code" generated a number: 1
When will the second time, it detects that there is a 1 and place a 2. Bone in order,
in each "insert" generated a number more ...

 

[brsy]

You need to use auto increcement.

 

[Adil]

comando.executeUpdate("INSERT into articulos(descripcion,precio) values ('"+tf1.getText().toString()+"',"+tf2.getText().toString()+")");

Try that

 

[Nasty]

You need to use auto increcement.

If and I realized that was what was missing, thanks

 

[brsy]

No problem