deletegoods.java~3~

来自「超市管理系统 运行环境JDK1.4以上 JB2006 源代码公开」· JAVA~3~ 代码 · 共 36 行

package com.aptech.classmarket;
import com.aptech.connection.*;
import java.sql.*;
public class Deletegoods {
    public boolean delete(Object i){
        Jdbc jj = new Jdbc();
        Connection con = jj.jdbcodbc();
        boolean flag = false;
        try {
            PreparedStatement ps = con.prepareStatement(
                    "select * from goods where goodsid=?");
            ps.setObject(1, i);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                flag = true;
            }
        } catch (SQLException ex) {
        }
        if (flag == true) {
            try {
                PreparedStatement ps = con.prepareStatement(
                        "delete from goods where goodsid=?");
                ps.setObject(1, i);
                int j = ps.executeUpdate();
            } catch (SQLException ex) {
            }
        }

        return flag;
    }
    public static void main(String[] args) {


    }
}