db.pc

linux 上http email 协议分析程序 主要能够处理大数据量的主干网的应用

	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
		   
	strcpy(c_sql, "SELECT S_TR_T_MAILFILE.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_MAILFILE FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
	
	strcpy(c_sql, "SELECT S_TR_T_MAILINFO.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_MAILINFO FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
	
	strcpy(c_sql, "SELECT S_TR_T_MAILACCOUNT.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_MAILACCOUNT FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
	
 	strcpy(c_sql, "SELECT S_TR_T_MAILTEXT.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_MAILTEXT FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}

 	strcpy(c_sql, "SELECT S_TR_T_SPEMAILFILE.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SPEMAILFILE FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
	
	strcpy(c_sql, "SELECT S_TR_T_SPEMAILINFO.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SPEMAILINFO FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}

 	strcpy(c_sql, "SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SPEMAILADDRESS FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
 	
	strcpy(c_sql, "SELECT S_TR_T_SPEMAILTEXT.NEXTVAL INTO :? FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SPEMAILTEXT FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}


}*/

CSeqEmail::CSeqEmail()
{

 m_iS_TR_T_MAILADDRESS=getS_TR_T_MAILADDRESS();
 m_iS_TR_T_MAILFILE=getS_TR_T_MAILFILE();
 m_iS_TR_T_MAILINFO=getS_TR_T_MAILINFO();
 m_iS_TR_T_MAILACCOUNT=getS_TR_T_MAILACCOUNT();
 m_iS_TR_T_MAILTEXT=getS_TR_T_MAILTEXT();
 m_iS_TR_T_SPEMAILFILE=getS_TR_T_SPEMAILFILE();
 m_iS_TR_T_SPEMAILINFO=getS_TR_T_SPEMAILINFO();
 m_iS_TR_T_SPEMAILADDRESS=getS_TR_T_SPEMAILADDRESS();
 m_iS_TR_T_SPEMAILTEXT=getS_TR_T_SPEMAILTEXT();

}

CSeqEmail::~CSeqEmail()
{
}
int CSeqEmail::getS_TR_T_MAILADDRESS()
{
	
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	printf("getS_TR_T_MAILADDRESS()\n");
	EXEC SQL SELECT S_TR_T_MAILADDRESS.NEXTVAL INTO :i_id FROM DUAL ;
	
	printf("getS_TR_T_MAILADDRESS(%d)\n",i_id);
	m_iS_TR_T_MAILADDRESS=i_id;
	printf("getS_TR_T_MAILADDRESS(%d)\n",m_iS_TR_T_MAILADDRESS);
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILADDRESS);

}
int CSeqEmail::getS_TR_T_MAILFILE()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_MAILFILE.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_MAILFILE=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILFILE);

}
int CSeqEmail::getS_TR_T_MAILINFO()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_MAILINFO.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_MAILINFO=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILINFO);

}
int CSeqEmail::getS_TR_T_MAILACCOUNT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_MAILACCOUNT.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_MAILACCOUNT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILACCOUNT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILACCOUNT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILACCOUNT);
}
int CSeqEmail::getS_TR_T_MAILTEXT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_MAILTEXT.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_MAILTEXT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILTEXT);
}
int CSeqEmail::getS_TR_T_SPEMAILFILE()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SPEMAILFILE.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SPEMAILFILE=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILFILE);
}

int CSeqEmail::getS_TR_T_SPEMAILINFO()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SPEMAILINFO.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SPEMAILINFO=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILINFO);
}
int CSeqEmail::getS_TR_T_SPEMAILADDRESS()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SPEMAILADDRESS=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILADDRESS);
}
int CSeqEmail::getS_TR_T_SPEMAILTEXT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SPEMAILTEXT.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SPEMAILTEXT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILTEXT);
}

/*int CSeqEmail::getS_TR_T_MAILADDRESS()
{
	
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
		
	EXEC SQL EXECUTE getseq_S_TR_T_MAILADDRESS USING :i_id;   
	
	m_iS_TR_T_MAILADDRESS=i_id;
	
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILADDRESS);

}

int CSeqEmail::getS_TR_T_MAILFILE()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_MAILFILE USING :i_id;  
		
	m_iS_TR_T_MAILFILE=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILFILE);

}
int CSeqEmail::getS_TR_T_MAILINFO()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_MAILINFO USING :i_id; 
	
	m_iS_TR_T_MAILINFO=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILINFO);

}
int CSeqEmail::getS_TR_T_MAILACCOUNT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_MAILACCOUNT USING :i_id; 
	
	m_iS_TR_T_MAILACCOUNT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILACCOUNT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILACCOUNT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILACCOUNT);
}
int CSeqEmail::getS_TR_T_MAILTEXT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_MAILTEXT USING :i_id; 
	
	m_iS_TR_T_MAILTEXT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_MAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_MAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_MAILTEXT);
}
int CSeqEmail::getS_TR_T_SPEMAILFILE()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_SPEMAILFILE USING :i_id; 
	
	m_iS_TR_T_SPEMAILFILE=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILFILE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILFILE);
}

int CSeqEmail::getS_TR_T_SPEMAILINFO()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_SPEMAILINFO USING :i_id;
	
	m_iS_TR_T_SPEMAILINFO=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILINFO.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILINFO);
}
int CSeqEmail::getS_TR_T_SPEMAILADDRESS()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_SPEMAILADDRESS USING :i_id;
	
	m_iS_TR_T_SPEMAILADDRESS=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILADDRESS.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILADDRESS);
}
int CSeqEmail::getS_TR_T_SPEMAILTEXT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL EXECUTE getseq_S_TR_T_SPEMAILTEXT USING :i_id;
	
	m_iS_TR_T_SPEMAILTEXT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SPEMAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SPEMAILTEXT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SPEMAILTEXT);
}
*/
int CSeqEmail::getfkS_TR_T_MAILADDRESS()
{
	return m_iS_TR_T_MAILADDRESS;
}

