Mercurial > hgrepos > hgweb.cgi > skipweb

annotate program/GiveMeALiftInYourCar/check_table.rb @ 1159:99248e0e3f6f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged
author GOTO Sakuya<c113061@e.koeki-u.ac.jp>
date Tue, 01 Dec 2015 22:49:24 +0900
parents 6117d10abd89
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
523
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
1 #!/usr/bin/env ruby
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
2 # coding: utf-8
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
3
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
4 require 'sqlite3'
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
5 require 'cgi'
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
6
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
7 c = CGI.new(:tag_maker => "html4", :accept_charset => "EUC-JP")
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
8
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
9 db = SQLite3::Database.new("sql/acounts.sq3")
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
10
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
11 sql = "select sub_name, password from acounts;"
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
12 value = db.execute(sql)
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
13
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
14 print("Content-type: text/html; charset=UTF-8 \n\n")
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
15
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
16 print'
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
17 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
18 "http://www.w3.org/TR/html4/strict.dtd">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
19 <html>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
20 <head>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
21 <title>トップページ -koeki network-</title>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
22 <style type="text/css">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
23 <!--
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
24
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
25 -->
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
26 </style>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
27 <link rel="stylesheet" type="text/css" href="group.css">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
28 </head>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
29 <body>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
30 <div class="base">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
31 <h1 ><img class="kn" src="koeki-network.png" alt="300x167(14204bytes)" width="300" height="120">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
32 </h1>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
33 <div class="bb">
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
34 <table>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
35 <tr><th>sub_name</th><th>pass</th></tr>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
36 '
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
37 value.each { |data|
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
38 printf('
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
39 <tr><td>%s</td><td>%s</td></tr>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
40 ', data[0], data[1])
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
41 }
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
42 # フッダ−
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
43 print'
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
44 </table>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
45 </div>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
46 <hr>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
47 <a class="cont" href="./top.rb?vis_log=out">ろぐあうと。</a>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
48 <a class="cont" href="./login.html">ほかのアカウントでログイン。</a>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
49 <address>c112124&#x40;h.koeki-u.ac.jp</address>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
50 </div>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
51 </body>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
52 </html>
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
53 '
6117d10abd89 Updated
MURAKAMI Masaki <c112124@h.koeki-u.ac.jp>
parents:
diff changeset
54

yatex.org