'''
Created on 2014-4-21
 
@author: ShenFuLi
'''
print("Hello world!!");

ifage<21:
print("你不能买酒。")
print("不过你能买口香糖。")
print("这句话处於if语句块的外面。")

'''
Created on 2014-4-22
@author: ShenFuli
'''
#单行的注释是以#开始的
print("单行的注释是以#开始的.");
'''
   三引号字符串在python中是用来表示多行的字符串的
 name:shenfl
 age:20
'''
print("name:shenfl,age:20");

'''
Created on 2014-4-22
@author: ShenFuLi
@description
   python中可以使用单引号（'）和双引号（"）来表示字符串，这两者是完全等同的。
'''
str1 ="双引号字符串 ";
print(str1);
str2 ='单引号字符串 ';
print(str2);

'''
Created on 2014-4-22
@author: ShenFuLi
@Description运算符与它们的用法
字符串str转换成int: int_value = int(str_value)
int转换成字符串str: str_value = str(int_value)
int ->unicode:unicode(int_value)
unicode ->int:int(unicode_value)
str ->unicode:unicode(str_value)
unicode ->str:str(unicode_value)
int ->str:str(int_value)
str ->int:int(str_value)
'''
print("两个对象相加： 3 + 5 = " + str(3 + 5));#output the 8
print("两个数详进行减法： 8 - 3 = " + str(8 - 3));#output the result 5
print("两个对象相乘： 3 + 5 = " + str(3 * 5));#output the result 8
print("取整： 4//3 = " + str(4//3));#output the result 1
print("除： 4/3 = " + str(4/3));#output the result 1.3333333333333333
print("取模： 5%3 = " + str(5%3));#output the result 2
 
'''
   对象是否相等
'''
print(2==2);#True
print('2'=='2');#True
print(1!=2);#True
 
x =True;
print(not x);#False
 
a =True;
b =False;
print(aand b);#False
print(aor b);#True
 
 
#表达式：表达式就是将由变量，运算符等结合起来用来表达一种含义的式子。
t1 =4;
t2 =6;
print((t1 + t2)/2);#5.0

#可以通过切换变量来验证每一种情况
x =3;
if(x==1):
   print("output the result is 1");
elif(x==2):
   print("out the result is 2")
else:
   print ("I do not know!");

'''
Created on 2014-4-22
@author: ShenFuLi
@description:
循环执行就是满足条件重复执行。使用最多的是 for .....in ...
注意：
   这里使用了一个内置函数 range().
   range(起始值，终止值，步长)
   起始值缺省是 0,可以不写
   步长值缺省是 1，可以不写
   终止值是采用小于，而不是小于等于，所以是满足条件的是不包括终止值
'''

'''
   输出结果：
   0
   1
   2
   3
   4
'''
for xin range(5):
   print(x);
print("------------------------")
'''
   输出结果：
       8
       7
       6
'''
for xin range(8,5,-1):
   print(x);

#三元运算符
import sys
x =10;
y =20;
z = xif(x<y)else y;
print(z);#output the result is 10

'''
   输出结果：
   this count: 0
   this count: 1
   this count: 2
   this count: 3
'''
count =0;
while(count<5):
   print"this count:",count;
   if(count==3):
       break;
   count+=1;

#Python提供了 pass语句,它不做任何事情
#这样的代码结构在开发和调试时很有用,因为编写代码的时候你可能要先把结构定下来
#在异常处理中也被经常用到
deffoo_func():
   pass;
 
deffoo_func2():
   pass   
if __name__ =="__main__":
   print("---main---")
   foo_func();
   foo_func2();

'''
Created on 2014-4-22
@author: ShenFuLi
'''
name ="zhengwenjie";
#定义函数
defsayHello(params):
   global name;#函数可以使用全局变量，但是要global声明
   print("name = " +name);
   print("您好，" + params);
id =1000;
defprintId():
   global id;
   print(id);
   id = id +1;
   
#定义主函数入口
if__name__=="__main__":
   sayHello("沈福利");#output the result is 您好，沈福利
   #main函数可以使用全局变量
   print("name = " + name);
   printId();#1000
   printId();#1001

a ="love";
print(len(a));#ouput the result is 4

b =1000;
print(str(1000));#output the result is 1000

#定义空的列表
a = [];
print(a);#输出结果为[]
print(len(a));#输出结果为0
 
a.insert(0,2);
a.insert(1,4);
a.insert(2,8);
print("---------------------")
#索引元素：a.index(元素，开始，结束) #返回匹配到的第一个元素的索引。
a_value = a.index(4,0,len(a) );
print("a_value:" + str(a_value));
for vin a:
   print(v);

#定义字典
#定义空的字典
b = {};
print(len(b));
#定义有数据的字典
b = {"x1":"hello","x2":"world","x3":"1000"}
#添加一个key/value到数据字典中
b["x4"] = "x4";
#输出数据字典中的数据
for xin b.items():
   '''
           输出结果为：
   ('x3', 1000)
   ('x2', 'world')
   ('x1', 'hello')
   ('x4', 'x4')
   '''
   print(x);
for key,valuein b.items():
   '''
      输出结果为：
       key:x2, value:world
       key:x3, value:1000
       key:x1, value:hello
       key:x4, value:x4
   '''
   print("key:" + key + ", value:" + value);
t2 = b.__contains__("x3");
if(t2 ==True):
   print("数据字典中key包含x3")

"r",读模式
"w"，写模式
"r+"，读写模式

'''
Created on 2014-4-22
@author: ShenFuLi
@Description :对文件操作
'''
#读取文件，返回文件对象
fileName ="pyFile.txt";
file = open(fileName);
#调用文件方法
files = file.readlines();
for linein files:
   print(line);
file.close();
'''
       输出结果：
       Hello World

       welcome
'''

db = cx_Oracle.connect('ngves3/asiainfo@192.168.204.135:1521/mydb')

DSN_TNS = cx_Oracle.makedsn(db_host, db_port, db_base);
db = cx_Oracle.connect(db_user, db_pass, DSN_TNS);

# -*- coding:utf-8 -*-
import cx_Oracle
import sys
db_host ='192.168.204.135'
db_port =1521
db_base ='mydb'
db_user ='ngves3'
db_pass ='asiainfo'
DSN_TNS = cx_Oracle.makedsn(db_host, db_port, db_base);
db_query ="SELECT U_NO,U_NAME FROM ngves3.T_USER where u_no='AI001'"
 
try:
   #DSN_TNS: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.204.135)(PORT=1521)))(CONNECT_DATA=(SID=mydb)))
   print"DSN_TNS:",DSN_TNS
   db = cx_Oracle.connect(db_user, db_pass,DSN_TNS);
   #用户名/密码@主机 ip:port/实例名
   #db = cx_Oracle.connect('db_user/asiainfo@192.168.204.135:1521/mydb')
   cursor = db.cursor();
   cursor.execute(db_query);
   row = cursor.fetchall();
   #定义列表
   z = [];
   for xin row:
       for yin x:
           sys.stdout.write(str(y)+" ");
except Exception, e:
   print'db err', e;
finally:
   cursor.close();
   db.close();
'''
   输出结果：
   AI001 shenfl1
'''

# -*- coding:utf-8 -*-
'''
Created on 2014-4-25
 
@author:Shenfl
 
@Function:创建一张表，并插入一些数据，在修改其中的部分数据
'''
import cx_Oracle
import os
'''
   @Function:连接数据库
   @param dbname:数据库实例，默认初始数据mydb
'''
defconnectDB(dbname="mydb"):
   if(dbname=="mydb"):
       conn ="ngves3/asiainfo@192.168.204.135:1521/mydb";
   db = cx_Oracle.connect(conn);
   return db;
 
defcloseDB(db):
   db.close();
'''
   @Function:查询数据库
   @param sql:sql语句
          db： 数据库对象
'''
defsqlSelect(sql,db):
   #include:select
   cr=db.cursor();
   cr.execute(sql);
   rs=cr.fetchall();
   cr.close();
   return rs;
 
'''
   @Function:对数据库进行操作
   @param sql:sql语句
          db： 数据库对象
'''
defsqlDML(sql,db):
   #include: insert,update,delete
   cr=db.cursor()
   cr.execute(sql)
   cr.close()
   db.commit()
'''
   @Function:对数据库进行操作
   @param sql:sql语句
          params：查询参数
          db： 数据库对象
'''
defsqlDML2(sql,params,db):
   # executedml with parameters
   cr=db.cursor();
   cr.execute(sql,params);
   cr.close();
   db.commit();
'''
   @Function:对数据库进行操作
   @param sql:sql语句
          db： 数据库对象
'''
defsqlDDL(sql,db):
   #include: create
   cr=db.cursor();
   cr.execute(sql);
   cr.close();
   db.commit();
 
 
if __name__=='__main__':
   print"This is a testpython program,write byshenfl!\n";
   os.environ['NLS_LANG']='SIMPLIFIED CHINESE_CHINA.UTF8';
   #connect to database
   db = connectDB();
   #create table
   sql_create ="create table py_test(id number,name varchar2(20),phone number)";
   try:
       #sqlDDL(sql_create,db);
       print"create table success!"
   except Exception ,e:
       #the output result is ORA-00955: name is already used by an existing object
       print e;
  
   
   # delete data before insert data to table py_test
   sql ="truncate table py_test";
   sqlDDL(sql, db);    
   print("truncate py_test success!")
       
   #insert data to table py_test：方案一
   sql ="insert into py_test(id,name,phone) values(1,'shenfl',110)";
   sqlDDL(sql, db);
   print("方案一：insert data to table py_test  success!")
   #insert data to table py_test：方案二
   dt=[{'id':2,'name':'zhangsan','phone':138888888888},
       {'id':3,'name':'lisi','phone':13888888888},
       {'id':4,'name':'shenfl','phone':13888888888}]
   sql='insert into py_test values(:id,:name,:phone)'
   for xin dt:
       '''   
输出结果：   
           {'phone': 138888888888L, 'id': 2, 'name': 'zhangsan'}
           {'phone': 13888888888L, 'id': 3, 'name': 'lisi'}
           {'phone': 13888888888L, 'id': 4, 'name': 'shenfl'}
       '''
       print(x);
       sqlDML2(sql,x,db);
   print("方案二： insert data to table py_test success!")
 
   #select the result:
   sql ="select id,name,phone from py_test";
   rs = sqlSelect(sql, db);
   print"数据查询结果："
   for rin rs:
       print r;
  
   #数据操作完毕后完毕数据库
   closeDB(db);

This is a test python program,write by shenfl!
 
create table success!
truncate py_test success!
方案一：insert data to table py_test success!
{'phone': 138888888888L, 'id': 2, 'name': 'zhangsan'}
{'phone': 13888888888L, 'id': 3, 'name': 'lisi'}
{'phone': 13888888888L, 'id': 4, 'name': 'shenfl'}
方案二： insert data to table py_test success!
数据查询结果：
(1, 'shenfl', 110)
(2, 'zhangsan', 138888888888L)
(3, 'lisi', 13888888888L)
(4, 'shenfl', 13888888888L)

select *from py_test;
 
ID NAME   PHONE
1  shenfl 110
2  zhangsan   138888888888
3  lisi   13888888888
4  shenfl 13888888888

# -*- coding:utf-8 -*-
'''
Created on 2014-5-14
 
@author:shenfl
'''
import datetime
import os
ROOT_HISTORY ="";
defnew_dir(dst_dir):
   try:
       if os.path.exists(dst_dir):
           pass;
       else:
           #os.mkdir(dst_dir);
           os.makedirs(dst_dir);
   except:
       print"makedir %s err!" % dst_dir;
 
if __name__ =="__main__":
   history = ROOT_HISTORY;
   format ='%Y-%m-%d %H:%M:%S'
   print"make new_dir",datetime.datetime.now().strftime(format);
   dst_dir ="%s/ware.%s" % (history, datetime.datetime.now().strftime(format))
   new_dir("data/html/current");

# -*- coding:utf-8 -*-
import string
words=["aaa","bbb"];
a = string.join(words,";");
print a;#aaa;bbb

b ="?".join(["hello","world"]);
print b;#hello?world

# -*- coding:utf-8 -*-
print("Hello world!!");
print("欢迎来到python世界！！！");