int CSeqEmail::getfkS_TR_T_MAILFILE()
{
	return m_iS_TR_T_MAILFILE;
}

int CSeqEmail::getfkS_TR_T_MAILINFO()
{
	return m_iS_TR_T_MAILINFO;
}

int CSeqEmail::getfkS_TR_T_MAILACCOUNT()
{
	return m_iS_TR_T_MAILACCOUNT;
}

int CSeqEmail::getfkS_TR_T_MAILTEXT()
{
	return m_iS_TR_T_MAILTEXT;
}

int CSeqEmail::getfkS_TR_T_SPEMAILFILE()
{
	return m_iS_TR_T_SPEMAILFILE;
}

int CSeqEmail::getfkS_TR_T_SPEMAILINFO()
{
	return m_iS_TR_T_SPEMAILINFO;
}

int CSeqEmail::getfkS_TR_T_SPEMAILADDRESS()
{
	return m_iS_TR_T_SPEMAILADDRESS;
}

int CSeqEmail::getfkS_TR_T_SPEMAILTEXT()
{
	return m_iS_TR_T_SPEMAILTEXT;
}

CSeqWeb::CSeqWeb()
{
	//prepare();
	m_iS_TR_T_SUBMITCONTENT=getS_TR_T_SUBMITCONTENT();
	m_iS_TR_T_SENPAGE=getS_TR_T_SENPAGE();
	
}
CSeqWeb::~CSeqWeb()
{
}

/*void CSeqWeb::prepare()
{
	EXEC SQL BEGIN DECLARE SECTION;
		char c_sql[512];
		
	EXEC SQL END DECLARE SECTION;

	strcpy(c_sql, "SELECT S_TR_T_SUBMITCONTENT.NEXTVAL INTO :gi_id FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SUBMITCONTENT FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		printf("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}
	
	strcpy(c_sql, "SELECT S_TR_T_SENPAGE.NEXTVAL INTO :gi_id FROM DUAL");
	EXEC SQL PREPARE getseq_S_TR_T_SENPAGE FROM :c_sql;  
	if(checkSqlCode()!=0)
	{
		TLog::toErr("prepare [%s] [%d]\n",c_sql,sqlca.sqlcode);
	}

}
*/

int CSeqWeb::getS_TR_T_SUBMITCONTENT()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SUBMITCONTENT.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SUBMITCONTENT=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SUBMITCONTENT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SUBMITCONTENT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SUBMITCONTENT);
}

int CSeqWeb::getS_TR_T_SENPAGE()
{
	EXEC SQL BEGIN DECLARE SECTION;
		int i_id;
	EXEC SQL END DECLARE SECTION;
	
	EXEC SQL SELECT S_TR_T_SENPAGE.NEXTVAL INTO :i_id FROM DUAL ;
	
	m_iS_TR_T_SENPAGE=i_id;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SENPAGE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SENPAGE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	
	return (m_iS_TR_T_SENPAGE);
}




/*int CSeqWeb::getS_TR_T_SUBMITCONTENT()
{
	EXEC SQL EXECUTE getseq_S_TR_T_SUBMITCONTENT ;
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SUBMITCONTENT.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SUBMITCONTENT.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	printf("S_TR_T_SUBMITCONTENT= [%d]\n",gi_id);
	m_iS_TR_T_SUBMITCONTENT=gi_id;
	return (m_iS_TR_T_SUBMITCONTENT);
}

int CSeqWeb::getS_TR_T_SENPAGE()
{
	
	EXEC SQL EXECUTE getseq_S_TR_T_SENPAGE ;
	
	if(checkSqlCode()!=0)
	{
		printf("SELECT S_TR_T_SENPAGE.NEXTVAL [%d]\n",sqlca.sqlcode);
		TLog::toErr("SELECT S_TR_T_SENPAGE.NEXTVAL [%d]\n",sqlca.sqlcode);
	}
	m_iS_TR_T_SENPAGE=gi_id;
	return (m_iS_TR_T_SENPAGE);
}
*/
int CSeqWeb::getfkS_TR_T_SUBMITCONTENT()
{
	return (m_iS_TR_T_SUBMITCONTENT);	
}
int CSeqWeb::getfkS_TR_T_SENPAGE()
{
	return (m_iS_TR_T_SENPAGE);
}