selectstockid.java

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

package com.aptech.classmarket;

import com.aptech.connection.Tosql;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class selectstockid {
    public boolean select(Ingoods f){

       Tosql tt=new Tosql();
       Connection con=tt.tosql();
       boolean flag=false;
       try {
           PreparedStatement ps = con.prepareStatement(
                   "select * from ingoods where stocksid=?");
           ps.setString(1, f.stocksid);
           ResultSet rs = ps.executeQuery();
           while (rs.next()) {
               flag = true;
           }
       } catch (SQLException ex) {
       }
       return flag;
   }

    public static void main(String[] args) {

    }
}