躺在沙灘上的小豬

<a name="$code$"></a>
<div class="infomark">$title$</div>
<div class="info" style="background:#F4F4F4">
<pre>
    $content$
</pre>   
</div>
<div align="right" class="right"><a href="#000">Top</a></div>
<br>
<br>

import re 
import sys 

class Template: 
    """ 
        簡單的模板，用于替換指定文本的特殊字符 
   例如：$code$ 
    """ 
    def __init__(self,filename,params,prefix='$',suffix='$'): 
        if not filename: 
            print 'Error:' 
            sys.exit(-1) 
        else: 
            self.filename=filename            
        self.text=''    
        self.params=params 
        self.prefix=prefix 
        self.suffix=suffix 

    def getKeys(self): 
        """ 
            返回所有的要求替換匹配的表達式 
        """ 
        return params.keys() 

    def parse(self): 
        
        self.getContent() 
          
        keys = self.params.keys() 
        for key in keys: 
            value = self.params[key] 
            self.__replace(key,value) 
        return self.text 

    
    def getContent(self): 
        """ 
            讀取文件的內容 
        """ 
        f = open(self.filename) 
        lines = f.readlines() 
        self.text = ''.join(line for line in lines) 
        
    def __replace(self,key,value):        
        #m = re.match(prefix+key+suffix,text) 
        pattern = '\.*\\'+self.prefix+key+'\\'+self.suffix+'\.*' 
        self.text = re.sub(pattern,value,self.text) 

if __name__=='__main__': 
    filename = 'D:\\workspace\\style\\test\\template.xt' 
    params = {'code':'001001','title':'測試','content':'的嘎公司今后；飛機庫'} 
    t = Template(filename,params) 
    print t.parse()

import cx_Oracle 
from Template import * 

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() 

def writeContent(code,title,content): 
    filedir='D:\\m\\content\\' 
    
    params = {'code':code,'title':title,'content':content} 
    t = Template('D:\\workspace\\style\\test\\template.xt',params) 
    s = t.parse() 

    out = open(filedir+code+".html",'w') 
    out.write(s) 
    out.flush() 
    out.close() 
    
if __name__=='__main__': 
    print 'parse..................'    
    parse() 
    print 'end'