CGI プログラム１２
戻る
<![CDATA[
# t200.pl 200項目ごとに表示するテストプログラム
# 07.11.26
use strict;
use DBI;
use CGI qw/:standard/;
use HTML::Template;
my(%t,@loop,@rec,$n);
# データベースに連結
$t{dsn} = "DBI:mysql:host=localhost;database=cookbook";
$t{dbh} = DBI->connect($t{dsn}, "cbuser", "cbpass") or die "Cannot connect to server\n";
$t{dbh}->do("SET NAMES utf8");
if(!$t{dbh}){
print "SQL read ERROR!\n";
exit;
}
# t200の最大idを読む
$t{t200_maxid} = $t{dbh}->selectrow_array("select max(id) from t200");
$t{sth} = $t{dbh}->prepare("select * from t200 order by id desc");
$t{sth}->execute;
while (@rec = $t{sth}->fetchrow_array) {
push(@{ $t{ids} },$rec[0]);
push(@{ $t{names} },$rec[1]);
}
$t{sth}->finish;
$t{dbh}->disconnect;
@loop = ();
for $n ( 0 .. 49 ) {
#for $n ( 0 .. $#{ $t{ids} } ) {
$t{id1} = $t{ids}[$n];
$t{name1} = $t{names}[$n];
my %row = (
id => $t{id1},
name => $t{name1}
);
# put this row into the loop by reference
push(@loop, \%row);
}
$t{template} = HTML::Template->new(filename => 't200.htm');
$t{template}->param(t200_maxid => $t{t200_maxid});
$t{template}->param(LOOP => \@loop);
$t{template}->param(start => 0);
$t{template}->param(end => 49);
print $t{template}->output;
1;
-----------------------------------------------------------
# show200.pl 200項目ごとに表示するテストプログラム
# 07.11.26
use strict;
use DBI;
use CGI qw/:standard/;
use HTML::Template;
my(%t,@loop,@rec,$n);
$t{q} = new CGI;
$t{pattern} = $t{q}->param('pattern');
$t{start_old} = $t{q}->param('start');
$t{end_old} = $t{q}->param('end');
# データベースに連結
$t{dsn} = "DBI:mysql:host=localhost;database=cookbook";
$t{dbh} = DBI->connect($t{dsn}, "cbuser", "cbpass") or die "Cannot connect to server\n";
$t{dbh}->do("SET NAMES utf8");
if(!$t{dbh}){
print "SQL read ERROR!\n";
exit;
}
# t200の最大idを読む
$t{t200_maxid} = $t{dbh}->selectrow_array("select max(id) from t200");
$t{max} = $t{t200_maxid}-1;
if ( $t{pattern} eq 'DOWN' ) {
$t{start} = $t{start_old} + 50;
$t{end} = $t{end_old} + 50;
if ( $t{end} >= $t{max} ) {
$t{end} = $t{max};
if ( $t{start} > $t{end} ) {
$t{start} = $t{start_old};
}
}
}
if ( $t{pattern} eq 'UP' ) {
$t{start} = $t{start_old} - 50;
$t{end} = $t{end_old} - 50;
if ( $t{start} <= 0 ) {
$t{start} = 0;
if ( $t{end} < $t{start} ) {
$t{end} = $t{end_old};
}
}
}
$t{sth} = $t{dbh}->prepare("select * from t200 order by id desc");
$t{sth}->execute;
while (@rec = $t{sth}->fetchrow_array) {
push(@{ $t{ids} },$rec[0]);
push(@{ $t{names} },$rec[1]);
}
$t{sth}->finish;
$t{dbh}->disconnect;
@loop = ();
for $n ( $t{start} .. $t{end} ) {
#for $n ( 0 .. $#{ $t{ids} } ) {
$t{id1} = $t{ids}[$n];
$t{name1} = $t{names}[$n];
my %row = (
id => $t{id1},
name => $t{name1}
);
# put this row into the loop by reference
push(@loop, \%row);
}
$t{template} = HTML::Template->new(filename => 't200.htm');
$t{template}->param(t200_maxid => $t{t200_maxid});
$t{template}->param(LOOP => \@loop);
$t{template}->param(start => $t{start});
$t{template}->param(end => $t{end});
$t{template}->param(pattern => $t{pattern});
print $t{template}->output;
1;
-----------------------------------------------------------
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<head><title>t200</title>
<head>
<body bgcolor="#fcf5ca">
<h2>t200</h2>
<a href="http://localhost/index.html">http://localhost/index.html</a><br>
<hr>
t200_maxid==><TMPL_VAR NAME="t200_maxid"><br>
<hr>
<center>
<table>
<tr bgcolor="white"><th>ID</th><th>Name</th></tr>
<TMPL_LOOP NAME="LOOP">
<tr bgcolor="white"><td>
<TMPL_VAR NAME="id"></td><td><TMPL_VAR NAME="name"></td></tr>
</TMPL_LOOP>
</table>
start==><TMPL_VAR NAME="start"><br>
end==><TMPL_VAR NAME="end"><br>
pattern==><TMPL_VAR NAME="pattern"><br>
<form method="POST" action="show200.pl">
<input type="submit" value="前のデータへ">
<input type="hidden" name="pattern" value="UP">
<input type="hidden" name="start" value="<TMPL_VAR NAME="start">">
<input type="hidden" name="end" value="<TMPL_VAR NAME="end">">
</form>
<form method="POST" action="show200.pl">
<input type="submit" value="後のデータへ">
<input type="hidden" name="pattern" value="DOWN">
<input type="hidden" name="start" value="<TMPL_VAR NAME="start">">
<input type="hidden" name="end" value="<TMPL_VAR NAME="end">">
</form>
</center>
<hr>
</body>
</html>
-----------------------------------------------------------
netstat でPort確認
IIS Adminの「サービスの再起動」を実施
#Software: Microsoft Internet Information Services 5.1
#Version: 1.0
#Date: 2007-11-26 09:56:44
#Fields: time c-ip cs-method cs-uri-stem sc-status
09:56:44 127.0.0.1 GET /scripts/t200.pl 200
# SQLファイルを生成
use strict;
my (%t,$n);
open(OUT,">../sql/t200.sql");
print OUT 'DROP TABLE IF EXISTS t200;',"\n";
print OUT 'CREATE TABLE t200',"\n";
print OUT '(',"\n";
print OUT ' id INT AUTO_INCREMENT,',"\n";
print OUT ' name TEXT,',"\n";
print OUT ' PRIMARY KEY (id)',"\n";
print OUT ');',"\n\n";
for $n ( 0 .. 420 ) {
$t{NO} = $n+10;
print OUT 'INSERT INTO t200';
print OUT ' (name) VALUES("';
print OUT $t{NO},'");';
print OUT "\n";
}
print "The output file is ../sql/t200.sql.\n";
---------------------------------------------------------
DROP TABLE IF EXISTS t200;
CREATE TABLE t200
(
id INT AUTO_INCREMENT,
name TEXT,
PRIMARY KEY (id)
);
INSERT INTO t200 (name) VALUES("10");
INSERT INTO t200 (name) VALUES("11");
INSERT INTO t200 (name) VALUES("12");
INSERT INTO t200 (name) VALUES("13");
INSERT INTO t200 (name) VALUES("14");
INSERT INTO t200 (name) VALUES("15");
INSERT INTO t200 (name) VALUES("16");
INSERT INTO t200 (name) VALUES("17");
INSERT INTO t200 (name) VALUES("18");
INSERT INTO t200 (name) VALUES("19");
INSERT INTO t200 (name) VALUES("20");
INSERT INTO t200 (name) VALUES("21");
INSERT INTO t200 (name) VALUES("22");
INSERT INTO t200 (name) VALUES("23");
INSERT INTO t200 (name) VALUES("24");
INSERT INTO t200 (name) VALUES("25");
INSERT INTO t200 (name) VALUES("26");
INSERT INTO t200 (name) VALUES("27");
INSERT INTO t200 (name) VALUES("28");
INSERT INTO t200 (name) VALUES("29");
INSERT INTO t200 (name) VALUES("30");
INSERT INTO t200 (name) VALUES("31");
INSERT INTO t200 (name) VALUES("32");
INSERT INTO t200 (name) VALUES("33");
INSERT INTO t200 (name) VALUES("34");
INSERT INTO t200 (name) VALUES("35");
INSERT INTO t200 (name) VALUES("36");
INSERT INTO t200 (name) VALUES("37");
INSERT INTO t200 (name) VALUES("38");
INSERT INTO t200 (name) VALUES("39");
INSERT INTO t200 (name) VALUES("40");
INSERT INTO t200 (name) VALUES("41");
INSERT INTO t200 (name) VALUES("42");
INSERT INTO t200 (name) VALUES("43");
INSERT INTO t200 (name) VALUES("44");
INSERT INTO t200 (name) VALUES("45");
INSERT INTO t200 (name) VALUES("46");
INSERT INTO t200 (name) VALUES("47");
INSERT INTO t200 (name) VALUES("48");
INSERT INTO t200 (name) VALUES("49");
INSERT INTO t200 (name) VALUES("50");
INSERT INTO t200 (name) VALUES("51");
INSERT INTO t200 (name) VALUES("52");
INSERT INTO t200 (name) VALUES("53");
INSERT INTO t200 (name) VALUES("54");
INSERT INTO t200 (name) VALUES("55");
INSERT INTO t200 (name) VALUES("56");
INSERT INTO t200 (name) VALUES("57");
INSERT INTO t200 (name) VALUES("58");
INSERT INTO t200 (name) VALUES("59");
INSERT INTO t200 (name) VALUES("60");
INSERT INTO t200 (name) VALUES("61");
INSERT INTO t200 (name) VALUES("62");
INSERT INTO t200 (name) VALUES("63");
INSERT INTO t200 (name) VALUES("64");
INSERT INTO t200 (name) VALUES("65");
INSERT INTO t200 (name) VALUES("66");
INSERT INTO t200 (name) VALUES("67");
INSERT INTO t200 (name) VALUES("68");
INSERT INTO t200 (name) VALUES("69");
INSERT INTO t200 (name) VALUES("70");
INSERT INTO t200 (name) VALUES("71");
INSERT INTO t200 (name) VALUES("72");
INSERT INTO t200 (name) VALUES("73");
INSERT INTO t200 (name) VALUES("74");
INSERT INTO t200 (name) VALUES("75");
INSERT INTO t200 (name) VALUES("76");
INSERT INTO t200 (name) VALUES("77");
INSERT INTO t200 (name) VALUES("78");
INSERT INTO t200 (name) VALUES("79");
INSERT INTO t200 (name) VALUES("80");
INSERT INTO t200 (name) VALUES("81");
INSERT INTO t200 (name) VALUES("82");
INSERT INTO t200 (name) VALUES("83");
INSERT INTO t200 (name) VALUES("84");
INSERT INTO t200 (name) VALUES("85");
INSERT INTO t200 (name) VALUES("86");
INSERT INTO t200 (name) VALUES("87");
INSERT INTO t200 (name) VALUES("88");
INSERT INTO t200 (name) VALUES("89");
INSERT INTO t200 (name) VALUES("90");
INSERT INTO t200 (name) VALUES("91");
INSERT INTO t200 (name) VALUES("92");
INSERT INTO t200 (name) VALUES("93");
INSERT INTO t200 (name) VALUES("94");
INSERT INTO t200 (name) VALUES("95");
INSERT INTO t200 (name) VALUES("96");
INSERT INTO t200 (name) VALUES("97");
INSERT INTO t200 (name) VALUES("98");
INSERT INTO t200 (name) VALUES("99");
INSERT INTO t200 (name) VALUES("100");
INSERT INTO t200 (name) VALUES("101");
INSERT INTO t200 (name) VALUES("102");
INSERT INTO t200 (name) VALUES("103");
INSERT INTO t200 (name) VALUES("104");
INSERT INTO t200 (name) VALUES("105");
INSERT INTO t200 (name) VALUES("106");
INSERT INTO t200 (name) VALUES("107");
INSERT INTO t200 (name) VALUES("108");
INSERT INTO t200 (name) VALUES("109");
INSERT INTO t200 (name) VALUES("110");
INSERT INTO t200 (name) VALUES("111");
INSERT INTO t200 (name) VALUES("112");
INSERT INTO t200 (name) VALUES("113");
INSERT INTO t200 (name) VALUES("114");
INSERT INTO t200 (name) VALUES("115");
INSERT INTO t200 (name) VALUES("116");
INSERT INTO t200 (name) VALUES("117");
INSERT INTO t200 (name) VALUES("118");
INSERT INTO t200 (name) VALUES("119");
INSERT INTO t200 (name) VALUES("120");
INSERT INTO t200 (name) VALUES("121");
INSERT INTO t200 (name) VALUES("122");
INSERT INTO t200 (name) VALUES("123");
INSERT INTO t200 (name) VALUES("124");
INSERT INTO t200 (name) VALUES("125");
INSERT INTO t200 (name) VALUES("126");
INSERT INTO t200 (name) VALUES("127");
INSERT INTO t200 (name) VALUES("128");
INSERT INTO t200 (name) VALUES("129");
INSERT INTO t200 (name) VALUES("130");
INSERT INTO t200 (name) VALUES("131");
INSERT INTO t200 (name) VALUES("132");
INSERT INTO t200 (name) VALUES("133");
INSERT INTO t200 (name) VALUES("134");
INSERT INTO t200 (name) VALUES("135");
INSERT INTO t200 (name) VALUES("136");
INSERT INTO t200 (name) VALUES("137");
INSERT INTO t200 (name) VALUES("138");
INSERT INTO t200 (name) VALUES("139");
INSERT INTO t200 (name) VALUES("140");
INSERT INTO t200 (name) VALUES("141");
INSERT INTO t200 (name) VALUES("142");
INSERT INTO t200 (name) VALUES("143");
INSERT INTO t200 (name) VALUES("144");
INSERT INTO t200 (name) VALUES("145");
INSERT INTO t200 (name) VALUES("146");
INSERT INTO t200 (name) VALUES("147");
INSERT INTO t200 (name) VALUES("148");
INSERT INTO t200 (name) VALUES("149");
INSERT INTO t200 (name) VALUES("150");
INSERT INTO t200 (name) VALUES("151");
INSERT INTO t200 (name) VALUES("152");
INSERT INTO t200 (name) VALUES("153");
INSERT INTO t200 (name) VALUES("154");
INSERT INTO t200 (name) VALUES("155");
INSERT INTO t200 (name) VALUES("156");
INSERT INTO t200 (name) VALUES("157");
INSERT INTO t200 (name) VALUES("158");
INSERT INTO t200 (name) VALUES("159");
INSERT INTO t200 (name) VALUES("160");
INSERT INTO t200 (name) VALUES("161");
INSERT INTO t200 (name) VALUES("162");
INSERT INTO t200 (name) VALUES("163");
INSERT INTO t200 (name) VALUES("164");
INSERT INTO t200 (name) VALUES("165");
INSERT INTO t200 (name) VALUES("166");
INSERT INTO t200 (name) VALUES("167");
INSERT INTO t200 (name) VALUES("168");
INSERT INTO t200 (name) VALUES("169");
INSERT INTO t200 (name) VALUES("170");
INSERT INTO t200 (name) VALUES("171");
INSERT INTO t200 (name) VALUES("172");
INSERT INTO t200 (name) VALUES("173");
INSERT INTO t200 (name) VALUES("174");
INSERT INTO t200 (name) VALUES("175");
INSERT INTO t200 (name) VALUES("176");
INSERT INTO t200 (name) VALUES("177");
INSERT INTO t200 (name) VALUES("178");
INSERT INTO t200 (name) VALUES("179");
INSERT INTO t200 (name) VALUES("180");
INSERT INTO t200 (name) VALUES("181");
INSERT INTO t200 (name) VALUES("182");
INSERT INTO t200 (name) VALUES("183");
INSERT INTO t200 (name) VALUES("184");
INSERT INTO t200 (name) VALUES("185");
INSERT INTO t200 (name) VALUES("186");
INSERT INTO t200 (name) VALUES("187");
INSERT INTO t200 (name) VALUES("188");
INSERT INTO t200 (name) VALUES("189");
INSERT INTO t200 (name) VALUES("190");
INSERT INTO t200 (name) VALUES("191");
INSERT INTO t200 (name) VALUES("192");
INSERT INTO t200 (name) VALUES("193");
INSERT INTO t200 (name) VALUES("194");
INSERT INTO t200 (name) VALUES("195");
INSERT INTO t200 (name) VALUES("196");
INSERT INTO t200 (name) VALUES("197");
INSERT INTO t200 (name) VALUES("198");
INSERT INTO t200 (name) VALUES("199");
INSERT INTO t200 (name) VALUES("200");
INSERT INTO t200 (name) VALUES("201");
INSERT INTO t200 (name) VALUES("202");
INSERT INTO t200 (name) VALUES("203");
INSERT INTO t200 (name) VALUES("204");
INSERT INTO t200 (name) VALUES("205");
INSERT INTO t200 (name) VALUES("206");
INSERT INTO t200 (name) VALUES("207");
INSERT INTO t200 (name) VALUES("208");
INSERT INTO t200 (name) VALUES("209");
INSERT INTO t200 (name) VALUES("210");
INSERT INTO t200 (name) VALUES("211");
INSERT INTO t200 (name) VALUES("212");
INSERT INTO t200 (name) VALUES("213");
INSERT INTO t200 (name) VALUES("214");
INSERT INTO t200 (name) VALUES("215");
INSERT INTO t200 (name) VALUES("216");
INSERT INTO t200 (name) VALUES("217");
INSERT INTO t200 (name) VALUES("218");
INSERT INTO t200 (name) VALUES("219");
INSERT INTO t200 (name) VALUES("220");
INSERT INTO t200 (name) VALUES("221");
INSERT INTO t200 (name) VALUES("222");
INSERT INTO t200 (name) VALUES("223");
INSERT INTO t200 (name) VALUES("224");
INSERT INTO t200 (name) VALUES("225");
INSERT INTO t200 (name) VALUES("226");
INSERT INTO t200 (name) VALUES("227");
INSERT INTO t200 (name) VALUES("228");
INSERT INTO t200 (name) VALUES("229");
INSERT INTO t200 (name) VALUES("230");
INSERT INTO t200 (name) VALUES("231");
INSERT INTO t200 (name) VALUES("232");
INSERT INTO t200 (name) VALUES("233");
INSERT INTO t200 (name) VALUES("234");
INSERT INTO t200 (name) VALUES("235");
INSERT INTO t200 (name) VALUES("236");
INSERT INTO t200 (name) VALUES("237");
INSERT INTO t200 (name) VALUES("238");
INSERT INTO t200 (name) VALUES("239");
INSERT INTO t200 (name) VALUES("240");
INSERT INTO t200 (name) VALUES("241");
INSERT INTO t200 (name) VALUES("242");
INSERT INTO t200 (name) VALUES("243");
INSERT INTO t200 (name) VALUES("244");
INSERT INTO t200 (name) VALUES("245");
INSERT INTO t200 (name) VALUES("246");
INSERT INTO t200 (name) VALUES("247");
INSERT INTO t200 (name) VALUES("248");
INSERT INTO t200 (name) VALUES("249");
INSERT INTO t200 (name) VALUES("250");
INSERT INTO t200 (name) VALUES("251");
INSERT INTO t200 (name) VALUES("252");
INSERT INTO t200 (name) VALUES("253");
INSERT INTO t200 (name) VALUES("254");
INSERT INTO t200 (name) VALUES("255");
INSERT INTO t200 (name) VALUES("256");
INSERT INTO t200 (name) VALUES("257");
INSERT INTO t200 (name) VALUES("258");
INSERT INTO t200 (name) VALUES("259");
INSERT INTO t200 (name) VALUES("260");
INSERT INTO t200 (name) VALUES("261");
INSERT INTO t200 (name) VALUES("262");
INSERT INTO t200 (name) VALUES("263");
INSERT INTO t200 (name) VALUES("264");
INSERT INTO t200 (name) VALUES("265");
INSERT INTO t200 (name) VALUES("266");
INSERT INTO t200 (name) VALUES("267");
INSERT INTO t200 (name) VALUES("268");
INSERT INTO t200 (name) VALUES("269");
INSERT INTO t200 (name) VALUES("270");
INSERT INTO t200 (name) VALUES("271");
INSERT INTO t200 (name) VALUES("272");
INSERT INTO t200 (name) VALUES("273");
INSERT INTO t200 (name) VALUES("274");
INSERT INTO t200 (name) VALUES("275");
INSERT INTO t200 (name) VALUES("276");
INSERT INTO t200 (name) VALUES("277");
INSERT INTO t200 (name) VALUES("278");
INSERT INTO t200 (name) VALUES("279");
INSERT INTO t200 (name) VALUES("280");
INSERT INTO t200 (name) VALUES("281");
INSERT INTO t200 (name) VALUES("282");
INSERT INTO t200 (name) VALUES("283");
INSERT INTO t200 (name) VALUES("284");
INSERT INTO t200 (name) VALUES("285");
INSERT INTO t200 (name) VALUES("286");
INSERT INTO t200 (name) VALUES("287");
INSERT INTO t200 (name) VALUES("288");
INSERT INTO t200 (name) VALUES("289");
INSERT INTO t200 (name) VALUES("290");
INSERT INTO t200 (name) VALUES("291");
INSERT INTO t200 (name) VALUES("292");
INSERT INTO t200 (name) VALUES("293");
INSERT INTO t200 (name) VALUES("294");
INSERT INTO t200 (name) VALUES("295");
INSERT INTO t200 (name) VALUES("296");
INSERT INTO t200 (name) VALUES("297");
INSERT INTO t200 (name) VALUES("298");
INSERT INTO t200 (name) VALUES("299");
INSERT INTO t200 (name) VALUES("300");
INSERT INTO t200 (name) VALUES("301");
INSERT INTO t200 (name) VALUES("302");
INSERT INTO t200 (name) VALUES("303");
INSERT INTO t200 (name) VALUES("304");
INSERT INTO t200 (name) VALUES("305");
INSERT INTO t200 (name) VALUES("306");
INSERT INTO t200 (name) VALUES("307");
INSERT INTO t200 (name) VALUES("308");
INSERT INTO t200 (name) VALUES("309");
INSERT INTO t200 (name) VALUES("310");
INSERT INTO t200 (name) VALUES("311");
INSERT INTO t200 (name) VALUES("312");
INSERT INTO t200 (name) VALUES("313");
INSERT INTO t200 (name) VALUES("314");
INSERT INTO t200 (name) VALUES("315");
INSERT INTO t200 (name) VALUES("316");
INSERT INTO t200 (name) VALUES("317");
INSERT INTO t200 (name) VALUES("318");
INSERT INTO t200 (name) VALUES("319");
INSERT INTO t200 (name) VALUES("320");
INSERT INTO t200 (name) VALUES("321");
INSERT INTO t200 (name) VALUES("322");
INSERT INTO t200 (name) VALUES("323");
INSERT INTO t200 (name) VALUES("324");
INSERT INTO t200 (name) VALUES("325");
INSERT INTO t200 (name) VALUES("326");
INSERT INTO t200 (name) VALUES("327");
INSERT INTO t200 (name) VALUES("328");
INSERT INTO t200 (name) VALUES("329");
INSERT INTO t200 (name) VALUES("330");
INSERT INTO t200 (name) VALUES("331");
INSERT INTO t200 (name) VALUES("332");
INSERT INTO t200 (name) VALUES("333");
INSERT INTO t200 (name) VALUES("334");
INSERT INTO t200 (name) VALUES("335");
INSERT INTO t200 (name) VALUES("336");
INSERT INTO t200 (name) VALUES("337");
INSERT INTO t200 (name) VALUES("338");
INSERT INTO t200 (name) VALUES("339");
INSERT INTO t200 (name) VALUES("340");
INSERT INTO t200 (name) VALUES("341");
INSERT INTO t200 (name) VALUES("342");
INSERT INTO t200 (name) VALUES("343");
INSERT INTO t200 (name) VALUES("344");
INSERT INTO t200 (name) VALUES("345");
INSERT INTO t200 (name) VALUES("346");
INSERT INTO t200 (name) VALUES("347");
INSERT INTO t200 (name) VALUES("348");
INSERT INTO t200 (name) VALUES("349");
INSERT INTO t200 (name) VALUES("350");
INSERT INTO t200 (name) VALUES("351");
INSERT INTO t200 (name) VALUES("352");
INSERT INTO t200 (name) VALUES("353");
INSERT INTO t200 (name) VALUES("354");
INSERT INTO t200 (name) VALUES("355");
INSERT INTO t200 (name) VALUES("356");
INSERT INTO t200 (name) VALUES("357");
INSERT INTO t200 (name) VALUES("358");
INSERT INTO t200 (name) VALUES("359");
INSERT INTO t200 (name) VALUES("360");
INSERT INTO t200 (name) VALUES("361");
INSERT INTO t200 (name) VALUES("362");
INSERT INTO t200 (name) VALUES("363");
INSERT INTO t200 (name) VALUES("364");
INSERT INTO t200 (name) VALUES("365");
INSERT INTO t200 (name) VALUES("366");
INSERT INTO t200 (name) VALUES("367");
INSERT INTO t200 (name) VALUES("368");
INSERT INTO t200 (name) VALUES("369");
INSERT INTO t200 (name) VALUES("370");
INSERT INTO t200 (name) VALUES("371");
INSERT INTO t200 (name) VALUES("372");
INSERT INTO t200 (name) VALUES("373");
INSERT INTO t200 (name) VALUES("374");
INSERT INTO t200 (name) VALUES("375");
INSERT INTO t200 (name) VALUES("376");
INSERT INTO t200 (name) VALUES("377");
INSERT INTO t200 (name) VALUES("378");
INSERT INTO t200 (name) VALUES("379");
INSERT INTO t200 (name) VALUES("380");
INSERT INTO t200 (name) VALUES("381");
INSERT INTO t200 (name) VALUES("382");
INSERT INTO t200 (name) VALUES("383");
INSERT INTO t200 (name) VALUES("384");
INSERT INTO t200 (name) VALUES("385");
INSERT INTO t200 (name) VALUES("386");
INSERT INTO t200 (name) VALUES("387");
INSERT INTO t200 (name) VALUES("388");
INSERT INTO t200 (name) VALUES("389");
INSERT INTO t200 (name) VALUES("390");
INSERT INTO t200 (name) VALUES("391");
INSERT INTO t200 (name) VALUES("392");
INSERT INTO t200 (name) VALUES("393");
INSERT INTO t200 (name) VALUES("394");
INSERT INTO t200 (name) VALUES("395");
INSERT INTO t200 (name) VALUES("396");
INSERT INTO t200 (name) VALUES("397");
INSERT INTO t200 (name) VALUES("398");
INSERT INTO t200 (name) VALUES("399");
INSERT INTO t200 (name) VALUES("400");
INSERT INTO t200 (name) VALUES("401");
INSERT INTO t200 (name) VALUES("402");
INSERT INTO t200 (name) VALUES("403");
INSERT INTO t200 (name) VALUES("404");
INSERT INTO t200 (name) VALUES("405");
INSERT INTO t200 (name) VALUES("406");
INSERT INTO t200 (name) VALUES("407");
INSERT INTO t200 (name) VALUES("408");
INSERT INTO t200 (name) VALUES("409");
INSERT INTO t200 (name) VALUES("410");
INSERT INTO t200 (name) VALUES("411");
INSERT INTO t200 (name) VALUES("412");
INSERT INTO t200 (name) VALUES("413");
INSERT INTO t200 (name) VALUES("414");
INSERT INTO t200 (name) VALUES("415");
INSERT INTO t200 (name) VALUES("416");
INSERT INTO t200 (name) VALUES("417");
INSERT INTO t200 (name) VALUES("418");
INSERT INTO t200 (name) VALUES("419");
INSERT INTO t200 (name) VALUES("420");
INSERT INTO t200 (name) VALUES("421");
INSERT INTO t200 (name) VALUES("422");
INSERT INTO t200 (name) VALUES("423");
INSERT INTO t200 (name) VALUES("424");
INSERT INTO t200 (name) VALUES("425");
INSERT INTO t200 (name) VALUES("426");
INSERT INTO t200 (name) VALUES("427");
INSERT INTO t200 (name) VALUES("428");
INSERT INTO t200 (name) VALUES("429");
INSERT INTO t200 (name) VALUES("430");
]]>
戻る