Web JDBC JDBC Java JDBC DataBase Web CHtmlView...

Size: px

Start display at page:

Download "Web JDBC JDBC Java JDBC DataBase Web CHtmlView..."

とらふみさかわ
7 years ago
Views:

1 Web-DB 13

2 Web JDBC JDBC Java JDBC DataBase Web CHtmlView , DataBase Web Web DataBase Web URL

3 (DSL FTTH CATV) 719 ( ) Web Amazon DataBase Web Web Web DataBase Web 1 URL[1] 3

4 2 Web Web Web DataBase 2 DataBase HTML Java Servlet DataBase JDBC(Java DataBase Connectivity) Java Servlet DataBase Web 2.1 JDBC JDBC JDBC Java Java JDBC 2 API(JDBC API JDBC API) JDBC DataBase DataBase JDBC API DataBase DataBase JDBC JDBC API DataBase JDBC 4 (JDBC-ODBC API JDBC Java ) JDBC-ODBC ODBC ODBC API API JDBC Java Java Java PostgreSQL JDBC Java ( ) Java ODBC DataBase JDBC 2 URL [2] 4

5 native ODBC Java Java JDBC OS Windows 2000 Server Java Java 2 SDK Standard Edition Version 1.4.0_01 JDBC JDBC3 [ ] [ ] [ ] [ ] [PATH] java C: j2sdk1.4.0_01 bin (;) [ ] JDBC [CLASSPATH] postgre.jar [CLASSPATH] DataBase JDBC API JDBC import import java.sql.*; JDBC DataBase JDBC PostgreSQL JDBC PostgreSQL JDBC Class.forName 1:try { 2: Class.forName( org.postgresql.driver ); 3: // Connect to database 4:} catch (ClassNotFoundException ex) { 5: // 6:} 5

6 JDBC DataBase JDBC API DriverManager.getConnection Connection conn = DriverManager.getConnection(url, usr, pwd); usr pwd String url String WWW URL DataBase jdbc:postgresql:databasename jdbc:postgresql://hostname/databasename jdbc:postgresql://hostname:port/databasename 3 jdbc:postgresql://localhost:5432/test Java Web HTML Web Tomcat root DataBase DataBase root 6

7 customer C_ID ID C_FNAME 20 C_LNAME 20 C_ZIP C_ADDR C_ADDR C_PHONE C_ 50 item I_ID ID I_TITLE 60 I_M_ID ID I_SUBJECT 10 I_PRICE I_IMAGE 40 URL maker M_ID ID M_NAME 50 M_URL 50 URL orders O_ID ID O_DATE O_C_ID ID 7

8 order_item OI_ID ID OI_O_ID ID OI_I_ID ID OI_NUM DataBase

9 2.1 customer maker C_ID M_ID C_FNAME M_NAME C_LNAME M_URL C_ZIP C_ADDR1 orders C_ADDR2 O_ID C_PHONE O_DATE C_ O_C_ID item I_ID I_TITLE I_M_ID I_SUBJECT I_PRICE I_IMAGE order_item OI_ID OI_O_ID OI_I_ID OI_NUM 9

10 162,080 (4, ,378) bytes 162,561 (4, ,813) bytes 2.3 Web DB DB 2.1 Web 10,000 bytes 100,000 bytes 5,244 bytes 22,747 bytes 62,440 (10, ,440) bytes 464,890 (10, ,890) bytes 152,440 (100, ,440) bytes 545,890 (100, ,890) bytes 4,781 bytes 9,126 bytes 27,401 (1, ,214) bytes 114,375 (1, ,288) bytes 684,480 (4, ,808) bytes 4,782 bytes 86,977 bytes 27,454 (1, ,333) bytes 114,331 (1, ,215) bytes (4, ,444) bytes 4,782 bytes 865,477 bytes (1, ,189) bytes 114,795 (1, ,717) bytes 162,650 (4, ,816) bytes 686,128 (4, ,324) bytes DataBase Web DataBase Web 10

11 2.4 Web DataBase Web SQL SELECT Web SQL DataBase Web SELECT FROM maker 11

12 DataBase Web SELECT FROM customer 12

13 DataBase Web SELECT c_fname, c_lname FROM customer WHERE c_id =? ID? SELECT i_title, i_subject, oi_num, i_price, i_image FROM item, orders, order_item WHERE orders.o_id = order_item.oi_o_id AND order_item.oi_i_id = item.i_id AND orders.o_c_id =? ID? ID ID ID ID URL 13

14 DataBase Web SELECT m_name, m_url, i_title, i_price, i_image FROM item, maker WHERE maker.m_id = item.i_m_id AND i_subject = 'CPU' LIMIT 30 CPU ID ID URL URL 30 14

15 3 Web Java Servlet Web JDBC DataBase SQL 3.1 Web DataBase Visual Studio 6.0 Enterprise 3.1 CHtmlView 3 CHtmlView MFC(Microsoft Foundation Class) / Web Browser Web Browser World Wide Web Web Browser Uniform Resource Locator(URL) MFC CHtmlView MFC (SDI 4 MDI 5 ) CView CView CHtmlView Web Browser 15

16 Web Web [MFC ] CHtmlView Web Browser ActiveX ( CHtmlView) Internet Explorer 4.0 Windows NT version 4.0 CHtmlView Web HTML CHtmlView Internet Explorer Web Browser MFC MFC AppWizard(exe) ( WebBrowse ) AppWizard SDI Internet Explorer ReBar CHtmlView URL IDC_EADDRESS MainFrm.h void OnNewAddress() MainFrm.cpp 1:void CMainFrame::OnNewAddress() 2:{ 3: CString saddress; 16

17 4: m_wnddlgbar.getdlgitem(idc_eaddress)->getwindowtext(saddress); 5: ((CWebBrowseView*)GetActiveView())->Navigate(sAddress); 6:} 4 GetWindowText saddress 5 GetActiveView CWebBrowseView Navigate URL MainFrm.cpp WebBrowseDoc.h WebBrowseView.h IDC_STATICTIME1 MainFrm.h double start_time void GetAddress() WebBrowseView.h void OnBeforeNavigate2(LPCTSTR lpszurl, DWORD nflags, LPCTSTR lpsztargetframename, CByteArray& beposteddata, LPCTSTR lpszheaders, BOOL* pbcancel) MFC WebBrowseView.cpp 1:void CWebBrowseView::OnBeforeNavigate2(LPCTSTR lpszurl, DWORD nflags, LPCTSTR lpsztargetframename, CByteArray& beposteddata, LPCTSTR lpszheaders, BOOL* pbcancel) 2:{ 3: ((CMainFrame*)GetParentFrame())->GetAddress(); 4:} 17

18 3 OnBeforeNavigate2 GetAddress MainFrm.cpp 1:void CMainFrame::GetAddress() 2:{ 3: start_time = GetTickCount(); 4: CString tmp1; 5: tmp1.format( "%.0f", start_time); 6: m_wnddlgbar.getdlgitem(idc_statictime1)->setwindowtext((lpctstr)tmp1); 7:} 3 GetTickCount start_time 6 SetWindowText start_time 3.2, IDC_STATICTIME2 IDC_STATICTIME3 MainFrm.h double stop_time void SetAddress() WebBrowseView.h void OnDocumentComplete(LPCTSTR lpszurl) MFC WebBrowseView.cpp 1:void CWebBrowseView::OnDocumentComplete(LPCTSTR lpszurl) 2:{ 3: ((CMainFrame*)GetParentFrame())->SetAddress(lpszUrl); 4:} 18

19 3 OnDocumentComplete Web URL MainFrm.cpp 1:void CMainFrame::SetAddress(LPCTSTR lpszurl) 2:{ 3: m_wnddlgbar.getdlgitem(idc_eaddress)->setwindowtext(lpszurl); 4: 5: stop_time = GetTickCount(); 6: CString tmp2; 7: tmp2.format( "%.0f", stop_time); 8: m_wnddlgbar.getdlgitem(idc_statictime2)->setwindowtext((lpctstr)tmp2); 9: 10: double dif_time; 11: dif_time = stop_time - start_time; 12: CString tmp3; 13: tmp3.format( "%.0f", dif_time); 14: m_wnddlgbar.getdlgitem(idc_statictime3)->setwindowtext((lpctstr)tmp3); 15:} 5 GetTickCount stop_time 8 SetWindowText stop_time 11 stop_time - start_time dif_time 14 SetWindowText dif_time WebBrowseView.cpp MainFrm.h CHtmlView CHtmlView::Navigate2 URL 19

20 CHtmlView::OnBeforeNavigate2 Web CHtmlView::OnDocumentComplete READYSTATE_COMPLETE URL Web 20

21 Web Web Web Web C: Documents and Settings Local Settings Temporary Internet Files 21

22 4 4.1 Web CPU Pentium3 733MHz Memory 256M LAN Intel 8255x-based PCI Ethernet Adapter (10/100) OS Windows2000 Server DBMS PostgreSQL native Compiler Java 2 SDK Standard Edition Version 1.4.0_01 Servlet Container Tomcat CPU Celeron 1.3GHz Memory 512M LAN Sis 900-Based PCI Fast Ethernet Adapter OS Windows XP Web

23 Web PC 2 Web Web Web Web Web 23

24 4.1 DataBase Web DataBase Web Web 4.1 Web 4.1 Web Web Web Web 1 Web HTML <IMG SRC= URL > URL Web 24

25 DataBase Web PC 4.2 PC PC PC PC 25

26 4.1.3 DataBase Web HTML Java PC Web ms HTML Java Web ms HTML Java HTML Web Web Java Java Servlet Web HTML Java Web Web Web 26

27 4.2 DataBase Web DataBase Web DataBase Web Web DataBase 3 Web DataBase Web DataBase Web ms DB PC Web ms DB PC Web DataBase 1 Web DataBase Web

28 4.5 Web ms DB PC DataBase Web Web Web Web SQL PC Web ms DB Web ms DB Web Web customer item orders order_item 4 Web item maker 2 28

29 DataBase customer item orders order_item item maker Web Web DataBase DataBase JOIN SQL Web SQL SELECT i_title, i_subject, oi_num, i_price, i_image FROM (order_item INNER JOIN orders ON order_item.oi_o_id = orders.o_id) INNER JOIN item ON order_item.oi_i_id = item.i_id WHERE orders.o_c_id =? order_item orders item order_item.oi_o_id = orders.o_id order_item.oi_i_id = item.i_id RDBMS JOIN Web ms PC JOIN

30 5 Web Web Web Web DataBase Web DataBase Web DataBase Web SQL SELECT SQL INSERT DELETE UPDATE SELECT DataBase DataBase DataBase LOB 30

31 URL [1] [2] 3 PC UNIX PostgreSQL 2001 [3] MSDN Online Japan 31

FileMaker ODBC and JDBC Guide

FileMaker ODBC and JDBC Guide FileMaker 13 ODBC JDBC 2004-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,