dbi.3

视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.

.\" Automatically generated by Pod::Man 2.16 (Pod::Simple 3.05)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sh \" Subsection heading
.br
.if t .Sp
.ne 5
.PP
\fB\\$1\fR
.PP
..
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is turned on, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.ie \nF \{\
.    de IX
.    tm Index:\\$1\t\\n%\t"\\$2"
..
.    nr % 0
.    rr F
.\}
.el \{\
.    de IX
..
.\}
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
.    \" fudge factors for nroff and troff
.if n \{\
.    ds #H 0
.    ds #V .8m
.    ds #F .3m
.    ds #[ \f1
.    ds #] \fP
.\}
.if t \{\
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
.    ds #V .6m
.    ds #F 0
.    ds #[ \&
.    ds #] \&
.\}
.    \" simple accents for nroff and troff
.if n \{\
.    ds ' \&
.    ds ` \&
.    ds ^ \&
.    ds , \&
.    ds ~ ~
.    ds /
.\}
.if t \{\
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
.    \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
.    \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
.    \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
.    ds : e
.    ds 8 ss
.    ds o a
.    ds d- d\h'-1'\(ga
.    ds D- D\h'-1'\(hy
.    ds th \o'bp'
.    ds Th \o'LP'
.    ds ae ae
.    ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "DBI 3"
.TH DBI 3 "2007-10-16" "perl v5.10.0" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
DBI \- Database independent interface for Perl
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 1
\&  use DBI;
\&
\&  @driver_names = DBI\->available_drivers;
\&  %drivers      = DBI\->installed_drivers;
\&  @data_sources = DBI\->data_sources($driver_name, \e%attr);
\&
\&  $dbh = DBI\->connect($data_source, $username, $auth, \e%attr);
\&
\&  $rv  = $dbh\->do($statement);
\&  $rv  = $dbh\->do($statement, \e%attr);
\&  $rv  = $dbh\->do($statement, \e%attr, @bind_values);
\&
\&  $ary_ref  = $dbh\->selectall_arrayref($statement);
\&  $hash_ref = $dbh\->selectall_hashref($statement, $key_field);
\&
\&  $ary_ref  = $dbh\->selectcol_arrayref($statement);
\&  $ary_ref  = $dbh\->selectcol_arrayref($statement, \e%attr);
\&
\&  @row_ary  = $dbh\->selectrow_array($statement);
\&  $ary_ref  = $dbh\->selectrow_arrayref($statement);
\&  $hash_ref = $dbh\->selectrow_hashref($statement);
\&
\&  $sth = $dbh\->prepare($statement);
\&  $sth = $dbh\->prepare_cached($statement);
\&
\&  $rc = $sth\->bind_param($p_num, $bind_value);
\&  $rc = $sth\->bind_param($p_num, $bind_value, $bind_type);
\&  $rc = $sth\->bind_param($p_num, $bind_value, \e%attr);
\&
\&  $rv = $sth\->execute;
\&  $rv = $sth\->execute(@bind_values);
\&  $rv = $sth\->execute_array(\e%attr, ...);
\&
\&  $rc = $sth\->bind_col($col_num, \e$col_variable);
\&  $rc = $sth\->bind_columns(@list_of_refs_to_vars_to_bind);
\&
\&  @row_ary  = $sth\->fetchrow_array;
\&  $ary_ref  = $sth\->fetchrow_arrayref;
\&  $hash_ref = $sth\->fetchrow_hashref;
\&
\&  $ary_ref  = $sth\->fetchall_arrayref;
\&  $ary_ref  = $sth\->fetchall_arrayref( $slice, $max_rows );
\&
\&  $hash_ref = $sth\->fetchall_hashref( $key_field );
\&
\&  $rv  = $sth\->rows;
\&
\&  $rc  = $dbh\->begin_work;
\&  $rc  = $dbh\->commit;
\&  $rc  = $dbh\->rollback;
\&
\&  $quoted_string = $dbh\->quote($string);
\&
\&  $rc  = $h\->err;
\&  $str = $h\->errstr;
\&  $rv  = $h\->state;
\&
\&  $rc  = $dbh\->disconnect;
.Ve
.PP
\&\fIThe synopsis above only lists the major methods and parameters.\fR
.Sh "\s-1GETTING\s0 \s-1HELP\s0"
.IX Subsection "GETTING HELP"
If you have questions about \s-1DBI\s0, or \s-1DBD\s0 driver modules, you can get
help from the \fIdbi\[e-mail]\fR mailing list.  You don't have to subscribe
to the list in order to post, though I'd recommend it. You can get help on
subscribing and using the list by emailing \fIdbi\-users\[e-mail]\fR.
.PP
I don't recommend the \s-1DBI\s0 cpanform (at http://www.cpanforum.com/dist/DBI)
because relatively few people read it compared with dbi\[e-mail].
.PP
To help you make the best use of the dbi-users mailing list,
and any other lists or forums you may use, I \fIstrongly\fR
recommend that you read \*(L"How To Ask Questions The Smart Way\*(R"
by Eric Raymond: <http://www.catb.org/~esr/faqs/smart\-questions.html>.
.PP
If you think you've found a bug then please also read
\&\*(L"How to Report Bugs Effectively\*(R" by Simon Tatham:
<http://www.chiark.greenend.org.uk/~sgtatham/bugs.html>.
.PP
The \s-1DBI\s0 home page at <http://dbi.perl.org/> is always worth a visit
and includes an \s-1FAQ\s0 and links to other resources.
.PP
Before asking any questions, reread this document, consult the
archives and read the \s-1DBI\s0 \s-1FAQ\s0. The archives are listed
at the end of this document and on the \s-1DBI\s0 home page.
An \s-1FAQ\s0 is installed as a \s-1DBI::FAQ\s0 module so
you can read it by executing \f(CW\*(C`perldoc DBI::FAQ\*(C'\fR.
However the \s-1DBI::FAQ\s0 module is currently (2004) outdated relative
to the online \s-1FAQ\s0 on the \s-1DBI\s0 home page.
.PP
This document often uses terms like \fIreferences\fR, \fIobjects\fR,
\&\fImethods\fR.  If you're not familar with those terms then it would
be a good idea to read at least the following perl manuals first:
perlreftut, perldsc, perllol, and perlboot.
.PP
Please note that Tim Bunce does not maintain the mailing lists or the
web page (generous volunteers do that).  So please don't send mail
directly to him; he just doesn't have the time to answer questions
personally. The \fIdbi-users\fR mailing list has lots of experienced
people who should be able to help you if you need it. If you do email
Tim he's very likely to just forward it to the mailing list.
.Sh "\s-1NOTES\s0"
.IX Subsection "NOTES"
This is the \s-1DBI\s0 specification that corresponds to the \s-1DBI\s0 version 1.601
($Revision: 10087 $).
.PP
The \s-1DBI\s0 is evolving at a steady pace, so it's good to check that
you have the latest copy.
.PP
The significant user-visible changes in each release are documented
in the DBI::Changes module so you can read them by executing
\&\f(CW\*(C`perldoc DBI::Changes\*(C'\fR.
.PP
Some \s-1DBI\s0 changes require changes in the drivers, but the drivers
can take some time to catch up. Newer versions of the \s-1DBI\s0 have
added features that may not yet be supported by the drivers you
use.  Talk to the authors of your drivers if you need a new feature
that's not yet supported.
.PP
Features added after \s-1DBI\s0 1.21 (February 2002) are marked in the
text with the version number of the \s-1DBI\s0 release they first appeared in.
.PP
Extensions to the \s-1DBI\s0 \s-1API\s0 often use the \f(CW\*(C`DBIx::*\*(C'\fR namespace.
See \*(L"Naming Conventions and Name Space\*(R". \s-1DBI\s0 extension modules
can be found at <http://search.cpan.org/search?mode=module&query=DBIx>.
And all modules related to the \s-1DBI\s0 can be found at
<http://search.cpan.org/search?query=DBI&mode=all>.
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
The \s-1DBI\s0 is a database access module for the Perl programming language.  It defines
a set of methods, variables, and conventions that provide a consistent
database interface, independent of the actual database being used.
.PP
It is important to remember that the \s-1DBI\s0 is just an interface.
The \s-1DBI\s0 is a layer
of \*(L"glue\*(R" between an application and one or more database \fIdriver\fR
modules.  It is the driver modules which do most of the real work. The \s-1DBI\s0
provides a standard interface and framework for the drivers to operate
within.
.Sh "Architecture of a \s-1DBI\s0 Application"
.IX Subsection "Architecture of a DBI Application"
.Vb 11
\&             |<\- Scope of DBI \->|
\&                  .\-.   .\-\-\-\-\-\-\-\-\-\-\-\-\-\-.   .\-\-\-\-\-\-\-\-\-\-\-\-\-.
\&  .\-\-\-\-\-\-\-.       | |\-\-\-| XYZ Driver   |\-\-\-| XYZ Engine  |
\&  | Perl  |       | |   \`\-\-\-\-\-\-\-\-\-\-\-\-\-\-\*(Aq   \`\-\-\-\-\-\-\-\-\-\-\-\-\-\*(Aq
\&  | script|  |A|  |D|   .\-\-\-\-\-\-\-\-\-\-\-\-\-\-.   .\-\-\-\-\-\-\-\-\-\-\-\-\-.
\&  | using |\-\-|P|\-\-|B|\-\-\-|Oracle Driver |\-\-\-|Oracle Engine|
\&  | DBI   |  |I|  |I|   \`\-\-\-\-\-\-\-\-\-\-\-\-\-\-\*(Aq   \`\-\-\-\-\-\-\-\-\-\-\-\-\-\*(Aq
\&  | API   |       | |...
\&  |methods|       | |... Other drivers
\&  \`\-\-\-\-\-\-\-\*(Aq       | |...
\&                  \`\-\*(Aq
.Ve
.PP
The \s-1API\s0, or Application Programming Interface, defines the
call interface and variables for Perl scripts to use. The \s-1API\s0
is implemented by the Perl \s-1DBI\s0 extension.
.PP
The \s-1DBI\s0 \*(L"dispatches\*(R" the method calls to the appropriate driver for
actual execution.  The \s-1DBI\s0 is also responsible for the dynamic loading
of drivers, error checking and handling, providing default
implementations for methods, and many other non-database specific duties.
.PP
Each driver
contains implementations of the \s-1DBI\s0 methods using the
private interface functions of the corresponding database engine.  Only authors
of sophisticated/multi\-database applications or generic library
functions need be concerned with drivers.
.Sh "Notation and Conventions"
.IX Subsection "Notation and Conventions"
The following conventions are used in this document:
.PP
.Vb 11
\&  $dbh    Database handle object
\&  $sth    Statement handle object
\&  $drh    Driver handle object (rarely seen or used in applications)