This tutorial will teach you how to generator autono using java mysql Autono generator is very important thing in the programming.we will teach you step by step.
Creating a function autono() add the following code inside the function.i shown below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | public void autoID() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/lob","root",""); Statement s = con.createStatement(); ResultSet rs = s.executeQuery("select Max(id) from customer"); rs.next(); rs.getString("Max(id)"); if(rs.getString("Max(id)")==null) { txtno.setText("C0001"); } else { Long id = Long.parseLong(rs.getString("Max(id)").substring(2,rs.getString("Max(id)").length())); id++; txtno.setText("C0" + String.format("%03d", id)); } } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } } |
Call the function inside the constructor of class.
1 2 3 4 5 | public autoIn() { initComponents(); autoID(); } |
Insert the Records
after inserted the record autono generator itself.paste the code inside the add button.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | try { String no = txtno.getText(); String name = txtname.getText(); Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/lob","root",""); pst = con.prepareStatement("insert into customer (id,name)values(?,?)"); pst.setString(1, no); pst.setString(2, name); pst.executeUpdate(); JOptionPane.showMessageDialog(this,"Record Addedd"); autoID(); txtname.setText(""); txtname.requestFocus(); } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } |
I have attached the video tutorial below it will help you to do this step by step.
