¿À¶óŬ DB¿¬µ¿Çؼ µ¥ÀÌŸ °Ë»öÀä. °ü¸®ÀÚ¸Þ´º ¸¸µå´Â ÁßÀÔ´Ï´Ù.
insertÇÏ°í delete´Â Á¦´ë·Î µÇ´Âµ¥ update°¡ Àß µÇÁö ¾Ê´Â±º¿ä. ¾Æ·¡¿¡ ¼Ò½º°¡ ÀÖÀ¸´Ï º¸½Ã°í ´äº¯Á» ºÎŹÇÕ´Ï´Ù.Á» ±ÞÇϰŵç¿ä.
test.cgi
#!/usr/local/bin/perl
#ȯ°æº¯¼ö°ªÀ» ¼³Á¤ÇÑ´Ù. nobody·Î Á¢±ÙÇÏ´Â »ç¿ëÀڵ鿡°Ô ²À ÇÊ¿äÇÑ º¯¼öÀÌ´Ù.
$ENV{
ORACLE_HOME
} = "/oracle/app/oracle/product/7.3.4";
$ENV{
NLS_LANG
} = "American_America.KO16KSC5601";
require "cgi-lib.pl";
require "teria-lib.pl";
&ReadParse;
$memnum=$in{
memnum
};
$nhanja=$in{
nhanja
};
$nhangu=$in{
nhangu
};
$curjob=$in{
curjob
};
$curoll=$in{
curoll
};
$prejob=$in{
prejob
};
$prroll=$in{
prroll
};
$birthd=$in{
birthd
};
$birthp=$in{
birthp
};
$memadd=$in{
memadd
};
$memtel=$in{
memtel
};
$offtel=$in{
offtel
};
$cacade=$in{
cacade
};
$carrel=$in{
carrel
};
$memcert=$in{
memcert
};
$membook=$in{
membook
};
$defSQL = "select * from ROLLBOOK_TBL where memnum = ".$memnum;
#DBI ¸¦ »ç¿ëÇÏ¿© DB Connection À» ÇÑ´Ù.
use DBI;
$drh = DBI->install_driver(
Oracle
);
die unless $drh;
$dbh = $drh->connect(
DB
,
user
,
pwd
);
die unless $dbh;
$dbh->{LongReadLen} = 16384;
$cursor = $dbh->prepare($defSQL);
$cursor->execute;
$dbh->disconnect;
print "Content-type:text/html
";
while(($memnum,$nhanja,$nhangu,$nemail,$curjob,$curoll,$prejob,$prroll,$birthd,$birthp,$memadd,$memtel,$offtel,$cacade,$carrel,$memcert,$membook)=$cursor->fetchrow){
print <
EndOfHtml
}
¾Æ·¡´Â form¹®À» ¹ÞÀº upok.cgiÀÔ´Ï´Ù.
#!/usr/local/bin/perl
#ȯ°æº¯¼ö°ªÀ» ¼³Á¤ÇÑ´Ù. nobody·Î Á¢±ÙÇÏ´Â »ç¿ëÀڵ鿡°Ô ²À ÇÊ¿äÇÑ º¯¼öÀÌ´Ù.
$ENV{
ORACLE_HOME
} = "/oracle/app/oracle/product/7.3.4";
$ENV{
NLS_LANG
} = "American_America.KO16KSC5601";
require "cgi-lib.pl";
require "teria-lib.pl";
&ReadParse;
#DBI ¸¦ »ç¿ëÇÏ¿© DB Connection À» ÇÑ´Ù.
use DBI;
$drh = DBI->install_driver(
Oracle
);
die unless $drh;
$dbh = $drh->connect(
DB
,
user
,
pwd
);
die unless $dbh;
$dbh->{LongReadLen} = 16384;
$memnum=$in{
memnum
};
$nhanja=$in{
nhanja
};
$nhangu=$in{
nhangu
};
$curjob=$in{
curjob
};
$curoll=$in{
curoll
};
$prejob=$in{
prejob
};
$prroll=$in{
prroll
};
$birthd=$in{
birthd
};
$birthp=$in{
birthp
};
$memadd=$in{
memadd
};
$memtel=$in{
memtel
};
$offtel=$in{
offtel
};
$cacade=$in{
cacade
};
$carrel=$in{
carrel
};
$memcert=$in{
memcert
};
$membook=$in{
membook
};
$upSQL = "update ROLLBOOK_TBL set nhanja=".$nhanja.",nhangu=".$nhangu.",curjob=".$curjob.",curoll=".$curoll.",prejob=".$prejob.",prroll=".$prroll.",birthd=".$birthd.",birthp=".$birthp.",memadd=".$memadd.",memtel=".$memtel.",offtel=".$offtel.",cacade=".$cacade.",carrel=".$carrel.",memcert=".$memcert.",membook=".$membook." where memnum=".$memnum;
$cursor = $dbh->prepare($upSQL);
$cursor->execute;
$dbh->disconnect;