package xin.glue.ui.B.common;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;

import oracle.sql.ARRAY;
import oracle.sql.ArrayDescriptor;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;

public class TestCall extends PosActivity
{
	public String runActivity(PosContext context)
	{
		PosGenericDao	     dao =	this.getDao("mesdao");
		CallableStatement	cstm =	null;
		String[]COIL_NO			 =	(String[])context.get("COIL_NO");
		try
		{
			String	driverClassName	=	"oracle.jdbc.driver.OracleDriver";
			Class.forName(driverClassName);
			String url =  "jdbc:oracle:thin:@10.10.0.8:1521:SQMESDB";  //²âÊÔ
			String	userName	=	"XG3Q";
			String	userPsw		=	"XG3Q123";
			Connection  conn =  dao.getDBConnection();
			conn	=	DriverManager.getConnection(url , userName , userPsw);
//			System.out.println("----------------------------------->"+conn);
			cstm	=	conn.prepareCall("{call PKG_QUALITY_TEST.TEST_TABLE(?,?)}");
			oracle.sql.ArrayDescriptor  ad	=	oracle.sql.ArrayDescriptor.createDescriptor("TABTYPECOIL", conn);
//			ARRAY 	array		=	new ARRAY(ad , conn , COIL_NO);
//			cstm.setArray(1, array);
//			cstm.registerOutParameter(2, java.sql.Types.VARCHAR);
//			System.out.println("#######################"+cstm.getString(2));
//			cstm.execute();
			cstm.close();
		}catch(Exception ex)
		{
			ex.printStackTrace();
			
		}
		return PosBizControlConstants.SUCCESS;
	}
	
	public void print()
	{
		System.out.println("#################################");
	}
}