inventorymanager.java~15~

来自「这是本人刚刚得到的JBuilder9软件开发项目实践的源码」· JAVA~15~ 代码 · 共 61 行

package jxc;

/**
 * <p>Title: jxc demo</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author cwx
 * @version 1.0
 */

import java.sql.*;

public class InventoryManager {
  public InventoryManager() {
  }

  static public int queryQty(String wareID){
     Connection conn = null;
     PreparedStatement stmt = null;
     ResultSet rs = null;

     try {
       conn = ConnectionManager.getConnection();
       stmt = conn.prepareStatement("select * from Reserve where wareID="+wareID);
       rs = stmt.executeQuery();

       if(rs.next())
         return rs.getInt("resQty");
       else
         return 0;
     }
     catch (java.sql.SQLException e) {
       System.err.println(e);
     }
     finally {
       //关闭数据库资源
       if (rs != null){
         try{
           rs.close();
         }catch(Exception exception){}
       }

       if (stmt != null) {
         try {
           stmt.close();
         } catch (Exception exception) {}
       }
       if (conn != null) {
         try {
           conn.close();
         } catch (Exception exception) {}
       }
     }

     //失败
     return 0;
   }


}