Oracle Lite Tutorial

Size: px

Start display at page:

Download "Oracle Lite Tutorial"

みりあたもん
5 years ago
Views:

1 !?.NET Oracle -.NET with ODP.NET - Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0

2 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change Log Nov. 30, 2005 Hiroshi Ota Created. Reviewers Name Position Approvals <Approver 1> <Approver 2> Distribution Copy No. Name Location!?.NET Oracle 2

3 !?.NET Oracle Microsoft Visual Studio.NET Oracle10g Tips (Oracle Lite) Oracle Lite!?.NET Oracle.NET!?.NET Oracle Web ASP.NET 3. OO4O(Oracle Objects for OLE) ODP.NET 4. (Oracle Lite)!?.NET Oracle 9 1. Oracle Lite 2. Oracle Lite 3. Mobile Data Workbench !?.NET Oracle 3

4 !?.NET Oracle OS Microsoft Windows 2000 Professional + SP4 RDBMS Oracle Database 10g Release 2 Standard Edition for Windows OS Microsoft Windows 2003 Enterprise Edition OS Microsoft Windows 2000 Professional + SP4 Microsoft Visual Studio.NET 2003 OS Pocket PC 2003!?.NET Oracle 4

5 Oracle Lite Oracle Database Lite 10g( Oracle Lite) (PDA) Oracle Oracle Lite Oracle Database Oracle Lite (= DB ) / DB Oracle Database Oracle Lite Oracle Lite !?.NET Oracle 5

6 Oracle Lite Oracle Lite Oracle Lite Mobile Mobile Mobile DB RDBMS DB!?.NET Oracle 6

7 DB DB Oracle Lite Oracle Lite Mobile Windows 2003 Mobole Pocket PC 2003 Mobile Oracle Mobile Mobile Oracle Oracle Database 10g Enterprise Edition /Standard Edition /Standard Edition One Release Release Oracle9i Database Enterprise Edition/Standard Edition /Standard Edition One Release Mobile Oracle Application Server 10g (9.0.4) Release Release AS Edition Java Edition/Standard Edition/Enterprise Edition Standalone Mobile Oracle Database Lite 10g (10.2.0) Oracle Lite Oracle Technology Network( OTN) Oracle 7

8 Oracle Lite Oracle Lite 1. CD-ROM PC 2. Welcome 3. Oracle Oracle Oracle Oracle 4. Mobile Server!?.NET Oracle 8

9 5. 6. Mobile Server Repository Mobile Oracle!?.NET Oracle 9

10 7. Mobile Mobile Development Kit Mobile Development Kit Mobile Development Kit Oracle Database Lite RDBMS Mobile Mobile Sync Msql!?.NET Oracle 10

11 Oracle Database Lite Mobile Server Mobile Development Kit Mobile Server Mobile Development Kit Mobile Data Workbench (sample.zip) elecgovn data doc elecgovn C# data (table.sql) doc!?.net Oracle 11

12 (manual.doc) Mobile Data Workbench Oracle Database Lite 10g Release 2 Mobile Data Workbench ( MDW) DB SQL MDW MDW MDW 1. MDW Windows Oracle Database Lite 10g Mobile Database Workbench oramdw MDW C: >oramdw 2. MDW (F) (R) (P)!?.NET Oracle 12

13 ELECGOVN C: ELECGOVN Mobile mobileadmin <password> JDBC Thin <hostname> <port> SID <sid>!?.net Oracle 13

14 elecgovn oracle!?.net Oracle 14

15 1. DB DB C: >sqlplus system/<password> SQL*Plus: Release Production on :11: Copyright (c) 1982, 2005, Oracle. All rights reserved. Oracle Database 10g Standard Edition Release Production SQL> CREATE USER elecgovn IDENTIFIED BY oracle; SQL> GRANT connect, resource TO elecgovn; 2. SQL SQL SQL SQL!?.NET Oracle 15

16 DB Oracle Database Oracle Database!?.NET Oracle 16

17 3. SQL SQL SQL OK sample.zip data table.sql!?.net Oracle 17

18 4. MDW OK COMPLAINT_SEQ !?.NET Oracle 18

19 20 CLAIM_SEQ CERTIFICATE_SEQ MDW!?.NET Oracle 19

20 CLAIM_PI ELECGOVN CLAIM!?.NET Oracle 20

21 SQL!?.NET Oracle 21

22 CLAIM CLAIM_PI CERTIFICATE COMPLAINT CERTIFICATE_PI CERTIFICATE COMPLAINT_PI COMPLAINT 2. 3.!?.NET Oracle 22

23 MDW ELECGOVN ELECGOVN CLAIM_PI!?.NET Oracle 23

24 1 CERTIFICATE_PI COMPLIANT_PI CERTIFICATE _PI 2 COMPLIANT _PI 3 CLAIM_SEQ, COMPLIANT_SEQ, CERTIFICATE_SEQ!?.NET Oracle 24

25 OK MDW Mobile PocketPC Mobile Mobile Device Agent 1. Mobile!?.NET Oracle 25

26 URL <server> Mobile Administrator <password>!?.net Oracle 26

27 Mobile ELECGOVN ELECGOVN ORACLE OK!?.NET Oracle 27

28 MDWTEST 2. PocketPC MDW PocketPC Mobile PocketPC MDK ActiveSync ActiveSync Oracle Lite PocketPC OS CPU OK Mobile!?.NET Oracle 28

