躺在沙灘上的小豬

import cx_Oracle 

def parse(): 
    '''generate the content html''' 

    sql = '''select t.bz_code code, t.bz_title title, t.bz_content content 
        from bz_czzs t 
        order by t.bz_code''' 

    connection = cx_Oracle.connect( 'etasadmin/etasadmin@zhongju' ) 
    cursor = connection.cursor() 
    cursor.execute(sql) 
    item=cursor.fetchone() 
    i=1; 
    print 'begin' 
    while item: 
        i+=1 
        print 'parsing ',i,' item....' 
        writeContent(item[0],item[1],str(item[2])) 
        item=cursor.fetchone() 

    print 'end' 
def writeContent(code,title,content): 
    filename='D:\\workspace\\style\\test\\content_body.html'    
    s = getContent(code,title,content)
    out = open(filename,'a') 
    out.write(s) 
    out.flush() 
    out.close() 
    
if __name__=='__main__': 
    print 'parse..................'    
    parse() 
    print 'end'