YES, PURE DOS,VER 6.22. I' ll  check below URL when I'm  back home.. can't
visit internet in the company,huhu~@@

  _____  

From: babyfrog [mailto:mudbuilder at gmail.com] 
Sent: Tuesday, November 14, 2006 11:28 AM
To: python-chinese at lists.python.cn
Subject: Re: [python-chinese] PYTHON under DOS



Python for DOS


Python 2.2.1 for DOS/DPMI <http://www.caddit.net/pythond.php>  for DOS/DPMI
is now available (built on the DJGPP platform).





在06-11-14， babyfrog <mudbuilder at gmail.com> 写道： 

	你说的该不会是dos6.22或者pc dos 7.0的pure环境吧
	
	
	2006/11/14, LI WeiMin (SCC-Test) < weimin.li at statschippac.com
weimin.li at statschippac.com> >: 
	

		Hi Python-list:
		
		请问如何在DOS下执行PYTHON 脚本的？　　
		
		谢谢
		_______________________________________________
		python-chinese
		Post: send python-chinese at lists.python.cn 
		Subscribe: send subscribe to
python-chinese-request at lists.python.cn
		Unsubscribe: send unsubscribe to
python-chinese-request at lists.python.cn
		Detail Info: http://python.cn/mailman/listinfo/python-chinese




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20061114/c81c8049/attachment.htm 

ÓÃMySQLdbÁ¬½Ó,ÊÇÑ­»·µ÷ÓÃdbinsertº¯Êý,ÿ´Î²åÈëÒ»Ìõ,µ±ÐèÒª²åÈëµÄ¼Ç¼Êý¹ý¶àʱ,
»á±¨´íOperationalError,˵²»ÄÜÁ¬½Ómysql Server,È»ºó¹ýÒ»¶Îʱ¼äºó²ÅÄÜÔÙÁ¬½Ó,

ÕâÎÊÌâÔõô½â¾öÄØ?ÔÚmysqlÀïÉèÖÃÂð?Íû¸ßÊÖÖ¸µã,лл.

---------

def dbinsert(post_number,user,title,post,post_time,post_order,edit_time):

    conn =
MySQLdb.connect(host='localhost',user='root',passwd='00507529',db='mybbs',us
e_unicode=1, charset='gbk')

    cursor = conn.cursor()

    query = "insert into
cdb_before_post(post_number,title,user,post,post_time,post_order,edit_time)
select %s,%s,%s,%s,%s,%s,%s"

    para = (post_number,title,user,post,post_time,post_order,edit_time)

    cursor.execute(query,para)

    conn.commit()

    conn.close()

-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20061114/30d3ba39/attachment.html 

On 11/14/06, 周冲 <zhouchong在staff.sina.com.cn> wrote:
> 用MySQLdb连接,是循环调用dbinsert函数,每次插入一条,当需要插入的记录数过多时,会报错OperationalError,说不能连接mysql
> Server,然后过一段时间后才能再连接,
>
> 这问题怎么解决呢?在mysql里设置吗?望高手指点,谢谢.
[snip code]

一次连接，多次插入

conn = MySQLdb.connect(...)
cursor = conn.cursor()
for para in ...:
   cursor.execute(sql, para)

也可以使用executemany函数，一次sql操作插入多条记录。

²»ÒªÆ½·²µÄÁ¬½Ó¶Ï¿ª¡£Á¬½ÓÒ»´Îºó°ÑËùÓеIJéѯºÍ¸üвÙ×÷×öÍêÈ»ºóÔٶϿª¡£
 
 
Qutr£¬qutianrang在gmail.com
2006-11-14 
----- Original Message ----- 
From: Öܳå 
To: python-chinese 
Sent: 2006-11-14, 12:12:12
Subject: [python-chinese] pythonÁ¬mysqlÊý¾Ý¿â


ÓÃMySQLdbÁ¬½Ó,ÊÇÑ­»·µ÷ÓÃdbinsertº¯Êý,ÿ´Î²åÈëÒ»Ìõ,µ±ÐèÒª²åÈëµÄ¼Ç¼Êý¹ý¶àʱ,»á±¨´íOperationalError,˵²»ÄÜÁ¬½Ómysql Server,È»ºó¹ýÒ»¶Îʱ¼äºó²ÅÄÜÔÙÁ¬½Ó,
ÕâÎÊÌâÔõô½â¾öÄØ?ÔÚmysqlÀïÉèÖÃÂð?Íû¸ßÊÖÖ¸µã,лл.
---------
def dbinsert(post_number,user,title,post,post_time,post_order,edit_time):
    conn = MySQLdb.connect(host='localhost',user='root',passwd='00507529',db='mybbs',use_unicode=1, charset='gbk')
    cursor = conn.cursor()
    query = "insert into cdb_before_post(post_number,title,user,post,post_time,post_order,edit_time) select %s,%s,%s,%s,%s,%s,%s"
    para = (post_number,title,user,post,post_time,post_order,edit_time)
    cursor.execute(query,para)
    conn.commit()
    conn.close()
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20061114/a02b85be/attachment.htm 

谢谢Qiangning Hong,程序改写了一下,问题解决了

-----邮件原件-----
发件人: python-chinese-bounces在lists.python.cn
[mailto:python-chinese-bounces在lists.python.cn] 代表 Qiangning Hong
发送时间: 2006年11月14日 12:20
收件人: python-chinese在lists.python.cn
主题: Re: [python-chinese] python连mysql数据库

On 11/14/06, 周冲 <zhouchong在staff.sina.com.cn> wrote:
> 用MySQLdb连接,是循环调用dbinsert函数,每次插入一条,当需要插入的记录数过多
时,会报错OperationalError,说不能连接mysql
> Server,然后过一段时间后才能再连接,
>
> 这问题怎么解决呢?在mysql里设置吗?望高手指点,谢谢.
[snip code]

一次连接，多次插入

conn = MySQLdb.connect(...)
cursor = conn.cursor()
for para in ...:
   cursor.execute(sql, para)

也可以使用executemany函数，一次sql操作插入多条记录。
_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese