ProductDao package india; import java.sql.Connection; import java.sql.PreparedStatement; import resource.DbConnection; import java.sql.ResultSet; public class ProductDao { public static int product(ProductAction p){ int status=0; int count=0; ResultSet rs=null; String proname1=p.getProname(); String proprice1=p.getProPrice(); Connection con=null; try{ con=DbConnection.db(); String qr1 = "insert into product(proid,proname,proPrice,status,count) values(?,?,?,'1',?)"; String qr3 = "update product set count=? where proname='"+proname1+"' and proPrice='"+proprice1+"' "; String qr2="SELECT count from product where status=1 and proname='"+proname1+"' and proPrice='"+proprice1+"' "; PreparedStatement pst=con.prepareStatement(qr2); rs = pst.executeQuery(qr2); if(rs.next()) { count=rs.getInt("count"); } if(count==0){ PreparedStatement pst1 = con.prepareStatement(qr1); pst1.setString(1,p.getProid()); pst1.setString(2,p.getProname()); pst1.setString(3,p.getProPrice()); pst1.setInt(4,1); status=pst1.executeUpdate(); } if(count >= 1){ count++; PreparedStatement pst2 = con.prepareStatement(qr3); pst2.setInt(1,count); status=pst2.executeUpdate();} } catch (Exception e) { e.printStackTrace(); } return status; }} ProductAction package india; import com.opensymphony.xwork2.ActionSupport; @SuppressWarnings("serial") public class ProductAction extends ActionSupport{ private String proid,proname,proPrice,status; int count; public int getCount() { return count; } public void setCount(int count) { this.count = count; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String getProid() { return proid; } public void setProid(String proid) { this.proid = proid; } public String getProname() { return proname; } public void setProname(String proname) { this.proname = proname; } public String getProPrice() { return proPrice; } public void setProPrice(String proPrice) { this.proPrice = proPrice; } public String execute(){ int i=ProductDao.product(this); if(i>0){ return "success"; } return "error"; } public void validate() { if(proid == null || proid.trim().equals("") ) { addFieldError("proid", "Product ID Must Required"); } if(proname == null || proname.trim().equals("") ) { addFieldError("proname", "Product Name Want"); } if(proPrice == null || proPrice.trim().equals("") ) { addFieldError("proPrice", "Price Required"); } } } ouput = proid .... proname ...... proprice..... count=1 or 2 or 3 or 4 button 'sell' if same proname and proprice are then the count ++; i want to click on sell button then the count are decrease | 0 |