Sir !
i have written the module named registration.java to store the date in the mysql using the java
But When i execute this module gives the exception:
java.sql.SQLException: Column count doesn't match value count at row 1
but it also shows the message that "data has been inserted successfully
Update: Code from comments (AndyLanng)
String name = txtName.getText();
String Address = txtAddress.getText();
String contact_no = txtContact.getText();
mail_id = txtEmail.getText();
String username = txtUsername.getText();
String passcode = pf_password.getText().toLowerCase();
String months = (String)cmbPackage.getSelectedItem();
String key = txtkey.getText();
try{
Class.forName(JDBC_Driver);
Connection con = DriverManager.getConnection(DB_URL,
USER,
password);
String sql="insert into registration (name,
address,
contact,
email,
username,
Password,
Package_Duration,
Voucher_keys,
EndDate)values(?,
?,
?,
?,
?,
?,
?,
?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,
name);
ps.setString(2,
Address);
ps.setString(3,
contact_no);
ps.setString(4,
mail_id);
ps.setString(5,
username);
ps.setString(6,
passcode);
ps.setString(7,
months);
ps.setString(8,
key);
(Date) dt);
JOptionPane.showMessageDialog(this,
"Data has been inserted Successfully" );
} if(cmbPackage.getSelectedIndex()==0) {
Calendar calender = Calendar.getInstance();
calender.add(calender.DATE,
+90);
java.sql.Date d1 = new java.sql.Date(calender.getTime().getTime());
ps.setDate(8,
d1);
ps.executeUpdate();
} else if(cmbPackage.getSelectedIndex()==1) {
Calendar calender = Calendar.getInstance();
calender.add(calender.DATE,
+180);
java.sql.Date dl = new java.sql.Date(calender.getTime().getTime());
ps.setDate(8,
dl);
ps.executeUpdate();
} else if(cmbPackage.getSelectedIndex()==2) {
Calendar calender = Calendar.getInstance();
calender.add(calender.DATE,
+365);
java.sql.Date dl = new java.sql.Date(calender.getTime().getTime());
ps.setDate(8,
dl);
ps.executeUpdate();
}
}catch (SQLException|ClassNotFoundException e){
e.printStackTrace();
}
}
What I have tried:
i have tried statement inteerface but no result