getcustomer.java

来自「噶额外噶外骨骼感广泛高热感 就 啊啊」· Java 代码 · 共 37 行

/**
 * JDBC Stored Procedure ITSO.getCustomer
 * @param customerID This parameter was generated from the specified SQL Statement.
 */
package itso.storedproc;

import java.sql.*;                   // JDBC classes

public class GetCustomer
{
    public static void getCustomer ( int customerID,
                                     ResultSet[] rs1 ) throws SQLException, Exception
    {
        // Get connection to the database
        Connection con = DriverManager.getConnection("jdbc:default:connection");
        PreparedStatement stmt = null;
        boolean bFlag;
        String sql;

        sql = "SELECT CUSTOMERID, TITLE, FIRSTNAME, "
            + " "
            + "    LASTNAME, USERID, PASSWORD"
            + " "
            + " FROM"
            + " "
            + "    ITSO.CUSTOMER"
            + " "
            + " WHERE"
            + " "
            + "    ITSO.CUSTOMER.CUSTOMERID =  ?";
        stmt = con.prepareStatement( sql );
        stmt.setInt( 1, customerID );
        bFlag = stmt.execute();
        rs1[0] = stmt.getResultSet();
    }
}