selectgoodsid.java

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

package com.aptech.classmarket;

import com.aptech.connection.*;
import java.sql.*;

public class Selectgoodsid {
    public boolean select(Goods j){
//        Jdbc jj=new Jdbc();
//        Connection con=jj.jdbcodbc();
        Tosql tt=new Tosql();
        Connection con=tt.tosql();
        boolean flag=false;
        try {
            PreparedStatement ps = con.prepareStatement(
                    "select * from goods where goodsid=?");
            ps.setString(1, j.goodsid);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                flag = true;
            }
        } catch (SQLException ex) {
        }
        return flag;
    }
    public static void main(String[] args) {

    }
}