private void GenerateAdminNoActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_GenerateAdminNoActionPerformed
int IntAdminNo = 0;
String prodID;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/VunaFeeds", "root", "");
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("Select * from product where Status = 'Active'");
if (rs.last()) {
String adminNo = rs.getString("ProductID");
IntAdminNo = Integer.valueOf(adminNo);
System.out.println(IntAdminNo);
IntAdminNo++;
prodID = String.valueOf(IntAdminNo);
ProductID.setText(prodID);
} else {
IntAdminNo = 1;
prodID = String.valueOf(IntAdminNo);
ProductID.setText(prodID);
}
ProductID.setEditable(false);
} catch (SQLException e) {
System.out.println("2 Error : " + e);
JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n " + e);
} catch (Exception ex) {
System.out.println("Error 1:" + ex);
JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n" + ex);
}
} // GEN-LAST:event_GenerateAdminNoActionPerformed
