Insert

try{
String sql = "INSERT INTO tb_buyfish(fishname , color , size , qty , price , totalprice , date) VALUES(? , ? , ? , ? , ? , ? , ?) ";
pst = this.con.prepareStatement(sql);
pst.setString(1 , buyfish_fishname.getText());
pst.setString(2 , buyfish_color.getText());
pst.setString(3 , buyfish_size.getText());
pst.setString(4 , buyfish_qty.getText());
pst.setString(5 , buyfish_price.getText());
pst.setString(6 , buyfish_totalprice.getText());
java.util.Date get = buyfish_date.getDate();
String getdate = new SimpleDateFormat("yyyy/MM/dd").format(get);
pst.setString(7 , getdate);
pst.executeUpdate();
JOptionPane.showMessageDialog(null,"successfully!");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,"BuyFish_Save: " + e.getMessage());
}