This tutorial which help you to generating auto no using java and mysql.
Establish the database Connection
public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/gshop","root",""); } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } }
Auto no generator.create the function Custno().
public void CustNo() { int custno = 1; try { Statement smt = con.createStatement(); ResultSet rs = smt.executeQuery("select count(distinct customerid)+1 from records"); rs.next(); custno = rs.getInt(1); txtno.setText("C000"+custno); rs.close(); } catch (SQLException ex) { } }
Add Records. after add the record Customer no will be incremented by 1
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { try { String cno = txtno.getText(); String cname = txtname.getText(); pst = con.prepareStatement("insert into records(customerid,custname)values(?,?)"); pst.setString(1, cno); pst.setString(2, cname); int status = pst.executeUpdate(); if(status==1) { JOptionPane.showMessageDialog(this, "New Customer Addedd"); CustNo(); txtname.setText(""); txtname.requestFocus(); } else { JOptionPane.showMessageDialog(this, "New Customer Addedd Failedddd!!!"); } } catch (SQLException ex) { } }
This article explain how to make a Fish Inventory Management App in Angular.this app explain…
Introduction to Fish Inventory Management In the aquaculture industry, managing fish inventory is crucial for…
Introduction to Java GUI CRUD Java is a powerful programming language widely used for building…
Introduction to Login Form Design Designing an effective and beautiful login form is crucial for…
Introduction In today creating a responsive login form is essential for providing a seamless user…
Introduction to Inventory Management Systems In today's fast-paced digital environment, businesses require efficient inventory management…