addprovision.java

中国移动 provision MISC1.6 接口

package net.smsfan.provision.example;

import cmd.db.ConnDB;
import java.sql.PreparedStatement;
import cmd.db.CodeChange;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AddProvision {
    public AddProvision() {
    }

    public boolean InsertProvision(String PseudoCode,
                                  String MSISDN1,
                                  String MSISDN2,
                                  String SPID,
                                  String SPServiceID,
                                  String AccessMode,
                                  String FeatureStr) {
        boolean bRetval = false;

        ConnDB connDBnew = new ConnDB();
        CodeChange codeChange = new CodeChange();
        connDBnew.setAutoCommit(connDBnew.AUTO_COMMIT);
        String sSQL =
                "INSERT INTO provisionlog (PSEUDOCODE,MSISDN1,MSISDN2,SPID,SPSERVICEID,ACCESSMODE,FEATURESTR) values (?,?,?,?,?,?,?)";
        System.out.println(sSQL);
        PreparedStatement pstmt = connDBnew.createPstmt(sSQL);
        if (pstmt != null) {
            try {

                pstmt.setString(1, PseudoCode);
                pstmt.setString(2, MSISDN1);
                pstmt.setString(3, MSISDN2);
                pstmt.setString(4, SPID);
                pstmt.setString(5, SPServiceID);
                pstmt.setString(6, AccessMode);
                pstmt.setString(7, FeatureStr);

                if (connDBnew.executeUpdate() > 0) {
                    bRetval = true;
                }

            } catch (Exception e) {
                System.out.println("ConnDB::InsertProvisionLog Error " + e.toString());
            } finally {
                connDBnew.closeStmt();
                connDBnew.close();
            }
        }
        return bRetval;
    }
}