ゲーム中は、このウインドウを閉じないでください。
起動に多少時間がかかりますので、しばらくお待ちくだされ(笑)
grant { permission java.net.URLPermission "http://blue-red.ddo.jp/~ao/-"; permission java.net.URLPermission "https://blue-red.ddo.jp/~ao/-"; };
[カテゴリ: プログラミング言語 > Java]
http://d.hatena.ne.jp/funatake/20100210/1265811725
http://d.hatena.ne.jp/funatake/20100210/1265811725
http://d.hatena.ne.jp/funatake/20100210/1265811725
aaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaa
1 |
import java.sql.*; import SQLite.*; public class SQLiteHello { public static void main(String[] args) { try { Class.forName("SQLite.JDBCDriver"); Connection c = DriverManager.getConnection("jdbc:sqlite:/testdatabase"); //これを入れない場合は、コミットしなくてもコネクションを切れば自動でコミットされるそうな。 c.setAutoCommit(false); Statement st = c.createStatement(); //INSERTなどのクエリを実行する場合は、こんなふうに。 //int rc = st.executeUpdate( "insert into testtable values(2,'Hello','World')" ); ResultSet rs = st.executeQuery( "select col1, col2, col3 from testtable" ); while ( rs.next() ) { int i = rs.getInt(1); String s1 = rs.getString(2); String s2 = rs.getString(3); System.out.println( i + " :" + s1 + s2 ); } rs.close(); st.close(); c.commit(); c.close(); } catch (java.lang.Exception e) { e.printStackTrace(); System.exit(0); } } } |
1 |
aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ssssssssssssssssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaassssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ssssssssssssssssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaassssssssssssssssssssssssssssssssssssss |
aaaaaa
bbbbbb
cccccc
- aaaa
- bbbbbbccccccc
a | b | c |
---|---|---|
a | b | c |
& |
aaaa
- aa
- aaa
aaaaa
1:/* ーーーーーー全体の設定ーーーーーー */ 2:body { 3: background-color: white; 4: color : black; 5: font-size : 14px; 6: line-height:20px; 7: margin : 0px; 8: padding: 0px; 9:} 10: 11:input,textarea{ 12: font-family:"Osaka",sans-serif; 13: font-size : 14px; 14:} 15: 16:div.section img{ 17: margin-top : 3px; 18: margin-bottom :0px; 19: margin-left : 35px; 20: padding: 0px; 21:} 22: 23:iframe{ 24: margin : 0px; 25: padding: 0px; 26: border : 0px; 27:} 28: 29:div.section p{ 30: margin : 1em 10px 1em 35px; 31: /*text-indent:1em;*/ 32:} 33:/* リストスタイル */ 34:ul li { 35: font-family:"Osaka",sans-serif; 36: list-style-image: url('./list_a.gif') 37:} 38: 39:ul li ul li { 40: font-family:sans-serif; 41: list-style-image: url('./list_b.gif') 42:} 43: 44:ul li ul li ul li { 45: font-family:sans-serif; 46: list-style-image: url('./list_c.gif') 47:} 48: 49:div.section ul,div.section ol{ 50: margin : 0.3em 0.3em 0.3em 35px; 51:} 52: 53:div.section ul li,div.section ol li { 54: margin-top : 0.1em; 55: margin-bottom : 0.1em; 56:} 57: 58: 59:/* リンクの設定 */ 60:A:link,A:visited { 61: color :#422100; 62: text-decoration : underline; 63:} 64: 65:A:hover { 66: color : #fe3670; 67: text-decoration : underline; 68: background-color: #fff4ab; 69:} 70: 71:A:active { 72: color : #FFFF00; 73: text-decoration : none; 74:} 75: 76:/* ーーーーーー全体の設定 終了ーーーーーー */ 77: 78:/* ーーーーーーメニューの設定開始ーーーーーー */ 79:/* メニューのサイズ */ 80:div.adminmenu { 81: background-color: #c8c9b5; 82: background-repeat: no-repeat; 83: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 84: font-size : 12px; 85: line-height : 26px; 86: font-weight : bold; 87: text-align: right; 88: height : 26px; 89: padding-right : 2px; 90: 91:} 92: 93:/* メニューの装飾 */ 94:/* リンク */ 95:div.adminmenu A{ 96: padding : 2px 7px; 97: font-weight : bold; 98: text-decoration : none; 99:} 100: 101:div.adminmenu A:link,div.adminmenu A:visited { 102: text-decoration : none; 103: color: white; 104: font-weight : bold; 105:} 106: 107:/* カーソルを上に持ってきた時リンク */ 108:div.adminmenu A:hover { 109: text-decoration : none; 110: font-weight : bold; 111: color : #FFFFFF; 112: background-color: #3CB371; 113:} 114:/* ーーーーーーメニューの設定終了ーーーーーー */ 115: 116:/* ーーーーーー headerの設定 ーーーーーー */ 117:div.header { 118: background-color: #f8f5f1; 119: padding: 1px 18px; 120: font-size : 11px; 121: line-height:13px; 122: margin-top: 0px; 123:} 124: 125:div.header li,div.header li A:link,div.header li A:visited{ 126: text-decoration : none; 127:} 128: 129:div.header li A:hover{ 130: text-decoration : underline; 131:} 132: 133:div.header ul li{ 134: list-style-image: url('./go_back_1.gif') 135:} 136: 137:div.header ul li ul li{ 138: list-style-image: url('./go_back_2.gif') 139:} 140: 141:div.header ul li ul li ul li{ 142: list-style-image: url('./go_back_3.gif') 143:} 144:/* ーーーーーー headerの設定終了 ーーーーーー */ 145: 146:/* ーーーーーー footer設定 ーーーーーー */ 147:.footer { 148: margin-top:0px; 149: margin-right:3px; 150: margin-bottom:0px; 151: text-align : right; 152: font-size : 10px; 153: font-style : italic; 154: background-position: left bottom; 155: background-repeat: no-repeat; 156: background-color: white; 157: height: 29px; 158:} 159: 160:.footer A { 161: text-decoration : none; 162:} 163:/* ーーーーーー footer設定終了 ーーーーーー */ 164: 165:hr { 166: border-top : #3CB371 2px solid; 167: color : #3CB371; 168:} 169: 170:/* ーーーーーー □囲み文字 ーーーーーー */ 171:pre { 172: -moz-border-radius: 10px; 173: border : #D3D3D3 1px solid; 174: background-color: #f8f5f1; 175: margin : 10px 20px 10px 35px; 176: padding: 5px 15px 5px 15px; 177: font-size : 13px; 178:} 179: 180:/* ーーーーーー 引用文 ーーーーーー */ 181:blockquote { 182: -moz-border-radius: 10px; 183: border : #d4d4d4 1px dotted; 184: background-color: #f8f5f1; 185: padding: 5px 15px 5px 15px; 186: margin : 10px 20px 10px 35px; 187: font-size : 13px; 188: font-style : italic; 189:} 190: 191:/* ーーーーーー見出しの設定開始ーーーーーー / 192:/* H1 */ 193:h1{ 194: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 195: font-weight : bold; 196: text-align : right; 197: font-size : 30px; 198: line-height:46px; 199: letter-spacing:2px; 200: border-bottom : #c8c9b5 6px solid; 201: margin: 0px 0px 0px 0px; 202: padding-right : 18px; 203: background-image: url(./himg2.jpg); 204: background-repeat: no-repeat; 205:} 206: 207:h1 A:link,h1 A:visited{ 208: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 209: color : black; 210: text-decoration : none; 211: text-shadow: #3CB371 0px 0px 10px; 212:} 213: 214:h1 A:hover { 215: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 216: font-weight : bold; 217: color : #fe3670; 218: text-shadow: yellow 0px 0px 10px; 219:} 220: 221:/* H2 */ 222:h2 { 223: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 224: font-weight : bold; 225: font-size : 20px; 226: line-height :20px; 227: letter-spacing:3px; 228: color : White; 229: padding-left : 35px; 230: padding-top : 4px; 231: padding-bottom : 4px; 232: background: #3CB371 url(./slc1.gif) no-repeat left top; 233: margin-top:30px; 234: margin-bottom:3px; 235:} 236: 237:h2 A:link,h2 A:visited { 238: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 239: font-weight : bold; 240: color : White; 241: text-decoration : none; 242:} 243: 244:h2 A:hover { 245: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 246: font-weight : bold; 247: color : #fe3670; 248: text-decoration : none; 249:} 250: 251:/* H3 */ 252:h3 { 253: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 254: font-weight : bold; 255: color : black; 256: font-size : 17px; 257: line-height :25px; 258: letter-spacing:2px; 259: background-color: #f8f5f1; 260: border-top : #3CB371 2px solid; 261: border-left : #3CB371 32px solid; 262: padding-left : 3px; 263: text-shadow: #808080 2px 2px 3px; 264: margin-top:15px; 265: margin-bottom:5px; 266: text-decoration : none; 267:} 268: 269:h3 A:link,h3 A:visited{ 270: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 271: font-weight : bold; 272: color: black; 273: text-decoration : none; 274:} 275: 276:h3 A:hover { 277: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 278: font-weight : bold; 279: color : #fe3670; 280: text-decoration : none; 281:} 282: 283:/* H4 */ 284:h4 { 285: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 286: font-weight : bold; 287: color : black; 288: font-size : 15px; 289: line-height :23px; 290: background-color: #f8f5f1; 291: border-left : #3CB371 32px solid; 292: padding-left : 3px; 293: text-shadow: #808080 2px 2px 3px; 294: margin-top:7px; 295: margin-bottom:5px; 296:} 297: 298:h4 A:link,h4 A:visited{ 299: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 300: font-weight : bold; 301: color: black; 302: text-decoration : none; 303:} 304: 305:h4 A:hover { 306: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 307: font-weight : bold; 308: color : #fe3670; 309: text-decoration : none; 310:} 311:/* ーーーーーー見出しの設定終了ーーーーーー */ 312: 313:/* ーーーーーーテーブル設定開始 ーーーーーー */ 314:table { 315: margin : 10px 10px 10px 35px; 316: border-collapse: collapse; 317: border-spacing: 0; 318: empty-cells: show; 319: border : #D3D3D3 1px solid; 320:} 321: 322:th { 323: padding-left : 20px; 324: padding-right : 20px; 325: background-color : #f8f5f1; 326: font-size : 11px; 327: line-height :11px; 328: padding :5px; 329: border : #D3D3D3 1px solid; 330:} 331: 332:td { 333: padding-left : 20px; 334: padding-right : 20px; 335: font-size : 12px; 336: line-height :12px; 337: padding :5px 10px; 338: border : #D3D3D3 1px solid; 339:} 340:/* ーーーーーーテーブル設定終了 ーーーーーー */ 341:/* ーーーーーー parteditプラグイン ーーーーーー */ 342:div.partedit { 343: font-family:"Osaka",sans-serif; 344: font-size : 12px; 345: line-height :12px; 346: margin-top:-2.3em; 347: text-align : right; 348: padding : 3px 15px 3px 15px; 349:} 350: 351:div.partedit A{ 352: text-decoration : none; 353:} 354: 355:/* ーーーーーー parteditプラグイン終了 ーーーーーー */ 356:dl { 357: margin : 0.5em 10px 0.5em 35px; 358:} 359:dt { 360: border-bottom : #696969 1px dotted; 361: font-weight : bold; 362: font-size : 14px; 363: line-height :18px; 364:} 365: 366:dd { 367: margin-left : 20px; 368: line-height :24px; 369:} 370: 371:div.main { 372: margin-left: 205px; 373: margin-right: 1px; 374:} 375: 376:/* ーーーーーー footer 設定開始 ーーーーーー */ 377:div.comment { 378: padding : 4px 16px; 379: margin-top : 10px; 380: margin-bottom : 10px; 381: font-size : 12px; 382: background-color: #f8f5f1; 383:} 384: 385:div.comment p { 386: margin-top : 5px; 387: margin-bottom : 5px; 388:} 389: 390:div.comment p A{ 391: color : black; 392: text-decoration : none; 393:} 394: 395:div.comment p A:hover { 396: color : #fe3670; 397: text-decoration : underline; 398:} 399: 400:div.comment h3 { 401: font-family:sans-serif; 402: font-size : 12px; 403: line-height :18px; 404: background-color: white; 405: border-top : #c8c9b5 2px solid; 406: border-right : #c8c9b5 15px solid; 407: border-bottom : #c8c9b5 2px solid; 408: border-left : #c8c9b5 15px solid; 409: padding-left : 3px; 410: text-shadow: #696969 2px 2px 3px; 411: margin:6px 0px; 412:} 413: 414:div.comment h3 A:link { 415: color : black; 416:} 417:/* ーーーーーー footer 設定終了 ーーーーーー */ 418: 419:/* ーーーーーー サイドバー(メニュー)設定開始 ーーーーーー */ 420:/* サイドバー(メニュー)設定 */ 421:div.sidebar { 422: overflow: hidden; 423: position : absolute; 424: top : 0px; 425: left : 1px; 426: width : 190px; 427: word-break : break-all; 428: background-color: #f8f5f1; 429:} 430:/* サイドバー(メニュー)見出し設定 */ 431:div.sidebar h2,div.sidebar h3,div.sidebar h4{ 432: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 433: font-size : 14px; 434: line-height :20px; 435: margin:0px; 436: background: #c8c9b5 url(./slc2.gif) no-repeat left top; 437: border:0px; 438: padding-top: 4px; 439: padding-bottom: 2px; 440: padding-left : 15px; 441: letter-spacing:1px; 442:} 443: 444:div.sidebar img{ 445: margin: 0px 0px 5px 5px; 446: padding : 0px; 447:} 448: 449:div.g4ser{ 450: margin : 0 0 -2em 0; 451: padding : 0; 452: border: 0; 453:} 454: 455:/* サイドバー(メニュー)リスト設定 */ 456:div.sidebar ul,div.sidebar li { 457: font-family:"Hiragino Kaku Gothic Pro", "ヒラギノ角ゴ Pro W8","Osaka",sans-serif; 458: font-size : 11px; 459: line-height :15px; 460: padding-left : 0px; 461: margin-left : 0px; 462: list-style-type: none; 463: text-decoration : none; 464:} 465: 466:div.sidebar ul{ 467: margin-top : 0; 468: margin-bottom : 0.5em; 469:} 470: 471:div.sidebar strong { 472: color : #3CB371; 473: padding-left : 17px; 474: font-size : 10px; 475: line-height :10px; 476: letter-spacing:2px; 477:} 478: 479:div.sidebar li A{ 480: padding-left : 0px; 481: border-left : #f8f5f1 17px solid; 482: list-style-type: none; 483: text-decoration : none; 484:} 485: 486:div.sidebar li A:hover{ 487: padding-left : 0px; 488: border-left : #3CB371 17px solid; 489: list-style-type: none; 490: text-decoration : none; 491:} 492: 493:div.sidebar li A:visited { 494: list-style-type: none; 495: text-decoration : none; 496:} 497: 498:div.sidebar ul li ul li A{ 499: padding-left : 15px; 500: border-left : #f8f5f1 17px solid; 501: list-style-type: none; 502: text-decoration : none; 503:} 504: 505:div.sidebar ul li ul li A:hover{ 506: padding-left : 15px; 507: border-left : #3CB371 17px solid; 508: list-style-type: none; 509: text-decoration : none; 510:} 511: 512:div.sidebar ul li ul li A:visited { 513: list-style-type: none; 514: text-decoration : none; 515:} 516: 517:div.sidebar ul li ul li ul li A{ 518: padding-left : 30px; 519: border-left : #f8f5f1 17px solid; 520: list-style-type: none; 521: text-decoration : none; 522:} 523: 524:div.sidebar ul li ul li ul li A:hover{ 525: padding-left : 30px; 526: border-left : #3CB371 17px solid; 527: list-style-type: none; 528: text-decoration : none; 529:} 530: 531:div.sidebar ul li ul li ul li A:visited { 532: list-style-type: none; 533: text-decoration : none; 534:} 535: 536:/* 検索padding設定 */ 537:div.sidebar form { 538: padding-left : 5px; 539:} 540: 541:div.sidebar p,div.sidebar EMBED { 542: padding : 0px; 543: margin : 0px; 544:} 545: 546:/* 一行コメント */ 547:div.linecom { 548: margin-top: 0px; 549: margin-left: 35px; 550: padding : 5px; 551: background-color: #c8c9b5; 552:} 553: 554: 555: 556:/* calendar plugin */ 557:.calendar { 558: border-collapse: collapse; 559: border-spacing: 0; 560: empty-cells: show; 561: border : 1px #d3d3d3 solid; 562: width : 798px; 563: height:500px; 564: padding: 0px; 565: text-align: center; 566: margin-left: auto; 567: margin-right: auto; 568:} 569: 570:.calendar A { 571: text-decoration : none; 572:} 573: 574:table.calendar th { 575: height: 24px; 576: font-size: 14px; 577: line-height :14px; 578: padding: 5px; 579:} 580: 581:table.calendar tr { 582: border-spacing: 0px; 583: border : 1px #d3d3d3 solid; 584: font-size: 8px; 585: line-height :12px; 586: margin: 0px; 587: padding: 0px; 588:} 589: 590:table.calendar td { 591: border-spacing: 0; 592: border : 1px #d3d3d3 solid; 593: background-color : #f8f5f1; 594: font-size: 14px; 595: line-height :14px; 596: margin: 0px; 597: padding: 2px; 598: text-align: center; 599: width : 114px; 600:} 601: 602:table.calendar td.calendar-prev-month, 603:table.calendar td.calendar-current-month, 604:table.calendar td.calendar-next-month, 605:table.calendar td.calendar-sunday, 606:table.calendar td.calendar-saturday{ 607: background-color : #dadada; 608:} 609: 610:table.calendar td.calendar-weekday{ 611: background-color : white; 612:} 613: 614:.calendar-sunday { 615: color: #f00; 616:} 617: 618:.calendar-saturday { 619: color: #00f; 620:} 621: 622:.calendar-weekday { 623: color: #000; 624:} 625: 626:table.calendar td.have A { 627: font-weight : bold; 628: color: #fe3670; 629:} 630: 631:table.calendar td.have{ 632: background-color : white; 633:} 634: 635:table.calendar td.today{ 636: background-color : #98FB98; 637:} 638: 639:.calendar-prev-month, .calendar-current-month, .calendar-next-month, 640:.calendar-sunday, .calendar-weekday, .calendar-saturday { 641: background-color : #D3D3D3; 642:} 643: 644:/* Menu用 */ 645:div.sidebar .calendar{ 646: width : 190px; 647: height : auto; 648: margin : 0px; 649:} 650: 651:div.sidebar div.plugin-calendar table.calendar tr td{ 652: font-size: 10px; 653: line-height :10px; 654:} 655: 656:div#toolbar img{ 657: margin : 0; 658:} 659: 660:/* プリント設定 */ 661:@media print { 662: div.header,div.adminmenu,div.footer,div.form,div.sidebar,div.partedit,div.comment,form {display:none;} 663: div.day,div.body{border:none;} 664: div.main{margin-left: 0%;} 665: h1 {padding-left: 0px;} 666: h2,h3 { font-size: medium; } 667: a { text-decoration: none; } 668:}
[通知用URL]
Tweet
最終更新時間:2019年03月19日 21時49分09秒