procs.java

卡内基梅隆大学软件工程课件,很全面

/*
 *
 * Copyright 2000 Sun Microsystems, Inc. All Rights Reserved.
 * 
 * This software is the proprietary information of Sun Microsystems, Inc.  
 * Use is subject to license terms.
 * 
 */

import java.sql.*;
import java.io.*;
import java.lang.Integer;

// Cloudscape stored procedures are written using Java
public class Procs implements Serializable {

    public static void insertCoffee(String name, int qty) {
        try { 
            Connection con = 
                DriverManager.getConnection("jdbc:cloudscape:;current=true");
            PreparedStatement ptstmt =
                con.prepareStatement("INSERT INTO COFFEE VALUES (?,?)");
            ptstmt.setString(1, name);                   
            ptstmt.setInt(2, qty);
            ptstmt.executeUpdate();
            ptstmt.close();
        } catch(Exception ex){
            ex.printStackTrace();
        }
    }

    public static int countCoffee() {
        int count = 0;
        try { 
            Connection con = 
                DriverManager.getConnection("jdbc:cloudscape:;current=true");
            PreparedStatement ptstmt = 
                con.prepareStatement("SELECT COUNT(*) FROM COFFEE");
            ResultSet rs = ptstmt.executeQuery();
            while (rs.next()) {
                count = rs.getInt(1);
            }
            ptstmt.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return count;
    }
}