http://www.oracle.com/technetwork/java/javase/downloads/jdk6-jsp-136632.html

http://www.eclipse.org/downloads/packages/eclipse-ide-java-developers/heliossr1

https://www.python.org/download/releases/2.7

http://www.pydev.org/updates

JDK 6 U17 64BIT for windows

Python 2.7

Eclipse 3.5.1 64bit for Windows

Pydev plug-in for Eclipse

\’\’\’

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;

详细内容能够參考while语句中案例

类似Java中的continue，这里不再描写叙述。

#Python提供了
pass语句,它不做不论什么事情

#这种代码结构在开发和调试时非常实用,由于编写代码的时候你可能要先把结构定下来

#在异常处理中也被经经常使用到

deffoo_func():

   pass;

deffoo_func2():

   pass   

if __name__ ==“__main__”:

   print(“—main—“)

   foo_func();

   foo_func2();

x =2;

y =0;

while(True):

   try:

       z = x/y;

       print
z;

   except
Exception,e:

       print“except—–“,e

   finally:

       print“finally—-“

   break;

\’\’\’

   输出结果：

   except—– integer division or modulo by zero

   finally—-

\’\’\’

\’\’\’

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+”，读写模式

1.      file.read(size)：读取文件的
size个字节.返回一个
string 对象.假设没有设

置 size,则读取整个文件。

2．file.readline():读取一行，返回一个
string 对象，假设返回的内容为空，则

说明文件结束 Eof。

3．file.readlines():读取全部的行，返回一个
list

4．file.write(buffer)：写
buffer 的内容到文件

5．file.flush()强制写缓冲区的内容到文件

6．file.close()关闭文件

file.name:文件名称

file.mode:文件打开的模式

\’\’\’

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

\’\’\’

cx_Oracle版本号：cx_Oracle-5.1.1-10g.win32-py2.7.msi

数据库版本号：Oracle10g

Python版本号：3.3

cx_Oracle版本号：cx_Oracle-5.1.1-10g-py27-1.i386.rpm

数据库版本号：Oracle10g

Python版本号：2.7

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

   #username/password@主机
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世界！！！“);