deliverdb.java~1~

cnc网通小灵通网关接口源码

package mobilegw.smdb;

/**
 * <p>Title: mobileGateWay</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: gramsoft</p>
 * @author lee
 * @version 1.0
 */
import java.sql.*;
import java.sql.Date;
import java.util.*;

public class DeliverDb {

  private  Connection conn ;
  private  Statement stmt ;

  public DeliverDb() {
  }


    public  synchronized boolean insertDB(String phone,String media,
            String password,String SrcBranch)
    {
        boolean ret=false;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        String INSERT_SONG ="";
        try {
            conn = mobileMain.poolmanager.getConnection("submit");
            conn.setAutoCommit(false);
            String INSERT_Phone =
                    "Insert Into stockusers(phone,media,password,srcbranch)  "
                    + "Values(?,?,?,?)";
            pstmt = conn.prepareStatement(INSERT_Phone);
            pstmt.setString(1,phone);
            pstmt.setString(2,media);
            pstmt.setString(3,password);
            pstmt.setString(4,SrcBranch);
            pstmt.executeUpdate() ;
            Clog.info("在数据库中插入记录成功！");
            ret=true;
        }
        catch(SQLException ex) {
            Clog.error("打开数据库或执行insertSQL时出错:"+ex.getMessage());
            ret=false;
            return ret;
        }
        finally{
            try{
                if(ret)
                    conn.commit();
                else
                    conn.rollback();
                pstmt.close();
                GateWayConfig.poolManager.freeConnection("WBJJE",conn);
            }catch(Exception ie){
                Clog.error("关闭数据库出错:"+ie.getMessage());
            }
        }
        return ret;
    }


}