Python论坛的帖子： - 哲思

Python论坛 - 讨论区

返回群组主页

标题：[python-chinese] python中怎样表示嵌入字符串中的变量啊？

分享

徐继哲

楼主 2007年07月11日星期三 17:11

longlong asfnuts在gmail.com
星期三七月 11 17:11:49 HKT 2007

×Ö·û´®ÖÐµÄ±äÁ¿Ìæ»»

PHP 4 Ìí¼ÓÁËÒ»¸öÐÂµÄ»úÖÆÒÔÌæ»»×Ö·û´®ÖÐµÄ±äÁ¿¡£ÄúÏÖÔÚ¿ÉÒÔ·ÃÎÊ×Ö·û´®ÖÐµÄ¶ÔÏó³ÉÔ±±äÁ¿ºÍ¶àÎ¬Êý×éÔªËØ¡£

Èç¹ûÄúÏëÕâÃ´×ö£¬ÄúÐèÒªÊ¹ÓÃ´óÀ¨ºÅ½«Ò»¸öÃÀÔª·ûºÅºÍ±äÁ¿ÃûÀ¨ÆðÀ´£¬¾ÍÏñÕâÑù£º{$...}¡£

ÒªÔÚ×Ö·û´®ÖÐÇ¶Èë¶ÔÏó³ÉÔ±±äÁ¿£¬Ö»Òª¼òµ¥µÄÐ´ "text {$obj->member} text"¡£¶øÔÚ PHP 3 ÖÐ£¬ÄúµÃÊ¹ÓÃ "text
".$obj->member." text"¡£

