DIAVIS-wiki

• バックアップ一覧
• ソース を表示
• hsqldbデータベース は削除されています。
  • 1 (2006-11-26 (日) 17:07:29)
  • 2 (2006-11-26 (日) 17:45:58)
  • 3 (2007-01-11 (木) 20:27:25)
  • 4 (2007-01-12 (金) 15:38:18)
  • 5 (2007-01-13 (土) 15:36:06)
  • 6 (2007-01-20 (土) 21:13:51)
  • 7 (2007-01-24 (水) 15:55:02)
  • 8 (2007-01-25 (木) 11:08:28)
  • 9 (2007-01-25 (木) 16:09:52)
  • 10 (2007-02-01 (木) 04:13:43)
  • 11 (2007-02-05 (月) 15:13:10)
  • 12 (2007-05-04 (金) 11:30:51)
  • 13 (2007-05-09 (水) 04:20:16)
  • 14 (2007-05-10 (木) 03:58:57)
  • 15 (2007-05-10 (木) 07:09:00)
  • 16 (2007-08-31 (金) 08:47:25)
  • 17 (2007-08-31 (金) 19:42:21)

---

---

---

CREATE TABLE TAGS ( ID IDENTITY, KEYWORDS VARCHAR, EVENT_ID INTEGER, DATE TIMESTAMP );

INSERT INTO image (URI) values ('JanTschichold.jpg');

ResultSet rs;
rs = mSQL.executeSQL("select COUNT(*) from keyword where keyword='" + keyword + "';");
int keyword_id = -1;
try {
	rs.next();
	int nResult = rs.getInt(1);

select * from person  where database=0 and name like '%Hide%'  order by name

select * from person  where database=0 and UPPER(name) like '%HIDE%'  order by name

select * from person  where database=0 and UPPER(name) like '%Hide%'  order by name

SELECT * FROM Orders WHERE CustomerID = 'QUICK' AND OrderDate BETWEEN '1996/1/1' AND '1997/12/31'