29 Mobile Oracle DM Oracle Msql Oracle Msync Oracle Update 4 Oracle DM Device Agent Device URL ELECGOVN <password> < >!?.NET Oracle 29

30 MDW!?.NET Oracle 30

31 OK TEST1 ELECGOVN < -CPU>!?.NET Oracle 31

32 MDW!?.NET Oracle 32

33 MDW (T) (P) (C) OK (N)!?.NET Oracle 33

34 OK ELECGOVN /elecgovn Sample Application( ) elecgovn elecgovn!?.net Oracle 34

35 OK URL Administrator <password> /elecgovn!?.net Oracle 35

36 ELECGOVN ELECGOVN ELECGOVN!?.NET Oracle 36

37 ELECGOVN Pocket PC!?.NET Oracle 37

38 elecgovn!?.net Oracle 38

39 OK ELECGOVN sample.zip doc manual.doc Elecgovn!?.NET Oracle 39

40 !?.NET Oracle 40

41 OK!?.NET Oracle 41

42 !?.NET Oracle 42

43 DB DB DB SQL*PLUS SQL!?.NET Oracle 43

44 SELECT complid, custname FROM complaint; SQL DB C: >sqlplus elecgovn/oracle Oracle Database 10g Enterprise Edition Release Production With the OLAP and Data Mining options SQL> SELECT complid, custname FROM complaint; COMPLID CUSTNAME TEST CUSTOMER DB complaint SQL DB SQL> INSERT INTO complaint(complid, custname) VALUES(999,'TEST INSERT'); 1 SQL> commit; DB!?.NET Oracle 44

45 DB!?.NET Oracle 45

46 C# Visual Studio.NET 2003( VS.NET) VS.NET VS.NET PocketPC VS.NET PocketPC WinCE.NET!?.NET Oracle 46

47 Oracle Lite Oracle Lite VS.NET Oracle Lite Oracle Lite 1. VS.NET 2. Oracle Lite PC IP!?.NET Oracle 47

48 PC Oracle Lite!?.NET Oracle 48

49 Oracle Lite Oracle Lite Oracle Lite!?.NET Oracle 49

50 VS.NET VS.NET Oracle Lite Oracle Lite VS.NET VS.NET (P) (R) (B) Oracle.DataAccess.Lite_wce.dll!?.NET Oracle 50

51 (S) Oracle.DataAccess.Lite_wce.dll OK Oracle Lite Oracle Lite using System; using System.Windows.Forms; using Oracle.DataAccess.Lite; namespace ElecGovn { public class ElecGovn { public ElecGovn(){}!?.NET Oracle 51

52 OracleConnection conn; // Oracle Lite public void Connect() { conn=new Oracle.DataAccess.Lite.OracleConnection(); conn.connectionstring = "DSN=elecgovn; uid=system;pwd=oracle"; } conn.open(); Lite using Oracle.DataAccess.Lite; Oracle Lite OracleConnection OracleConnection conn; conn=new Oracle.DataAccess.Lite.OracleConnection(); conn.connectionstring = "DSN=elecgovn; uid=system;pwd=oracle"; conn.open(); Connection ConnectionString ID 3 Open Oracle Lite Lite Close // Lite public void Disconnect() { conn.commit(); conn.close(); conn=null; } Disconnect!?.NET Oracle 52

53 Lite Lite SQL OracleCommand IDbCommand cmd=null; ElecGovn eg=new ElecGovn(); try { eg.connect(); OracleConnection conn=eg.getconnection(); cmd = (OracleCommand)conn.CreateCommand(); cmd.commandtext = "select complaint_seq.nextval from dual"; IDataReader res; res = cmd.executereader(); OracleConnection CreateCommand OracleCommand SQL CommandText cmd.commandtext = "select complaint_seq.nextval from dual"; SQL OracleDataReader OracleDataAdapter cmd.commandtext = "select complaint_seq.nextval from dual"; IDataReader res; res = cmd.executereader(); dba = new OracleDataAdapter(); dba.selectcommand = (OracleCommand)qry; dset = new DataSet();!?.NET Oracle 53

54 dba.fill(dset); SQL Parameter //CLAIM SQL cmd.commandtext = "INSERT INTO CLAIM(CLAIM_ID,CUSTNAME,POLICY_NUMBER," + "ACCIDENT_DATE,DESCRIPTION,VEHICLE_STATUS) values (?,?,?,?,?,?)"; IDataParameter par; // par = cmd.createparameter(); par.dbtype = DbType.Int32; par.direction = ParameterDirection.Input; par.value = nextvalue; cmd.parameters.add(par); BLOB Parameter // OracleBlob blob = new OracleBlob (conn); OpenFileDialog browse=new OpenFileDialog(); browse.filter="image Gif (*.gif) *.gif"; browse.showdialog(); String imagesrc=browse.filename; if((imagesrc==null) (imagesrc.length == 0)) { imagesrc = " My Documents right1up.gif"; } FileStream file = new FileStream(imageSrc,FileMode.Open); byte[] buf = new byte[chunk]; long off = 0; for(;;) {!?.NET Oracle 54

55 int len = file.read(buf, 0, CHUNK); if (len == 0) break; blob.setbytes(off, buf, 0, len); off += len; } file.close(); cmd.parameters.add (new OracleParameter ("Image", blob)); cmd.executenonquery(); BLOB Parameter Oracle Lite OTN Oracle Database Lite 10g - Oracle Database Lite 10g Oracle 55

Oracle Lite Tutorial

Oracle Lite Tutorial GrapeCity -.NET with GrapeCity - SPREAD Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change