eassaction.java

管理系统

package com.aptech.cdjj.sex.action;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import com.aptech.cdjj.sex.gui.SMainMenu;
import com.aptech.cdjj.sex.database.SDBManager;
public class EassAction {
    public boolean changedate(String txtid,String txtname,String txtsprice,String txtprice,String txtdate,String txtrofit){
        SDBManager.ConnToDB();
        String sql = "update Sell set sid =  '"+txtid+"',sname =  '"+txtname+"',scost =  '"+txtsprice+"',sprice =  '"+txtprice+"',svalue = '"+txtrofit+"' ,sdate = '"+txtdate+"' where sid = '"+txtid+"'";
        int num = SDBManager.executeUpdate(sql);
        System.out.println(num);
        String sql1 = "select * from Sell";
       SDBManager.executeQuery(sql1);
        SDBManager.closeObj();
        if(num > 0){
            return true;
        }else{
            return false;
        }
    }

    /**
     * changedate
     *
     * @param txtid String
     * @param txtname String
     * @param txtsprice String
     * @param txtprice String
     * @param txtdate String
     * @param txtrofit String
     * @return boolean
     */
   // public boolean changedate(String txtid, String txtname, String txtsprice,
                         //     String txtprice, String txtdate, String txtrofit) {
       // return false;
   // }

}