• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Invoking a SQL and stored procedure

 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi guys, i've written the following code and feed i've left out something , i just need to put it together correctly with a solid logic..can you help me put it nicely...i'm sending short messages (from s stored procedure)to the results generated from the SQL statement...thanking advance..

package co.za.sarstces.payphone;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.Connection;
import org.apache.log4j.Logger;
public class GeographicalArea

{
private static StringBuffer sqlString = null;
private static String NumberList;
private Connection connobj;


public GeographicalArea(){ }

// public NumberList getAgentrange(Connection cn,String rangebegin, String rangeend)
{

// declare the resultset
PreparedStatement pstmt=null;
ResultSet rs =null;

sqlString = new StringBuffer();
sqlString.append(" select distinct ccp01_contact_msisdn ");
sqlString.append(" from so_cpp.tcp08_payphone_histories b , SO_CPP.TCP01_OWNER_DETAILS c ");
sqlString.append(" where b.ccp08_owner_id = c.ccp01_owner_id ");
sqlString.append(" and b.ccp08_msisdn between ? ");
sqlString.append(" and ? ");
sqlString.append(" and nvl(ccp01_contact_msisdn , 0) > 0");
sqlString.append(" and nvl(ccp08_date_ceased,sysdate+1) > sysdate ");

// pstmt = cn.prepareStatement(sqlString);
// rs = pstmt.executeQuery();

// return rs;

}

public String sendMSISDN(Connection connobj, int contactNumber, String messageContent)

{
GeographicalArea area = new GeographicalArea();
NumberRange getAgentsrange = new NumberRange();
// getAgentsrange = area.getAgentrange();
CallableStatement csmt = null;
// for(int i = 0; i < msisdnrange.size(); i++)
{

try{
csmt = connobj.prepareCall("{? = call so_util.wdpk_sms_messages.insert_sms(?,?,?,?,?,?,?,?,?,?,?,?,?) }");
//input parameters
// csmt.setInt(1, msisdnrange.[i]);
csmt.setString(2,messageContent);
csmt.setString(3,"");
csmt.setString(4,"");
csmt.setString(5,"");
csmt.setString(6,"");
csmt.setString(7,"");
csmt.setString(8,"");
csmt.setString(9,"");
csmt.setInt(10,10);
// csmt.registerOutParameter(11,NUMBER);;
// csmt.registerOutParameters(12,VARCHAR);

ResultSet rs =csmt.executeQuery();
csmt.close();

} catch (Exception e)
{

}
return null;

}
}

}
reply
    Bookmark Topic Watch Topic
  • New Topic