/*
 * *****************************************************
 * Copyright (c) 2005 IIM Lab. All  Rights Reserved.
 * Created by xuehao at Dec 1, 2005
 * Contact: zxuehao@mail.ustc.edu.cn
 * *****************************************************
 */
package org.indigo.tests.db;

import java.sql.Clob;
import java.sql.ResultSet;
import java.sql.SQLException;

import junit.framework.TestCase;

import org.indigo.db.*;

public class TestOracleDBManager extends TestCase
{
    public void testDBManager1()
    {
/*        
        String agricategory="紅椒",
        	agriclass="",
        	agrimarket="安徽安慶",
	        agriprice="2.55",
	        agriunit="元/公斤",
	        agridate="11-30",
	        page_url="http://www.agri.com.cn/price/price.asp?page=1&fromdate=2005-10-18&todate=2009-10-25&province=340000&market=&type=0&subtype=0";
        String agrisite = page_url;
        
        PriceInfo pInfo = new PriceInfo();
        pInfo.setAgriCategory( agricategory );
        pInfo.setAgriClass( agriclass );
        pInfo.setAgriMarket( agrimarket );
        pInfo.setAgriPrice( agriprice );
        pInfo.setAgriUnit( agriunit );
        pInfo.setAgriSite( agrisite );
        pInfo.setAgriDate( agridate );
        
        DBManager.getInstance().inserPriceInfo2DB( pInfo );
*/        
    }
    public void testDBManager2()
    {
 /*
        String page_url="http://www.ahnw.gov.cn/scxx/gqrx/content.asp?id=362987",
        	info_title = "太湖縣寺前鎮(zhèn)大量出售優(yōu)質(zhì)生姜",
        	info_type="",
        	linkman="殷仕忠", 
        	contact_means="太湖縣寺前鎮(zhèn)人民政府0556-4320411", 
        	email="xuliuyuna@163.com",
        	reg_time="2005-11-30 13:57:10",
        	info_content="我處有大量的優(yōu)質(zhì)生姜出售,有意者請與本人聯(lián)系。求購從速！ 價(jià)格面議!";
        String other1="", other2="";
        
        SplDemInfo sdInfo = new SplDemInfo();
        sdInfo.setPageUrl( page_url );
        sdInfo.setInfoTitle( info_title );
	    sdInfo.setInfoType( info_type );
	    sdInfo.setLinkMan( linkman );
	    sdInfo.setContactMeans( contact_means );
	    sdInfo.setEmail( email );
	    sdInfo.setRegTime( reg_time );
	    sdInfo.setInfoContent( info_content );
	    sdInfo.setOther1( other1 );
	    sdInfo.setOther2( other2 );
            
	    DBManager.getInstance().inserSplDemInfo2DB( sdInfo );
*/	    
    }
    public void testDBManager3() throws SQLException
    {
        String sql;
        sql = "select * from gqxx_tbl";
        ResultSet rs=null;
        rs = DBOracleConnection.getInstance().executeQuery( sql );
        while( rs.next() )
        {
            Clob clob = rs.getClob( "info_content" );
            String content=null;
            content = DBOracleConnection.getInstance().clobTOstring( clob );
            System.out.println( "" );
            System.out.println( content );
        }
    }
}