Javatpoint Logo

i want to decrease the value of count

By: pandey*** On: Mon Oct 13 13:59:33 IST 2014     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
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
Up0Down