Õâ¸ö¸Ä½ø¿ÉÒÔÊ¹´úÂë¸üÒ×¶Á£¬µ«Õâ¿ÉÄÜ»áÆÆ»µÓÃ PHP 3 Ð´µÄ´úÂë¡£µ«ÊÇÄúºÜÈÝÒ×ÐÞÕýËü£ºÔÚ´úÂëÖÐ²éÕÒ×Ö·û´®ÖÐµÄ {$£¬Ê¹ÓÃËÑË÷Ìæ»»¹¤¾ß½«ËüÌæ»»Îª \{$¡£



ÉÏÃæÊÇphpµÄ·½Ê½¡£
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070711/dff2369b/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

0楼 2007年07月11日星期三 17:26

沈崴 wileishn在gmail.com
星期三七月 11 17:26:29 HKT 2007

Ruby Sucks, PEP292 says.

在 07-7-11，longlong<asfnuts在gmail.com> 写道：
> 字符串中的变量替换
>
>  PHP 4 添加了一个新的机制以替换字符串中的变量。您现在可以访问字符串中的对象成员变量和多维数组元素。
>
>  如果您想这么做，您需要使用大括号将一个美元符号和变量名括起来，就像这样：{$...}。
>
>  要在字符串中嵌入对象成员变量，只要简单的写 "text {$obj->member} text"。而在 PHP 3 中，您得使用 "text
> ".$obj->member." text"。
>
>  这个改进可以使代码更易读，但这可能会破坏用 PHP 3 写的代码。但是您很容易修正它：在代码中查找字符串中的 {$，使用搜索替换工具将它替换为
> \{$。
>
>
>
>
> 上面是php的方式。
>
> _______________________________________________
> 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
>

匿名学习 Python 中 ...

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年07月13日星期五 14:48

Xell Zhang xellzhang在gmail.com
星期五七月 13 14:48:11 HKT 2007

ÊÇ²»ÊÇ
print 'hello, %s' % person.name
Õâ¸öÑù×Ó£¿

On 7/11/07, ÉòáË <wileishn在gmail.com> wrote:
>
> Ruby Sucks, PEP292 says.
>
> ÔÚ 07-7-11£¬longlong<asfnuts在gmail.com> Ð´µÀ£º
> > ×Ö·û´®ÖÐµÄ±äÁ¿Ìæ»»
> >
> >  PHP 4 Ìí¼ÓÁËÒ»¸öÐÂµÄ»úÖÆÒÔÌæ»»×Ö·û´®ÖÐµÄ±äÁ¿¡£ÄúÏÖÔÚ¿ÉÒÔ·ÃÎÊ×Ö·û´®ÖÐµÄ¶ÔÏó³ÉÔ±±äÁ¿ºÍ¶àÎ¬Êý×éÔªËØ¡£
> >
> >  Èç¹ûÄúÏëÕâÃ´×ö£¬ÄúÐèÒªÊ¹ÓÃ´óÀ¨ºÅ½«Ò»¸öÃÀÔª·ûºÅºÍ±äÁ¿ÃûÀ¨ÆðÀ´£¬¾ÍÏñÕâÑù£º{$...}¡£
> >
> >  ÒªÔÚ×Ö·û´®ÖÐÇ¶Èë¶ÔÏó³ÉÔ±±äÁ¿£¬Ö»Òª¼òµ¥µÄÐ´ "text {$obj->member} text"¡£¶øÔÚ PHP 3 ÖÐ£¬ÄúµÃÊ¹ÓÃ "text
> > ".$obj->member." text"¡£
> >
> >  Õâ¸ö¸Ä½ø¿ÉÒÔÊ¹´úÂë¸üÒ×¶Á£¬µ«Õâ¿ÉÄÜ»áÆÆ»µÓÃ PHP 3 Ð´µÄ´úÂë¡£µ«ÊÇÄúºÜÈÝÒ×ÐÞÕýËü£ºÔÚ´úÂëÖÐ²éÕÒ×Ö·û´®ÖÐµÄ {$£¬Ê¹ÓÃËÑË÷Ìæ»»¹¤¾ß½«ËüÌæ»»Îª
> > \{$¡£
> >
> >
> >
> >
> > ÉÏÃæÊÇphpµÄ·½Ê½¡£
> >
> > _______________________________________________
> > 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
> >
>
> ÄäÃûÑ§Ï° Python ÖÐ ...
> _______________________________________________
> 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




-- 
Zhang Xiao

Engineer, Web development

Ethos Tech.
http://www.ethos.com.cn
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070713/1c09b6b3/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年07月13日星期五 14:59

longlong asfnuts在gmail.com
星期五七月 13 14:59:39 HKT 2007

ÓÐÊ±ÔÚpythonÒªÖ´ÐÐsqlÓï¾ä£¬²ÎÊýÀàÐÍÊÇ×Ö·û´®£¬ÎÒÏëÔÚÕâ¸ö×Ö·û´®ÖÐ¼ÓÈë±äÁ¿£¬ÔõÃ´×ö£¿
ÔÚ07-7-13£¬Xell Zhang <xellzhang在gmail.com> Ð´µÀ£º
>
> ÊÇ²»ÊÇ
> print 'hello, %s' % person.name
> Õâ¸öÑù×Ó£¿
>
> On 7/11/07, ÉòáË <wileishn在gmail.com > wrote:
> >
> > Ruby Sucks, PEP292 says.
> >
> > ÔÚ 07-7-11£¬longlong< asfnuts在gmail.com> Ð´µÀ£º
> > > ×Ö·û´®ÖÐµÄ±äÁ¿Ìæ»»
> > >
> > >  PHP 4 Ìí¼ÓÁËÒ»¸öÐÂµÄ»úÖÆÒÔÌæ»»×Ö·û´®ÖÐµÄ±äÁ¿¡£ÄúÏÖÔÚ¿ÉÒÔ·ÃÎÊ×Ö·û´®ÖÐµÄ¶ÔÏó³ÉÔ±±äÁ¿ºÍ¶àÎ¬Êý×éÔªËØ¡£
> > >
> > >  Èç¹ûÄúÏëÕâÃ´×ö£¬ÄúÐèÒªÊ¹ÓÃ´óÀ¨ºÅ½«Ò»¸öÃÀÔª·ûºÅºÍ±äÁ¿ÃûÀ¨ÆðÀ´£¬¾ÍÏñÕâÑù£º{$...}¡£
> > >
> > >  ÒªÔÚ×Ö·û´®ÖÐÇ¶Èë¶ÔÏó³ÉÔ±±äÁ¿£¬Ö»Òª¼òµ¥µÄÐ´ "text {$obj->member} text"¡£¶øÔÚ PHP 3 ÖÐ£¬ÄúµÃÊ¹ÓÃ
> > "text
> > > ".$obj->member." text"¡£
> > >
> > >  Õâ¸ö¸Ä½ø¿ÉÒÔÊ¹´úÂë¸üÒ×¶Á£¬µ«Õâ¿ÉÄÜ»áÆÆ»µÓÃ PHP 3 Ð´µÄ´úÂë¡£µ«ÊÇÄúºÜÈÝÒ×ÐÞÕýËü£ºÔÚ´úÂëÖÐ²éÕÒ×Ö·û´®ÖÐµÄ
> > {$£¬Ê¹ÓÃËÑË÷Ìæ»»¹¤¾ß½«ËüÌæ»»Îª
> > > \{$¡£
> > >
> > >
> > >
> > >
> > > ÉÏÃæÊÇphpµÄ·½Ê½¡£
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> > ÄäÃûÑ§Ï° Python ÖÐ ...
> > _______________________________________________
> > 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
>
>
>
>
> --
> Zhang Xiao
>
> Engineer, Web development
>
> Ethos Tech.
> http://www.ethos.com.cn
> _______________________________________________
> 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
>
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070713/7b10bd99/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年07月13日星期五 15:31

Xell Zhang xellzhang在gmail.com
星期五七月 13 15:31:50 HKT 2007

ÎÒ×Ô¼º·â×°ÁËÒ»¸öÀàÓÃÀ´´¦Àísql¡£
class MySQLConnector:
    ''' MySQLConnector holds a connection with a MySQL database

    MySQLConnector instance creates a connection by using
    parameters passed. The connection will be hold by this
    instance. When a sql is run this instance will generate
    a cursor and use it to query. After query cursor will
    be closed.'''

    def __init__(self, host, port, user, passwd, db):
        self.con = MySQLdb.connect(
            host = host,
            port = port,
            user = user,
            passwd = passwd,
            db = db
        )
        self.lock = threading.Lock ()

    def query(self, sql, args = ()):
        self.lock.acquire()
        cursor = self.con.cursor()
        cursor.execute(sql, args)
        result = cursor.fetchall()
        cursor.execute ('commit')
        cursor.close()
        self.lock.release()
        return result

¿ÉÒÔÕâÑùÊ¹ÓÃ£º
dbCon = MySQLConnector('yourhost', 3306, 'username', 'passwd', 'dbname')
dbCon.query('SELECT * FROM user WHERE username = %s', ('xzhang'))
dbCon.query('INSERT INTO user (username, age) VALUES (%s, %s)', ('xzhang',
23))

ÎÒ¸Õ¿ªÊ¼Ñ§Ï°£¬²»ÖªµÀÎÒµÄ×ö·¨ÊÇ·ñºÃ¡£ÐèÒª×¢ÒâµÄÊÇ²»¹ÜÄã´«ÈëµÄÊý¾ÝÊÇÊ²Ã´ÀàÐÍ£¬¶¼ÓÃ%s¡£

On 7/13/07, longlong <asfnuts在gmail.com> wrote:
>
> ÓÐÊ±ÔÚpythonÒªÖ´ÐÐsqlÓï¾ä£¬²ÎÊýÀàÐÍÊÇ×Ö·û´®£¬ÎÒÏëÔÚÕâ¸ö×Ö·û´®ÖÐ¼ÓÈë±äÁ¿£¬ÔõÃ´×ö£¿
> ÔÚ07-7-13£¬Xell Zhang <xellzhang在gmail.com> Ð´µÀ£º
> >
> > ÊÇ²»ÊÇ
> > print 'hello, %s' % person.name
> > Õâ¸öÑù×Ó£¿
> >
> > On 7/11/07, ÉòáË <wileishn在gmail.com > wrote:
> > >
> > > Ruby Sucks, PEP292 says.
> > >
> > > ÔÚ 07-7-11£¬longlong< asfnuts在gmail.com> Ð´µÀ£º
> > > > ×Ö·û´®ÖÐµÄ±äÁ¿Ìæ»»
> > > >
> > > >  PHP 4 Ìí¼ÓÁËÒ»¸öÐÂµÄ»úÖÆÒÔÌæ»»×Ö·û´®ÖÐµÄ±äÁ¿¡£ÄúÏÖÔÚ¿ÉÒÔ·ÃÎÊ×Ö·û´®ÖÐµÄ¶ÔÏó³ÉÔ±±äÁ¿ºÍ¶àÎ¬Êý×éÔªËØ¡£
> > > >
> > > >  Èç¹ûÄúÏëÕâÃ´×ö£¬ÄúÐèÒªÊ¹ÓÃ´óÀ¨ºÅ½«Ò»¸öÃÀÔª·ûºÅºÍ±äÁ¿ÃûÀ¨ÆðÀ´£¬¾ÍÏñÕâÑù£º{$...}¡£
> > > >
> > > >  ÒªÔÚ×Ö·û´®ÖÐÇ¶Èë¶ÔÏó³ÉÔ±±äÁ¿£¬Ö»Òª¼òµ¥µÄÐ´ "text {$obj->member} text"¡£¶øÔÚ PHP 3 ÖÐ£¬ÄúµÃÊ¹ÓÃ
> > > "text
> > > > ".$obj->member." text"¡£
> > > >
> > > >  Õâ¸ö¸Ä½ø¿ÉÒÔÊ¹´úÂë¸üÒ×¶Á£¬µ«Õâ¿ÉÄÜ»áÆÆ»µÓÃ PHP 3 Ð´µÄ´úÂë¡£µ«ÊÇÄúºÜÈÝÒ×ÐÞÕýËü£ºÔÚ´úÂëÖÐ²éÕÒ×Ö·û´®ÖÐµÄ
> > > {$£¬Ê¹ÓÃËÑË÷Ìæ»»¹¤¾ß½«ËüÌæ»»Îª
> > > > \{$¡£
> > > >
> > > >
> > > >
> > > >
> > > > ÉÏÃæÊÇphpµÄ·½Ê½¡£
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > > ÄäÃûÑ§Ï° Python ÖÐ ...
> > > _______________________________________________
> > > 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
> >
> >
> >
> >
> > --
> > Zhang Xiao
> >
> > Engineer, Web development
> >
> > Ethos Tech.
> > http://www.ethos.com.cn
> > _______________________________________________
> > 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
> >
>
>
> _______________________________________________
> 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
>



-- 
Zhang Xiao

Engineer, Web development

Ethos Tech.
http://www.ethos.com.cn
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070713/8c5af5aa/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年07月13日星期五 16:10

longlong asfnuts在gmail.com
星期五七月 13 16:10:15 HKT 2007

Ñ§Ï°ÁË

ÔÚ07-7-13£¬Xell Zhang <xellzhang在gmail.com> Ð´µÀ£º
>
> ÎÒ×Ô¼º·â×°ÁËÒ»¸öÀàÓÃÀ´´¦Àísql¡£
> class MySQLConnector:
>     ''' MySQLConnector holds a connection with a MySQL database
>
>     MySQLConnector instance creates a connection by using
>     parameters passed. The connection will be hold by this
>     instance. When a sql is run this instance will generate
>     a cursor and use it to query. After query cursor will
>     be closed.'''
>
>     def __init__(self, host, port, user, passwd, db):
>         self.con = MySQLdb.connect(
>             host = host,
>             port = port,
>             user = user,
>             passwd = passwd,
>             db = db
>         )
>         self.lock = threading.Lock ()
>
>     def query(self, sql, args = ()):
>         self.lock.acquire()
>         cursor = self.con.cursor()
>         cursor.execute(sql, args)
>         result = cursor.fetchall()
>         cursor.execute ('commit')
>         cursor.close()
>         self.lock.release()
>         return result
>
> ¿ÉÒÔÕâÑùÊ¹ÓÃ£º
> dbCon = MySQLConnector('yourhost', 3306, 'username', 'passwd', 'dbname')
> dbCon.query('SELECT * FROM user WHERE username = %s', ('xzhang'))
> dbCon.query('INSERT INTO user (username, age) VALUES (%s, %s)', ('xzhang',
> 23))
>
> ÎÒ¸Õ¿ªÊ¼Ñ§Ï°£¬²»ÖªµÀÎÒµÄ×ö·¨ÊÇ·ñºÃ¡£ÐèÒª×¢ÒâµÄÊÇ²»¹ÜÄã´«ÈëµÄÊý¾ÝÊÇÊ²Ã´ÀàÐÍ£¬¶¼ÓÃ%s¡£
>
> On 7/13/07, longlong <asfnuts在gmail.com> wrote:
> >
> > ÓÐÊ±ÔÚpythonÒªÖ´ÐÐsqlÓï¾ä£¬²ÎÊýÀàÐÍÊÇ×Ö·û´®£¬ÎÒÏëÔÚÕâ¸ö×Ö·û´®ÖÐ¼ÓÈë±äÁ¿£¬ÔõÃ´×ö£¿
> > ÔÚ07-7-13£¬Xell Zhang <xellzhang在gmail.com> Ð´µÀ£º
> > >
> > > ÊÇ²»ÊÇ
> > > print 'hello, %s' % person.name
> > > Õâ¸öÑù×Ó£¿
> > >
> > > On 7/11/07, ÉòáË <wileishn在gmail.com > wrote:
> > > >
> > > > Ruby Sucks, PEP292 says.
> > > >
> > > > ÔÚ 07-7-11£¬longlong< asfnuts在gmail.com> Ð´µÀ£º
> > > > > ×Ö·û´®ÖÐµÄ±äÁ¿Ìæ»»
> > > > >
> > > > >  PHP 4 Ìí¼ÓÁËÒ»¸öÐÂµÄ»úÖÆÒÔÌæ»»×Ö·û´®ÖÐµÄ±äÁ¿¡£ÄúÏÖÔÚ¿ÉÒÔ·ÃÎÊ×Ö·û´®ÖÐµÄ¶ÔÏó³ÉÔ±±äÁ¿ºÍ¶àÎ¬Êý×éÔªËØ¡£
> > > > >
> > > > >  Èç¹ûÄúÏëÕâÃ´×ö£¬ÄúÐèÒªÊ¹ÓÃ´óÀ¨ºÅ½«Ò»¸öÃÀÔª·ûºÅºÍ±äÁ¿ÃûÀ¨ÆðÀ´£¬¾ÍÏñÕâÑù£º{$...}¡£
> > > > >
> > > > >  ÒªÔÚ×Ö·û´®ÖÐÇ¶Èë¶ÔÏó³ÉÔ±±äÁ¿£¬Ö»Òª¼òµ¥µÄÐ´ "text {$obj->member} text"¡£¶øÔÚ PHP 3 ÖÐ£¬ÄúµÃÊ¹ÓÃ
> > > > "text
> > > > > ".$obj->member." text"¡£
> > > > >
> > > > >  Õâ¸ö¸Ä½ø¿ÉÒÔÊ¹´úÂë¸üÒ×¶Á£¬µ«Õâ¿ÉÄÜ»áÆÆ»µÓÃ PHP 3 Ð´µÄ´úÂë¡£µ«ÊÇÄúºÜÈÝÒ×ÐÞÕýËü£ºÔÚ´úÂëÖÐ²éÕÒ×Ö·û´®ÖÐµÄ
> > > > {$£¬Ê¹ÓÃËÑË÷Ìæ»»¹¤¾ß½«ËüÌæ»»Îª
> > > > > \{$¡£
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ÉÏÃæÊÇphpµÄ·½Ê½¡£
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > > >
> > > >
> > > > ÄäÃûÑ§Ï° Python ÖÐ ...
> > > > _______________________________________________
> > > > 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
> > >
> > >
> > >
> > >
> > > --
> > > Zhang Xiao
> > >
> > > Engineer, Web development
> > >
> > > Ethos Tech.
> > > http://www.ethos.com.cn
> > > _______________________________________________
> > > 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
> > >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
>
> --
> Zhang Xiao
>
> Engineer, Web development
>
> Ethos Tech.
> http://www.ethos.com.cn
>
> _______________________________________________
> 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
>
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070713/5229679a/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

徐继哲

0楼 2007年07月16日星期一 14:41

Leo Jay python.leojay在gmail.com
星期一七月 16 14:41:33 HKT 2007

On 7/13/07, Xell Zhang <xellzhang在gmail.com> wrote:
> 我自己封装了一个类用来处理sql。
> class MySQLConnector:
>     ''' MySQLConnector holds a connection with a MySQL database
>
>     MySQLConnector instance creates a connection by using
>     parameters passed. The connection will be hold by this
>     instance. When a sql is run this instance will generate
>     a cursor and use it to query. After query cursor will
>     be closed.'''
>
>     def __init__(self, host, port, user, passwd, db):
>         self.con = MySQLdb.connect(
>             host = host,
>             port = port,
>             user = user,
>             passwd = passwd,
>             db = db
>         )
>         self.lock = threading.Lock ()
>
>     def query(self, sql, args = ()):
>         self.lock.acquire()
>         cursor = self.con.cursor()
>         cursor.execute(sql, args)
>         result = cursor.fetchall()
>         cursor.execute ('commit')
>         cursor.close()
>         self.lock.release()
>         return result
>
> 可以这样使用：
> dbCon = MySQLConnector('yourhost', 3306, 'username', 'passwd', 'dbname')
> dbCon.query('SELECT * FROM user WHERE username = %s', ('xzhang'))
> dbCon.query('INSERT INTO user (username, age) VALUES (%s, %s)', ('xzhang',
> 23))
>
> 我刚开始学习，不知道我的做法是否好。需要注意的是不管你传入的数据是什么类型，都用%s。
>


这样搞很容易被注入吧？

-- 
Best Regards,
Leo Jay

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

0楼 2007年07月16日星期一 17:45

leopay leopay在gmail.com
星期一七月 16 17:45:05 HKT 2007

Èç¹ûÊÇÕâÑù×ÓÐ´
cursor.execute(sql, args)
ÊÇ²»»á×¢ÈëµÄ£¬Ëü»á×Ô¶¯°ÑargsÖÐ×ªÒåµô
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒÆ³ý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070716/9f1729ec/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

请登录后回复。还没有在Zeuux哲思注册吗？现在注册！

Zeuux © 2025

京ICP备05028076号