modao.java

采用JAVA开发

package com.gctech.sms.dao;

import com.gctech.sms.msg.MOInfo;
import java.sql.Connection;
import java.sql.PreparedStatement;
import com.gctech.sms.util.ConnectionManager;
import org.apache.log4j.Logger;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: gctech</p>
 * @author 王红宝
 * @version $Id: MODao.java,v 1.3 2004/05/19 07:59:16 wanghb Exp $
 */

public class MODao {
  public MODao() {
  }
  public static int add(MOInfo mo){
    int rt = -1;
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = ConnectionManager.getInstance().getConnection(MODao.class);
      pstmt = con.prepareStatement("insert into mo(MsgId,gateway,serviceNo,srcTermId,"+
          "destTermId,content,msgFormat,isReport)values(?,?,?,?,?,?,?,?)");
      int n = 1;
      pstmt.setString(n++, mo.strMsgID);
      pstmt.setInt(n++, mo.gateway);
      pstmt.setString(n++, mo.serviceNo);
      pstmt.setString(n++, mo.srcPhoneNo);
      pstmt.setString(n++, mo.destTermId);
      pstmt.setString(n++, mo.content);
      pstmt.setInt(n++, mo.MsgFormat);
      pstmt.setInt(n++, mo.IsReply);
      rt = pstmt.executeUpdate();
    }catch( Throwable e ){
      logger.error(e, e);
      //写到文件中

    }finally{
      if ( pstmt != null ){
        try {
          pstmt.close();
        }
        catch (Throwable ex) {
          logger.error(ex, ex);
        }
      }
      if ( con != null ){
        try {
          con.close();
        }
        catch (Throwable ex) {
          logger.error(ex, ex);
        }
      }
      return rt;
    }

  }

  static final Logger logger = Logger.getLogger(MODao.class);
}