untitled

Size: px
Start display at page:

Download "untitled"

Transcription

1 OZ User Data Store Manual

2 OZ User Data Store Manual,,,,, DataAction,, Http Request.. DLL DLL lib launch.cfg. // lib OZUDSSample_Csharp.dll, OZUDSSample_VBNET.dll lib. // config assembly.properties OZUDSSample_Csharp.dll, OZUDSSample_VBNET.dll. 2 FORCS Co., LTD

3 A Leader of Enterprise e-business Solution ### ### Assembly Properties for OZ local Server.NET. ### handler.filepath=%oz_home%/../assembly/ozdatabasehandler.dll uds_sample_csharp.filepath=%oz_home%/../lib/ozudssample_csharp.dll uds_sample_vbnet.filepath=%oz_home%/../lib/ozudssample_vbnet.dll ODBC AppExample.mdb ODBC. (:ASP.NET) UDS. bin OZUDSSample_Csharp.dll, OZUDSSample_VBNET.dll. bin DLL.NET Framework. ODBC conf db.properties ODBC. AppExample.vendor=odbc AppExample.dsn=AppExample AppExample.user= AppExample.password= AppExample.maxconns=5 AppExample.initconns=2 FORCS Co., LTD 3

4 OZ User Data Store Manual AppExample.timeout=5 Member.vendor=odbc Member.dsn=AppExample Member.user= Member.password= Member.maxconns=5 Member.initconns=2 Member.timeout=5 4 FORCS Co., LTD

5 A Leader of Enterprise e-business Solution UDS UDS DefaultUserDataStore OZUserDataStore RawDataSource Log. UDS DefaultUserDataStore. abstract class OZUserDataReaderStore abstract class OZUserDataTableStore oz.uds.ozuserdatareaderstore namespace oz.uds public abstract class OZUserDataReaderStore protected readonly oz.framework.log.ozlog log; abstract public void Init(); abstract public IDataReader GetDataReader(string command); abstract public void FreeDataReader(IDataReader reader); abstract public void Close(); Init Prototype Definition public void Init(). UDS. GetDataReader Prototype public IDataReader GetDataReader(string command) FORCS Co., LTD 5

6 OZ User Data Store Manual Definition IDataReader. Argument command FreeDataReader Prototype public void FreeDataReader(IDataReader reader) IDataReader. Definition GetDataReader() IDataReader FreeDataReader() IDataReader. Argument reader IDataReader Close Prototype Definition public void Close(). UDS. oz.uds.ozuserdatatablestore namespace oz.uds public abstract class OZUserDataTableStore protected readonly oz.framework.log.ozlog log; abstract public void Init(); abstract public System.Data.DataTable GetDataTable(string command); abstract public void FreeDataTable(DataTable table); abstract public void Close(); Init Prototype Definition public void Init(). UDS. 6 FORCS Co., LTD

7 A Leader of Enterprise e-business Solution GetDataReader Prototype Definition public System.Data.DataTable GetDataReader(string command) DataTable. Argument command DataTable FreeDataReader Prototype Definition public void FreeDataTable(DataTable table) DataTable. GetDataTable() DataTable FreeDataTable() DataTable. Argument table DataTable Close Prototype Definition public void Close(). UDS. UserDataReaderStoreSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class UserDataReaderStoreSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; FORCS Co., LTD 7

8 OZ User Data Store Manual public IDictionary Parameters set _params = value; public override void Init() public override IDataReader GetDataReader(string command) int fieldcount = oz.util.ozstring.parseint(convert.tostring(_params["field_count"]), 5); int rowcount = oz.util.ozstring.parseint(convert.tostring(_params["row_count"]), 5); string[] fieldnames = new string[fieldcount]; for(int i = 0; i < fieldcount; i++) fieldnames[i] = "field" + i; string[,] data = new string[rowcount, fieldcount]; colindex; for(int rowindex = 0; rowindex < rowcount; rowindex++) for(int colindex = 0; colindex < fieldcount; colindex++) data[rowindex, colindex] = "value " + rowindex + ", " + return new ArrayDataReader(fieldNames, data); public override void FreeDataReader(IDataReader reader) if(null!= reader) reader.close(); reader.dispose(); public override void Close() 8 FORCS Co., LTD

9 A Leader of Enterprise e-business Solution UserDataReaderStoreSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class UserDataReaderStoreSample Inherits OZUserDataReaderStore Implements IParameterRef Private _params As IDictionary Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub Init() End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("field_count")), 5) Dim rowcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("row_count")), 5) Dim fieldnames(fieldcount - 1) As String Dim i As Integer For i = 0 To fieldcount - 1 fieldnames(i) = "field" & i Next Dim data(rowcount - 1, fieldcount - 1) As String Dim rowindex, colindex As Integer For rowindex = 0 To rowcount - 1 For colindex = 0 To fieldcount - 1 FORCS Co., LTD 9

10 OZ User Data Store Manual Next Next data(rowindex, colindex) = "value " & rowindex & ", " & colindex Return New ArrayDataReader(fieldNames, data) End Function Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) If (Not reader Is Nothing) Then reader.close() reader.dispose() End If End Sub Public Overrides Sub Close() End Sub End Class UserDataTableStoreSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class UserDataTableStoreSample : OZUserDataTableStore, IParameterRef private IDictionary _params; public IDictionary Parameters set _params = value; public override void Init() public override DataTable GetDataTable(string command) int fieldcount = oz.util.ozstring.parseint(convert.tostring(_params["field_count"]), 5); 10 FORCS Co., LTD

11 A Leader of Enterprise e-business Solution int rowcount = oz.util.ozstring.parseint(convert.tostring(_params["row_count"]), 5); log.debug("start to create DataTable object. "); DataTable table = new DataTable(); for(int i = 0; i < fieldcount; i++) table.columns.add("field" + i); for(int rowindex = 0; rowindex < rowcount; rowindex++) DataRow row = table.newrow(); for(int colindex = 0; colindex < fieldcount; colindex++) row[colindex] = "value " + rowindex + ", " + colindex; table.rows.add(row); return table; public override void FreeDataTable(DataTable table) if(null!= table) table.dispose(); public override void Close() UserDataTableStoreSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class UserDataTableStoreSample Inherits OZUserDataTableStore Implements IParameterRef FORCS Co., LTD 11

12 OZ User Data Store Manual Private _params As IDictionary Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Function GetDataTable(ByVal command As String) As DataTable Dim fieldcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("field_count")), 5) Dim rowcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("row_count")), 5) log.debug("start to create DataTable object. ") Dim table As New DataTable Dim i As Integer For i = 0 To fieldcount table.columns.add("field" & i) Next Dim rowindex, colindex As Integer For rowindex = 0 To rowcount Dim row As DataRow = table.newrow() For colindex = 0 To fieldcount row.item(colindex) = "value " & rowindex & ", " & colindex Next table.rows.add(row) Next Return table End Function Public Overrides Sub FreeDataTable(ByVal table As DataTable) If (Not table Is Nothing) Then table.dispose() End If End Sub 12 FORCS Co., LTD

13 A Leader of Enterprise e-business Solution Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class UDS. ODI ( ).. FORCS Co., LTD 13

14 OZ User Data Store Manual (. ) ODI "stores.odi". "stores.odi". "ODI " "stores", " " "DataReaderSample" "DataTableSample". "DataReaderSample" "field1" &. 14 FORCS Co., LTD

15 A Leader of Enterprise e-business Solution. FORCS Co., LTD 15

16 OZ User Data Store Manual Connection UDS UDS DB Connection Pool Connection oz.uds.iconnectionref. oz.uds.iconnectionref public interface IConnectionRef string[] Aliasesget; IDictionary Connectionsset; Aliases Prototype string[] Aliasesget; Definition UDS DB Pool alias Connections Prototype Definition IDictionary Connectionsset; UDS Connection. Aliases, null(vb : Nothing). : Aliasesget; ( Connection DB Pool ) Connectionsset; ( Connection UDS ) Init () IConnectionRef Connection Pool Close(). IConnectionRef Init(), Close(). Init() Connection UDS IConnectionRef 16 FORCS Co., LTD

17 A Leader of Enterprise e-business Solution UDS Connection Connectionsset;. UDS Connectionsset; Init(). ConnectionReferenceSample.cs using System; using System.IO; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; using oz.framework.dac; namespace oz.uds.sample.csharp public class ConnectionReferenceSample : OZUserDataReaderStore, IConnectionRef private IDbConnection _connection; private IDbCommand _command; public override void Init() if(null == _connection) throw new OZUDSException("Cannot find proper connection from oz connection pool."); _command = _connection.createcommand(); public override IDataReader GetDataReader(string command) _command.commandtext = command; return _command.executereader(); public override void FreeDataReader(IDataReader reader) if(null!= reader) FORCS Co., LTD 17

18 OZ User Data Store Manual reader.close(); reader.dispose(); public override void Close() public System.Collections.IDictionary Connections set _connection = (IDbConnection)value["appexample"]; public string[] Aliases get return new string[] "appexample"; ConnectionReferenceSample.vb Imports System.IO Imports System.Web Imports System.Collections Imports oz.uds.dr Imports oz.framework.dac Public Class ConnectionReferenceSample Inherits OZUserDataReaderStore Implements IConnectionRef Private _connection As IDbConnection Private _command As IDbCommand Public Overrides Sub Init() If (_connection Is Nothing) Then Throw New OZUDSException("Cannot find proper connection from oz connection pool.") End If _command = _connection.createcommand() End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader 18 FORCS Co., LTD

19 A Leader of Enterprise e-business Solution _command.commandtext = command Return _command.executereader() End Function Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) If (Not reader Is Nothing) Then reader.close() reader.dispose() End If End Sub Public Overrides Sub Close() End Sub Public ReadOnly Property Aliases() As String() Implements IConnectionRef.Aliases Get Return New String() "appexample" End Get End Property Public WriteOnly Property Connections() As System.Collections.IDictionary Implements IConnectionRef.Connections Set(ByVal Value As System.Collections.IDictionary) _connection = DirectCast(Value.Item("appexample"), IDbConnection) End Set End Property End Class Connection UDS. ODI ( ). FORCS Co., LTD 19

20 OZ User Data Store Manual. ( ). ODI "connectionreference.odi". 20 FORCS Co., LTD

21 A Leader of Enterprise e-business Solution "connectionreference.odi". "ODI " "connectionreference", "" "Product".. [] []. "connectionreference.ozr" ODI OZR. Sample.html. FORCS Co., LTD 21

22 OZ User Data Store Manual <HTML> <HEAD> <script src="oz_activex.js"></script> </HEAD> <BODY> <div id="ozembedcontrollocation"> <script id="ztransferx" src="ztransferx.js"></script> <script LANGUAGE="Javascript"> var tag = '<OBJECT id = "ozviewer" CLASSID="CLSID:0DEF32F8-170F-46f8-B1FF-4BF7443F5F25" width="100%" height="100%"></object>'; var paramtag = new Array(); paramtag[paramtag.length] = '<param name="connection.servlet" value=" paramtag[paramtag.length] = '<param name="connection.reportname" value="/connectionreference.ozr">'; oz_activex_build(ozembedcontrollocation, tag, paramtag); </script> </div> </body> </HTML> Sample.html. 22 FORCS Co., LTD

23 A Leader of Enterprise e-business Solution DataAction UDS DataAction oz.uds.idataaction. insert/delete/update/commit String. oz.uds.idataaction namespace oz.uds public interface IDataAction /// <summary> /// insert a row. /// /// it can be implemented as following SQL like logic. /// /// INSERT INTO 'table' (source[0].fieldname, source[1].fieldname,...) /// VALUES(source[0].FieldData, source[1].fielddata,...) /// /// extra arugment can be used to convert spacial types (TO_DATE etc) or /// modify data. /// </summary> /// <param name="command">command string</param> /// <param name="source">source field data</param> /// <param name="extra"> extra argument if needs.</param> /// <param name="parameters">field names and values of parameter and master set</param> /// <returns>number of inserted rows. (always 1 if normal)</returns> string InsertRow(string command, OZDACData[] source, string extra, Hashtable parameters); /// <summary> /// delete row(s). /// /// it can be implemented as following SQL like logic. /// /// DELETE FROM 'table' WHERE condition[0].fieldname = condition[0].fielddata FORCS Co., LTD 23

24 OZ User Data Store Manual /// AND condition[1].fieldname = condition[1].fielddata /// AND... /// AND extra condition /// </summary> /// <param name="command">command string</param> /// <param name="condition">condition field data</param> /// <param name="extra">extra condition if needs.</param> /// <param name="parameters">field names and values of parameter and master set</param> /// <returns>number of deleted rows.</returns> string DeleteRow(string command, OZDACData[] condition, string extra, Hashtable parameters); /// <summary> /// it can be implemented as following SQL like logic. /// /// UPDATE 'table' SET source[0].fieldname = source[0].fielddata, /// source[1].fieldname = source[1].fielddata, ///... /// WHERE condition[0].fieldname = condition[0].fielddata /// AND condition[1].fieldname = condition[1].fielddata /// AND... /// AND ext /// extra arugment can be used to convert spacial types (TO_DATE etc) or /// modify data. /// </summary> /// <param name="command">command string</param> /// <param name="condition">target field data</param> /// <param name="source">source field data</param> /// <param name="extra">extra argument if needs.</param> /// <param name="parameters">field names and values of parameter and master set</param> /// <returns>number of updated rows.</returns> string UpdateRow(string command, OZDACData[] condition, OZDACData[] source, string extra, Hashtable parameters); /// <summary> /// commit all data actions /// called after all data action transactions are successfully completed. /// </summary> /// <returns>commit result message</returns> string Commit(); 24 FORCS Co., LTD

25 A Leader of Enterprise e-business Solution /// <summary> /// rollback all data actions /// called if exception occured while doing data actions. /// </summary> void Rollback(); InsertRow Prototype Definition string InsertRow(string command, OZDACData[] source, string extra, Hashtable parameters);. Argument command source extra parameters (<string datasetname, IDictionary parameters> ) DeleteRow Prototype Definition string DeleteRow(string command, OZDACData[] condition, string extra, Hashtable parameters);. Argument command condition extra parameters (<string datasetname, IDictionary parameters> ) UpdateRow Prototype Definition string UpdateRow(string command, OZDACData[] condition, OZDACData[] source, string extra, Hashtable parameters);. Argument command condition source FORCS Co., LTD 25

26 OZ User Data Store Manual extra parameters (<string datasetname, IDictionary parameters> ) Commit Prototype Definition string Commit();. Rollback Prototype Definition void Rollback();. : Init(). (IDbTransaction.Rollback() IDbTransaction.Commit()) IDbConnection.BeginTransaction() UDS DB,. DataActionSample.cs using System; using System.IO; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; using oz.framework.dac; namespace oz.uds.sample.csharp public class DataActionSample : OZUserDataReaderStore, IConnectionRef, IDataAction private IDbConnection _connection; private IDbCommand _command; 26 FORCS Co., LTD

27 A Leader of Enterprise e-business Solution public override void Init() if(null == _connection) throw new OZUDSException("Cannot find proper connection from oz connection pool."); _command = _connection.createcommand(); _command.transaction = _connection.begintransaction(); public override IDataReader GetDataReader(string command) _command.commandtext = command; return _command.executereader(); public override void FreeDataReader(IDataReader reader) if(null!= reader) reader.close(); reader.dispose(); public override void Close() if(null!= _command.transaction) _command.transaction.rollback(); _command.transaction = null; public System.Collections.IDictionary Connections set _connection = (IDbConnection)value["appexample"]; public string[] Aliases get return new string[] "appexample"; private void makestring(textwriter writer, IDictionary parameters) foreach(dictionaryentry entry in parameters) FORCS Co., LTD 27

28 OZ User Data Store Manual string mastersetname = (string) entry.key; IDictionary masterfields = (IDictionary)entry.Value; writer.writeline("master set; " + mastersetname); "]"); foreach(dictionaryentry masterfield in masterfields) writer.write("[" + masterfield.key + ":" + masterfield.value + public string InsertRow(string command, OZDACData[] source, string extraargument, Hashtable parameters) StringWriter writer = new StringWriter(); writer.writeline("testing data action - InsertRow "); writer.writeline("command : " + command); foreach(ozdacdata field in source) writer.writeline("source field " + field.fieldname + " : " + field.fielddata); writer.writeline("extra argument : " + extraargument); makestring(writer, parameters); writer.writeline(" "); log.debug(writer.tostring()); _command.commandtext = command; return "Insert : " + _command.executenonquery(); public string DeleteRow(string command, OZDACData[] destination, string extraargument, Hashtable parameters) StringWriter writer = new StringWriter(); writer.writeline("testing data action - DeleteRow "); writer.writeline("command : " + command); foreach(ozdacdata field in destination) 28 FORCS Co., LTD

29 A Leader of Enterprise e-business Solution writer.writeline("destination field " + field.fieldname + " : " + field.fielddata); writer.writeline("extra argument : " + extraargument); makestring(writer, parameters); writer.writeline(" "); log.debug(writer.tostring()); _command.commandtext = command; return "Delete : " + _command.executenonquery(); public string UpdateRow(string command, OZDACData[] destination, OZDACData[] source, string extraargument, Hashtable parameters) StringWriter writer = new StringWriter(); writer.writeline("testing data action - UpdateRow "); writer.writeline("command : " + command); foreach(ozdacdata field in destination) writer.writeline("destination field " + field.fieldname + " : " + field.fielddata); foreach(ozdacdata field in source) writer.writeline("source field " + field.fieldname + " : " + field.fielddata); writer.writeline("extra argument : " + extraargument); makestring(writer, parameters); writer.writeline(" "); log.debug(writer.tostring()); _command.commandtext = command; return "Update : " + _command.executenonquery(); public void Rollback() if(null!= _command.transaction) FORCS Co., LTD 29

30 OZ User Data Store Manual _command.transaction.rollback(); _command.transaction = null; public string Commit() if(null!= _command.transaction) _command.transaction.commit(); _command.transaction = null; return "Commit"; DataActionSample.vb Imports System.IO Imports System.Web Imports System.Collections Imports oz.uds.dr Imports oz.framework.dac Public Class DataActionSample Inherits OZUserDataReaderStore Implements IDataAction, IConnectionRef Private _connection As IDbConnection Private _command As IDbCommand Public Overrides Sub Init() If (_connection Is Nothing) Then Throw New OZUDSException("Cannot find proper connection from oz connection pool.") End If _command = _connection.createcommand() _command.transaction = _connection.begintransaction() End Sub 30 FORCS Co., LTD

31 A Leader of Enterprise e-business Solution Public Overrides Function GetDataReader(ByVal command As String) As IDataReader _command.commandtext = command Return _command.executereader() End Function Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) If (Not reader Is Nothing) Then reader.close() reader.dispose() End If End Sub Public Overrides Sub Close() If (Not _command.transaction Is Nothing) Then _command.transaction.rollback() _command.transaction = Nothing End If End Sub Public ReadOnly Property Aliases() As String() Implements IConnectionRef.Aliases Get Return New String() "appexample" End Get End Property Public WriteOnly Property Connections() As System.Collections.IDictionary Implements IConnectionRef.Connections Set(ByVal Value As System.Collections.IDictionary) _connection = DirectCast(Value.Item("appexample"), IDbConnection) End Set End Property Private Sub makestring(byval writer As TextWriter, ByVal parameters As IDictionary) Dim entry As DictionaryEntry For Each entry In parameters Dim mastersetname As String = CStr(entry.Key) Dim masterfields As IDictionary = DirectCast(entry.Value, IDictionary) writer.writeline(("master set; " & mastersetname)) Dim masterfield As DictionaryEntry For Each masterfield In masterfields FORCS Co., LTD 31

32 OZ User Data Store Manual writer.write(string.concat(new Object() "[", masterfield.key, ":", masterfield.value, "]")) Next Next End Sub Public Function InsertRow(ByVal command As String, ByVal source() As OZDACData, ByVal extraargument As String, ByVal parameters As Hashtable) As String Implements IDataAction.InsertRow Dim writer As New StringWriter writer.writeline("testing data action - InsertRow ") writer.writeline(("command : " & command)) Dim field As OZDACData For Each field In source writer.writeline("source field " & field.fieldname, " : " & field.fielddata) Next writer.writeline(("extra argument : " & extraargument)) makestring(writer, parameters) writer.writeline(" ") log.debug(writer.tostring) _command.commandtext = command Return ("Insert : " & _command.executenonquery) End Function Public Function UpdateRow(ByVal command As String, ByVal destination() As OZDACData, ByVal source() As OZDACData, ByVal extraargument As String, ByVal parameters As Hashtable) As String Implements IDataAction.UpdateRow Dim writer As New StringWriter writer.writeline("testing data action - UpdateRow ") writer.writeline(("command : " & command)) Dim field As OZDACData For Each field In destination writer.writeline("destination field " & field.fieldname & " : " & field.fielddata) Next 32 FORCS Co., LTD

33 A Leader of Enterprise e-business Solution For Each field In source writer.writeline("source field " & field.fieldname & " : " & field.fielddata) Next writer.writeline(("extra argument : " & extraargument)) makestring(writer, parameters) writer.writeline(" ") log.debug(writer.tostring) _command.commandtext = command Return ("Update : " & _command.executenonquery) End Function Public Function DeleteRow(ByVal command As String, ByVal destination() As OZDACData, ByVal extraargument As String, ByVal parameters As Hashtable) As String Implements IDataAction.DeleteRow Dim writer As New StringWriter writer.writeline("testing data action - DeleteRow ") writer.writeline(("command : " & command)) Dim field As OZDACData For Each field In destination writer.writeline("destination field " & field.fieldname & " : " & field.fielddata) Next writer.writeline(("extra argument : " & extraargument)) makestring(writer, parameters) writer.writeline(" ") log.debug(writer.tostring) _command.commandtext = command Return ("Delete : " & _command.executenonquery) End Function Public Sub Rollback() Implements IDataAction.Rollback If (Not _command.transaction Is Nothing) Then _command.transaction.rollback() _command.transaction = Nothing FORCS Co., LTD 33

34 OZ User Data Store Manual End If End Sub Public Function Commit() As String Implements IDataAction.Commit If (Not _command.transaction Is Nothing) Then _command.transaction.commit() _command.transaction = Nothing End If Return "Commit" End Function End Class,,. ODI ( ).. 34 FORCS Co., LTD

35 A Leader of Enterprise e-business Solution ( )... (. ) FORCS Co., LTD 35

36 OZ User Data Store Manual []. MASTER DETAIL - DETAIL "" "MASTER". 36 FORCS Co., LTD

37 A Leader of Enterprise e-business Solution,,. INSERT INTO ECustomer ( #@ARG_SF1#, #@ARG_SF2#, #@ARG_SF3#, #@ARG_SF4#, #@ARG_SF5#, #@ARG_SF6#, #@ARG_SF7#, country ) VALUES ( #@ARG_SV1#, '#@ARG_SV2#', '#@ARG_SV3#', '#@ARG_SV4#', '#@ARG_SV5#', '#@ARG_SV6#', '#@ARG_SV7#', '#MASTER.country#' ) DELETE FROM ECustomer WHERE #@ARG_DF1# = #@ARG_DV1# and country = '#MASTER.country#' UPDATE ECustomer SET #@ARG_SF2# = '#@ARG_SV2#', #@ARG_SF3# = '#@ARG_SV3#', #@ARG_SF4# = '#@ARG_SV4#', #@ARG_SF5# = '#@ARG_SV5#', #@ARG_SF6# = '#@ARG_SV6#', #@ARG_SF7# = '#@ARG_SV7#' WHERE #@ARG_DF1# = #@ARG_DV1# and country = '#MASTER.country#' ODI. "dataaction.odi". "dataaction.odi". FORCS Co., LTD 37

38 OZ User Data Store Manual Board "ODIKey" "dataaction", "DataSet" "MASTER", "Field" "country", "FireRowCursorChange" "True". Board "AllowInsert", "AllowDelete", "AllowUpdate" "True", "CellSelectionMode" "Single", "ODIKey" " dataaction ", "DataSet" "DETAIL". "#OZDeleteFlag#" "ColumnEditable" "True". Board OnClick DataAction. var Result = Table1.CommitQueuedActions(); _MessageBox(Result); 38 FORCS Co., LTD

39 A Leader of Enterprise e-business Solution Table1.GetDataSet().RefreshDataSet();,,. DataAction [] [] (. ) FORCS Co., LTD 39

40 OZ User Data Store Manual. Delete,. [Commit DataAction] DataAction DataAction. 40 FORCS Co., LTD

41 A Leader of Enterprise e-business Solution UDS. oz.uds.iparameterref. oz.uds.iparameterref Parametersset;, System.Collection.IDictionary. oz.uds.iparameterref using System.Collection; namespace oz.uds public interface IParameterRef IDictionary Parametersset; Parametersset; Prototype Definition System.Collection.IDictionary Parametersset; Value value ParameterReferenceSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class ParameterReferenceSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef FORCS Co., LTD 41

42 OZ User Data Store Manual private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; public override void Init() public override IDataReader GetDataReader(string command) ArrayList fieldnames = new ArrayList(); ArrayList fieldvalues = new ArrayList(); fieldnames.add("key"); fieldnames.add("value"); foreach(dictionaryentry entry in _params) fieldvalues.add(arraylist.adapter(new entry.value)); object[]entry.key, fieldvalues.add(arraylist.adapter(new object[]"command", command)); return new ArrayListDataReader(fieldNames, fieldvalues); public override void FreeDataReader(IDataReader idr) public override void Close() ParameterReferenceSample.vb Imports System.Web 42 FORCS Co., LTD

43 A Leader of Enterprise e-business Solution Imports System.Collections Imports oz.uds.dr Public Class ParameterReferenceSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub FreeDataReader(ByVal idr As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldnames As New ArrayList Dim fieldvalues As New ArrayList fieldnames.add("key") fieldnames.add("value") Dim entry As DictionaryEntry For Each entry In _params fieldvalues.add(arraylist.adapter(new Object() entry.key, entry.value)) Next fieldvalues.add(arraylist.adapter(new Object() "command", command)) FORCS Co., LTD 43

44 OZ User Data Store Manual Return New ArrayListDataReader(fieldNames, fieldvalues) End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class ParameterReference. ODI [ ]. "Parameter_City" "Parameter_Gender", "Canada" "F". 44 FORCS Co., LTD

45 A Leader of Enterprise e-business Solution ( ).. FORCS Co., LTD 45

46 OZ User Data Store Manual select * from ECustomer where city = "#OZParam.City#" and gender = "#OZParam.Gender#" (. ), ODI. "class3_1.odi". "class3_1.odi". "ODI " "class3_1", "" "SET_1". "SET_1" "KEY" "VALUE" &. 46 FORCS Co., LTD

47 A Leader of Enterprise e-business Solution, (command). FORCS Co., LTD 47

48 OZ User Data Store Manual IIS HttpContext UDS HttpContext oz.uds.ihttpcontextref. oz.uds.ihttpcontextref oz.uds.iuserdatastore Init() setservlet() sethttprequest(). oz.uds.ihttpcontextref namespace oz.uds public interface IHttpContextRef HttpContext HttpContextset; HttpContext Prototype Definition HttpContext HttpContextset; UDS HttpContext Argument value Http HttpContextReferenceSample.cs using System; using System.Web; using System.Data; using System.Collections; using System.Collections.Specialized; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class HttpContextReferenceSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef 48 FORCS Co., LTD

49 A Leader of Enterprise e-business Solution private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; public override void Init() public override IDataReader GetDataReader(string command) ArrayList fieldnames = new ArrayList(); ArrayList fieldvalues = new ArrayList(); fieldnames.add("key"); fieldnames.add("value"); if(null!= _ctx) = _ctx.request.params; foreach(string key log.debug(key); object[]key, if(0 == fieldnames.count) return new NullDataReader(); else return new ArrayListDataReader(fieldNames, fieldvalues); public override void FreeDataReader(IDataReader idr) public override void Close() FORCS Co., LTD 49

50 OZ User Data Store Manual HttpContextReferenceSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class HttpContextReferenceSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub FreeDataReader(ByVal idr As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldnames As New ArrayList Dim fieldvalues As New ArrayList fieldnames.add("key") fieldnames.add("value") If (Not _ctx Is Nothing) Then Dim params As System.Collections.Specialized.NameValueCollection = _ctx.request.params Dim key As String For Each key In params.allkeys log.debug(key) 50 FORCS Co., LTD

51 A Leader of Enterprise e-business Solution fieldvalues.add(arraylist.adapter(new Object() key, params.item(key))) Next End If If (fieldnames.count = 0) Then Return New NullDataReader Else Return New ArrayListDataReader(fieldNames, fieldvalues) End If End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class Connection UDS. ODI UDS ( ). FORCS Co., LTD 51

52 OZ User Data Store Manual.. (. ) ODI "class4_1.odi". "class4_1.odi" 52 FORCS Co., LTD

53 A Leader of Enterprise e-business Solution. "ODI " "class4_1", "" "SET_1". "SET_1" "KEY" "VALUE" &.. ODI OZR. asp.net. HTTP Request Key Value "connection.servlet" "?key1=value1&key2=value2&...". asp.net... <param name="connection.servlet" value=" FORCS Co., LTD 53

54 OZ User Data Store Manual 54 FORCS Co., LTD

55 A Leader of Enterprise e-business Solution UDS DataReader. oz.uds.dr.defaultdatareader. DefaultDataReader. abstract public bool Read() abstract public DataTable GetSchemaTable() abstract public object this[string name]get; abstract public object this[int zerobasedindex]get; oz.uds.dr.arraydatareader. Constructor Summary public ArrayDataReader(string[] fieldnames, string[][] data) public ArrayDataReader(string[] fieldnames, string[,] data) public ArrayDataReader(string[] fieldnames, Type [] types, string[][] data) public ArrayDataReader(string[] fieldnames, Type[] types, string[,] data) Constructor Detail Prototype // public ArrayDataReader(string[] fieldnames, string[][]data) public ArrayDataReader(string[] fieldnames, string[,]data) // FORCS Co., LTD 55

56 OZ User Data Store Manual public ArrayDataReader(string[] fieldnames, Type[] types, string[][] data) public ArrayDataReader(string[] fieldnames, Type[] types, string[,] data) fieldnames Argument types data 2 ( ) ArrayDataReaderSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class ArrayDataReaderSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; public override void Init() public override IDataReader GetDataReader(string command) int fieldcount = oz.util.ozstring.parseint(convert.tostring(_params["field_count"]), 5); int rowcount = oz.util.ozstring.parseint(convert.tostring(_params["row_count"]), 5); bool usejaggedarray = oz.util.ozstring.parsebool(convert.tostring(_params["use_jagged_array"]), 56 FORCS Co., LTD

57 A Leader of Enterprise e-business Solution false); string[] fieldnames = new string[fieldcount]; string[][] jagged = null; string[,] rectangular = null; if(usejaggedarray) jagged = new string[rowcount][]; else rectangular = new string[rowcount, fieldcount]; for(int col = 0; col < fieldcount; col++) fieldnames[col] = "Field" + col; for(int row = 0; row < rowcount; row++) if(usejaggedarray) jagged[row] = new string[fieldcount]; for(int col = 0; col < fieldcount; col++) string value = "Value - " + row + "," + col; if(usejaggedarray) jagged[row][col] = value; else rectangular[row,col] = value; if(usejaggedarray) return new ArrayDataReader(fieldNames, jagged); else return new ArrayDataReader(fieldNames, rectangular); public override void FreeDataReader(IDataReader reader) public override void Close() FORCS Co., LTD 57

58 OZ User Data Store Manual ArrayDataReaderSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class ArrayDataReaderSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("field_count")), 5) Dim rowcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("row_count")), 5) Dim usejaggedarray As Boolean = oz.util.ozstring.parsebool(convert.tostring(_params.item("use_jagged_array")), False) log.debug("field count : " & fieldcount) Dim fieldnames(fieldcount - 1) As String 58 FORCS Co., LTD

59 A Leader of Enterprise e-business Solution Dim jagged()() As String Dim rectangular(,) As String If (usejaggedarray) Then jagged = New String(rowCount - 1)() Else rectangular = New String(rowCount - 1, fieldcount - 1) End If Dim col As Integer For col = 0 To fieldcount - 1 fieldnames(col) = "Field" & col Next col Dim row As Integer For row = 0 To rowcount - 1 If (usejaggedarray) Then End If jagged(row) = New String(fieldCount - 1) For col = 0 To fieldcount - 1 Dim value = "Value - " & row & "," & col If (usejaggedarray) Then jagged(row)(col) = value Else rectangular(row, col) = value End If Next col Next row If (usejaggedarray) Then Return New ArrayDataReader(fieldNames, jagged) Else Return New ArrayDataReader(fieldNames, rectangular) End If End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub FORCS Co., LTD 59

60 OZ User Data Store Manual End Class oz.uds.dr.dynamicdatareader. Constructor Summary public DynamicDataReader(IDataReader reader) Constructor Detail Prototype public DynamicDataReader(IDataReader reader) Argument reader ResultSet DynamicDataReaderSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class DynamicDataReaderSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; public override void Init() 60 FORCS Co., LTD

61 A Leader of Enterprise e-business Solution public override IDataReader GetDataReader(string command) int fieldcount = oz.util.ozstring.parseint(convert.tostring(_params["field_count"]), 5); int rowcount = oz.util.ozstring.parseint(convert.tostring(_params["row_count"]), 5); field count. "); if(fieldcount > 100) throw new ArgumentOutOfRangeException("field_count", "Too big ArrayList fieldnames = new ArrayList(); ArrayList data = new ArrayList(); for(int col = 0; col < fieldcount; col++) fieldnames.add("field" + col); for(int row = 0; row < rowcount; row++) ArrayList rowvalues = new ArrayList(); for(int col = 0; col < fieldcount; col++) rowvalues.add("value - " + row + "," + col); data.add(rowvalues); data)); return new DynamicDataReader(new ArrayListDataReader(fieldNames, public override void FreeDataReader(IDataReader reader) public override void Close() FORCS Co., LTD 61

62 OZ User Data Store Manual DynamicDataReaderSample.vb Imports System.Web Imports System.Collections Public Class DynamicDataReaderSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("field_count")), 5) Dim rowcount As Integer = oz.util.ozstring.parseint(convert.tostring(_params.item("row_count")), 5) If (fieldcount > 100) Then Throw New ArgumentOutOfRangeException("field_count", "Too big field count. ") End If Dim fieldnames As New ArrayList 62 FORCS Co., LTD

63 A Leader of Enterprise e-business Solution Dim data As New ArrayList Dim col As Integer For col = 0 To fieldcount - 1 fieldnames.add(("field" & col)) Next col Dim row As Integer For row = 0 To rowcount - 1 Dim rowvalues As New ArrayList For col = 0 To fieldcount - 1 rowvalues.add("value - " & row & "," & col) Next col data.add(rowvalues) Next row Return New oz.uds.dr.dynamicdatareader(new oz.uds.dr.arraylistdatareader(fieldnames, data)) End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class oz.uds.dr.arraylistdatareader ArrayList. Constructor Summary public ArrayListDataReader(ArrayList fieldnames, ArrayList data) public ArrayListDataReader(ArrayList fieldnames, ArrayList[] data) public ArrayListDataReader(ArrayList fieldnames, ArrayList datatypes, ArrayList data) FORCS Co., LTD 63

64 OZ User Data Store Manual public ArrayListDataReader(ArrayList fieldnames, ArrayList datatypes, ArrayList[] data) Constructor Detail Prototype Definition // VARCHAR public ArrayListDataReader(ArrayList fieldnames, ArrayList data) public ArrayListDataReader(ArrayList fieldnames, ArrayList[] data) // VARCHAR public ArrayListDataReader(ArrayList fieldnames, ArrayList datatypes, ArrayList data) public ArrayListDataReader(ArrayList fieldnames, ArrayList datatypes, ArrayList[] data) ArrayList. fieldnames Argument fieldtypes ( System.Type ) data ArrayList ArrayList[] ArrayListDataReaderSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class ArrayListDataReaderSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; 64 FORCS Co., LTD

65 A Leader of Enterprise e-business Solution public ArrayListDataReaderSample() public override void Init() public override IDataReader GetDataReader(string command) ArrayList fieldnames = new ArrayList(); fieldnames.add("field1"); fieldnames.add("field2"); ArrayList fieldtypes = new ArrayList(); fieldtypes.add(typeof(string)); fieldtypes.add(typeof(int)); int rowcount = oz.util.ozstring.parseint(convert.tostring(_params["row_count"]), 5); if("arraylist".equals(_params["return_type"])) ArrayList data = new ArrayList(); for(int i = 0; i < rowcount; i++) ArrayList row = new ArrayList(); row.add("value" + i); row.add(i); data.add(row); data); return new oz.uds.dr.arraylistdatareader(fieldnames, fieldtypes, else if("arraylist[]".equals(_params["return_type"])) ArrayList[] data = new ArrayList[rowCount]; for(int i = 0; i < rowcount; i++) data[i] = new ArrayList(); data[i].add("value" + i); data[i].add(i); FORCS Co., LTD 65

66 OZ User Data Store Manual data); return new oz.uds.dr.arraylistdatareader(fieldnames, fieldtypes, else log.error("unknown return type. "); return new oz.uds.dr.nulldatareader(); public override void FreeDataReader(IDataReader reader) public override void Close() ArrayListDataReaderSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class ArrayListDataReaderSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters 66 FORCS Co., LTD

67 A Leader of Enterprise e-business Solution Set(ByVal value As IDictionary) Me._params = value End Set End Property Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Dim fieldnames As New ArrayList fieldnames.add("field1") fieldnames.add("field2") Dim fieldtypes As New ArrayList fieldtypes.add(gettype(string)) fieldtypes.add(gettype(int32)) Dim rowcount As Int32 = oz.util.ozstring.parseint(convert.tostring(_params.item("row_count")), 5) If ("ArrayList".Equals(_params.Item("return_type"))) Then Dim data As New ArrayList Dim i As Integer For i = 0 To rowcount - 1 Dim row As New ArrayList row.add(("value" & i)) row.add(i) data.add(row) Next i Return New ArrayListDataReader(fieldNames, fieldtypes, data) ElseIf ("ArrayList[]".Equals(_params.Item("return_type"))) Then Dim data(rowcount) As ArrayList Dim i As Integer For i = 0 To rowcount - 1 data(i) = New ArrayList data(i).add(("value" & i)) data(i).add(i) Next FORCS Co., LTD 67

68 OZ User Data Store Manual Return New ArrayListDataReader(fieldNames, fieldtypes, data) Else log.error("unknown return type. ") Return New oz.uds.dr.nulldatareader End If End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class oz.uds.dr.nulldatareader null. NullDataReaderSample.cs using System; using System.Web; using System.Data; using System.Collections; using oz.uds; using oz.uds.dr; namespace oz.uds.sample.csharp public class NullDataReaderSample : OZUserDataReaderStore, IHttpContextRef, IParameterRef private HttpContext _ctx; private IDictionary _params; public HttpContext HttpContext set _ctx = value; public IDictionary Parameters set _params = value; 68 FORCS Co., LTD

69 A Leader of Enterprise e-business Solution public override void Init() public override IDataReader GetDataReader(string command) return new NullDataReader(); public override void FreeDataReader(IDataReader reader) public override void Close() NullDataReaderSample.vb Imports System.Web Imports System.Collections Imports oz.uds.dr Public Class NullDataReaderSample Inherits OZUserDataReaderStore Implements IHttpContextRef, IParameterRef Private _ctx As System.Web.HttpContext Private _params As IDictionary Public WriteOnly Property HttpContext() As HttpContext Implements IHttpContextRef.HttpContext Set(ByVal value As HttpContext) Me._ctx = value End Set End Property Public WriteOnly Property Parameters() As IDictionary Implements IParameterRef.Parameters Set(ByVal value As IDictionary) Me._params = value FORCS Co., LTD 69

70 OZ User Data Store Manual End Set End Property Public Overrides Sub FreeDataReader(ByVal reader As IDataReader) End Sub Public Overrides Function GetDataReader(ByVal command As String) As IDataReader Return New NullDataReader End Function Public Overrides Sub Init() End Sub Public Overrides Sub Close() End Sub End Class 70 FORCS Co., LTD

untitled

untitled OZ User Data Store Manual... 6 UDS... 6 JDBC UDS... 12 Connection UDS... 17 Connection UDS... 23 DataAction... 31 DataAction... 31 - DataAction... 46... 68 HttpRequest... 76 ResultSet... 83 OZ User Data

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting Started 'OZ

More information

untitled

untitled Push... 2 Push... 4 Push... 5 Push... 13 Push... 15 1 FORCS Co., LTD A Leader of Enterprise e-business Solution Push (Daemon ), Push Push Observer. Push., Observer. Session. Thread Thread. Observer ID.

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Getting Started (ver 5.1) 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Getting

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer

More information

untitled

untitled A Leader of Enterprise e-business Solution FORCS Co., LTD 1 OZ Application Designer Getting Started 2 FORCS Co., LTD A Leader of Enterprise e-business Solution FORCS Co., LTD 3 OZ Application Designer

More information

10.ppt

10.ppt : SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL

More information

untitled

untitled A Leader of Enterprise e-business Solution API... 3 Class Cache... 5 Class ConnectionPool... 9 Class DataBind... 13 Class Log... 16 Class Module... 19 Class Monitor... 24 Class Repository... 27 User Data

More information

untitled

untitled A Leader of Enterprise e-business Solution API... 3 Class Cache... 5 Class ConnectionPool... 9 Class DataBind... 13 Class Log... 16 Class Module... 19 Class Monitor... 25 Class Repository... 28 User Data

More information

13주-14주proc.PDF

13주-14주proc.PDF 12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 2... ( ). ( ). @ vs. logic data method variable behavior attribute method field Flow (Type), ( ) member @ () : C program Method A ( ) Method B ( ) Method C () program : Java, C++, C# data @ Program

More information

Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET

Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET 135-080 679-4 13 02-3430-1200 1 2 11 2 12 2 2 8 21 Connection 8 22 UniSQLConnection 8 23 8 24 / / 9 3 UniSQL 11 31 OID 11 311 11 312 14 313 16 314 17 32 SET 19 321 20 322 23 323 24 33 GLO 26 331 GLO 26

More information

untitled

untitled OZ Framework Manual OZ Framework... 2 POST... 3 DataModule POST... 3 FXDataModule POST Custom... 5 Servlet API (for OZ Java Server)... 12 DataModuleFactory... 12 DataModule... 13 FXDataModule... 19 Servlet

More information

untitled

untitled OZ Framework Manual OZ Framework... 2 POST... 3 DataModule POST... 3 FXDataModule POST Custom... 5 Servlet API (for OZ Java Server)... 12 DataModuleFactory... 12 DataModule... 13 FXDataModule... 19...

More information

@OneToOne(cascade = = "addr_id") private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a

@OneToOne(cascade = = addr_id) private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a 1 대 1 단방향, 주테이블에외래키실습 http://ojcedu.com, http://ojc.asia STS -> Spring Stater Project name : onetoone-1 SQL : JPA, MySQL 선택 http://ojc.asia/bbs/board.php?bo_table=lecspring&wr_id=524 ( 마리아 DB 설치는위 URL

More information

Spring Boot/JDBC JdbcTemplate/CRUD 예제

Spring Boot/JDBC JdbcTemplate/CRUD 예제 Spring Boot/JDBC JdbcTemplate/CRUD 예제 오라클자바커뮤니티 (ojc.asia, ojcedu.com) Spring Boot, Gradle 과오픈소스인 MariaDB 를이용해서 EMP 테이블을만들고 JdbcTemplate, SimpleJdbcTemplate 을이용하여 CRUD 기능을구현해보자. 마리아 DB 설치는다음 URL 에서확인하자.

More information

05-class.key

05-class.key 5 : 2 (method) (public) (private) (interface) 5.1 (Method), (public method) (private method) (constructor), 3 4 5.2 (client). (receiver)., System.out.println("Hello"); (client object) (receiver object)

More information

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Crash Unity SDK... Log & Crash Search. - Unity3D v4.0 ios

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 3 if, if else, if else if, switch case for, while, do while break, continue : System.in, args, JOptionPane for (,, ) @ vs. logic data method variable Data Data Flow (Type), ( ) @ Member field

More information

NoSQL

NoSQL MongoDB Daum Communications NoSQL Using Java Java VM, GC Low Scalability Using C Write speed Auto Sharding High Scalability Using Erlang Read/Update MapReduce R/U MR Cassandra Good Very Good MongoDB Good

More information

Modern Javascript

Modern Javascript ES6 - Arrow Function Class Template String Destructuring Default, Rest, Spread let, const for..of Promises Module System Map, Set * Generator * Symbol * * https://babeljs.io/ Babel is a JavaScript compiler.

More information

thesis

thesis ( Design and Implementation of a Generalized Management Information Repository Service for Network and System Management ) ssp@nile nile.postech.ac..ac.kr DPE Lab. 1997 12 16 GMIRS GMIRS GMIRS prototype

More information

3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT

3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT 3 S Q L A n t i p a t t e r n s Trees/intro/parent.sql CREATE TABLE Comments ( comment_id SERIAL PRIMARY KEY, parent_id BIGINT UNSIGNED, comment TEXT NOT NULL, FOREIGN KEY (parent_id) REFERENCES Comments(comment_id)

More information

신림프로그래머_클린코드.key

신림프로그래머_클린코드.key CLEAN CODE 6 11st Front Dev. Team 6 1. 2. 3. checked exception 4. 5. 6. 11 : 2 4 : java (50%), javascript (35%), SQL/PL-SQL (15%) : Spring, ibatis, Oracle, jquery ? , (, ) ( ) 클린코드를 무시한다면 . 6 1. ,,,!

More information

Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 11 년 10 월 26 일수요일

Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 11 년 10 월 26 일수요일 Eclipse 와 Firefox 를이용한 Javascript 개발 발표자 : 문경대 Introduce Me!!! Job Jeju National University Student Ubuntu Korean Jeju Community Owner E-Mail: ned3y2k@hanmail.net Blog: http://ned3y2k.wo.tc Facebook: http://www.facebook.com/gyeongdae

More information

歯엑셀모델링

歯엑셀모델링 I II II III III I VBA Understanding Excel VBA - 'VB & VBA In a Nutshell' by Paul Lomax, October,1998 To enter code: Tools/Macro/visual basic editor At editor: Insert/Module Type code, then compile by:

More information

09-interface.key

09-interface.key 9 Database insert(record r): boolean find(key k): Record 1 Record getkey(): Key * Record Key Database.? Key equals(key y): boolean Database insert(record r): boolean find(key k): Record * Database OK 1

More information

3ÆÄÆ®-14

3ÆÄÆ®-14 chapter 14 HTTP >>> 535 Part 3 _ 1 L i Sting using System; using System.Net; using System.Text; class DownloadDataTest public static void Main (string[] argv) WebClient wc = new WebClient(); byte[] response

More information

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) 8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop

More information

PART 1 CHAPTER 1 Chapter 1 Note 4 Part 1 5 Chapter 1 AcctNum = Table ("Customer").Cells("AccountNumber") AcctNum = Customer.AccountNumber Note 6 RecordSet RecordSet Part 1 Note 7 Chapter 1 01:

More information

C# Programming Guide - Types

C# Programming Guide - Types C# Programming Guide - Types 최도경 lifeisforu@wemade.com 이문서는 MSDN 의 Types 를요약하고보충한것입니다. http://msdn.microsoft.com/enus/library/ms173104(v=vs.100).aspx Types, Variables, and Values C# 은 type 에민감한언어이다. 모든

More information

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r Jakarta is a Project of the Apache

More information

DocsPin_Korean.pages

DocsPin_Korean.pages Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google

More information

ETL_project_best_practice1.ppt

ETL_project_best_practice1.ppt ETL ETL Data,., Data Warehouse DataData Warehouse ETL tool/system: ETL, ETL Process Data Warehouse Platform Database, Access Method Data Source Data Operational Data Near Real-Time Data Modeling Refresh/Replication

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 4 (Object) (Class) (Instance) (Method) (Constructor) Memory 1 UML 1 @ & 1 (Real World) (Software World) @ &.. () () @ & 2 (Real World) (Software World) OOA/ Modeling Abstraction Instantiation

More information

초보자를 위한 C# 21일 완성

초보자를 위한 C# 21일 완성 C# 21., 21 C#., 2 ~ 3 21. 2 ~ 3 21.,. 1~ 2 (, ), C#.,,.,., 21..,.,,, 3. A..,,.,.. Q&A.. 24 C#,.NET.,.,.,. Visual C# Visual Studio.NET,..,. CD., www. TeachYour sel f CSharp. com., ( )., C#.. C# 1, 1. WEEK

More information

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE ALTIBASE HDB 6.3.1.10.1 Patch Notes 목차 BUG-45710 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG-45730 ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG-45760 ROLLUP/CUBE 절을포함하는질의는 SUBQUERY REMOVAL 변환을수행하지않도록수정합니다....

More information

14-Servlet

14-Servlet JAVA Programming Language Servlet (GenericServlet) HTTP (HttpServlet) 2 (1)? CGI 3 (2) http://jakarta.apache.org JSDK(Java Servlet Development Kit) 4 (3) CGI CGI(Common Gateway Interface) /,,, Client Server

More information

12-file.key

12-file.key 11 (String).. java.lang.stringbuffer. s String s = "abcd"; s = s + "e"; a b c d e a b c d e ,., "910359,, " "910359" " " " " (token) (token),, (delimiter). java.util.stringtokenizer String s = "910359,,

More information

2파트-07

2파트-07 CHAPTER 07 Ajax ( ) (Silverlight) Ajax RIA(Rich Internet Application) Firefox 4 Ajax MVC Ajax ActionResult Ajax jquery Ajax HTML (Partial View) 7 3 GetOrganized Ajax GetOrganized Ajax HTTP POST 154 CHAPTER

More information

ilist.add(new Integer(1))과 같이 사용하지 않고 ilist.add(1)과 같이 사용한 것은 자바 5.0에 추가된 기본 자료형과 해당 객체 자료 형과의 오토박싱/언박싱 기능을 사용한 것으로 오토박싱이란 자바 컴파일러가 객체를 요구하는 곳에 기본 자료형

ilist.add(new Integer(1))과 같이 사용하지 않고 ilist.add(1)과 같이 사용한 것은 자바 5.0에 추가된 기본 자료형과 해당 객체 자료 형과의 오토박싱/언박싱 기능을 사용한 것으로 오토박싱이란 자바 컴파일러가 객체를 요구하는 곳에 기본 자료형 바에 제네릭스(generics)를 도입하기 위한 연구는 이미 8년 전인 1996년부터라고 한다. 실제로 자바에 제네릭스를 도입하 는 몇 가지 방안들이 논문으로 나오기 시작한 것이 1998년 초임을 감 안하면 무려 8년이 지난 후에야 자바 5.0에 전격 채택되었다는 것은 이것이 얼마나 어려운 일이었나 하는 것을 보여준다. 자바의 스펙을 결정하는 표준화 절차인

More information

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration

More information

untitled

untitled - -, (insert) (delete) - - (insert) (delete) (top ) - - (insert) (rear) (delete) (front) A A B top A B C top push(a) push(b) push(c) A B top pop() top A B D push(d) top #define MAX_STACK_SIZE 100 int

More information

MasoJava4_Dongbin.PDF

MasoJava4_Dongbin.PDF JSTORM http://wwwjstormpekr Issued by: < > Revision: Document Information Document title: Document file name: MasoJava4_Dongbindoc Revision number: Issued by: < > SI, dbin@handysoftcokr

More information

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 ALTIBASE HDB 6.5.1.5.10 Patch Notes 목차 BUG-46183 DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG-46249 [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 BUG-46266 [sm]

More information

VS_chapter10

VS_chapter10 Part. Chapter 10 ActiveX Data Objects.NET(ADO.NET).NET, ADO.NET..NET ADO(ActiveX Data Objects). ADO. ADO,. ADO,.NET ADO.NET... ADO.NET ADO Connection DataReader Command DataAdapter DataSet DataView DataSet

More information

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770> i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,

More information

Ext JS À¥¾ÖÇø®ÄÉÀ̼ǰ³¹ß-³¹Àå.PDF

Ext JS À¥¾ÖÇø®ÄÉÀ̼ǰ³¹ß-³¹Àå.PDF CHAPTER 2 (interaction) Ext JS., HTML, onready, MessageBox get.. Ext JS HTML CSS Ext JS.1. Ext JS. Ext.Msg: : Ext Ext.get: DOM 22 CHAPTER 2 (config). Ext JS.... var test = new TestFunction( 'three', 'fixed',

More information

歯sql_tuning2

歯sql_tuning2 SQL Tuning (2) SQL SQL SQL Tuning ROW(1) ROW(2) ROW(n) update ROW(2) at time 1 & Uncommitted update ROW(2) at time 2 SQLDBA> @ UTLLOCKT WAITING_SESSION TYPE MODE_REQUESTED MODE_HELD LOCK_ID1

More information

untitled

untitled PowerBuilder 連 Microsoft SQL Server database PB10.0 PB9.0 若 Microsoft SQL Server 料 database Profile MSS 料 (Microsoft SQL Server database interface) 行了 PB10.0 了 Sybase 不 Microsoft 料 了 SQL Server 料 PB10.0

More information

11 템플릿적용 - Java Program Performance Tuning (김명호기술이사)

11 템플릿적용 - Java Program Performance Tuning (김명호기술이사) Java Program Performance Tuning ( ) n (Primes0) static List primes(int n) { List primes = new ArrayList(n); outer: for (int candidate = 2; n > 0; candidate++) { Iterator iter = primes.iterator(); while

More information

ALTIBASE 사용자가이드 Templete

ALTIBASE 사용자가이드 Templete Real Alternative DBMS ALTIBASE, Since 1999 WINDOWS ADO.NET 환경의 ALTIBASE 개발가이드 2010. 09 Copyright c 2000~2013 ALTBASE Corporation. All Rights Reserved. Document Control Change Record Date Author Change

More information

final_thesis

final_thesis CORBA/SNMP DPNM Lab. POSTECH email : ymkang@postech.ac.kr Motivation CORBA/SNMP CORBA/SNMP 2 Motivation CMIP, SNMP and CORBA high cost, low efficiency, complexity 3 Goal (Information Model) (Operation)

More information

Java XPath API (한글)

Java XPath API (한글) XML : Elliotte Rusty Harold, Adjunct Professor, Polytechnic University 2006 9 04 2006 10 17 문서옵션 제안및의견 XPath Document Object Model (DOM). XML XPath. Java 5 XPath XML - javax.xml.xpath.,? "?"? ".... 4.

More information

초보자를 위한 ADO 21일 완성

초보자를 위한 ADO 21일 완성 ADO 21, 21 Sams Teach Yourself ADO 2.5 in 21 Days., 21., 2 1 ADO., ADO.? ADO 21 (VB, VBA, VB ), ADO. 3 (Week). 1, 2, COM+ 3.. HTML,. 3 (week), ADO. 24 1 - ADO OLE DB SQL, UDA(Universal Data Access) ADO.,,

More information

10주차.key

10주차.key 10, Process synchronization (concurrently) ( ) => critical section ( ) / =>, A, B / Race condition int counter; Process A { counter++; } Process B { counter ;.. } counter++ register1 = counter register1

More information

slide2

slide2 Program P ::= CL CommandList CL ::= C C ; CL Command C ::= L = E while E : CL end print L Expression E ::= N ( E + E ) L &L LefthandSide L ::= I *L Variable I ::= Numeral N ::=

More information

Javascript.pages

Javascript.pages JQuery jquery part1 JavaScript : e-mail:leseraphina@naver.com http://www.webhard.co.kr I.? 2 ......,,. : : html5 ; ; .

More information

Chapter 4. LISTS

Chapter 4. LISTS 연결리스트의응용 류관희 충북대학교 1 체인연산 체인을역순으로만드는 (inverting) 연산 3 개의포인터를적절히이용하여제자리 (in place) 에서문제를해결 typedef struct listnode *listpointer; typedef struct listnode { char data; listpointer link; ; 2 체인연산 체인을역순으로만드는

More information

13ÀåÃß°¡ºÐ

13ÀåÃß°¡ºÐ 13 CHAPTER 13 CHAPTER 2 3 4 5 6 7 06 android:background="#ffffffff"> 07

More information

SIGPLwinterschool2012

SIGPLwinterschool2012 1994 1992 2001 2008 2002 Semantics Engineering with PLT Redex Matthias Felleisen, Robert Bruce Findler and Matthew Flatt 2009 Text David A. Schmidt EXPRESSION E ::= N ( E1 O E2 ) OPERATOR O ::=

More information

chap01_time_complexity.key

chap01_time_complexity.key 1 : (resource),,, 2 (time complexity),,, (worst-case analysis) (average-case analysis) 3 (Asymptotic) n growth rate Θ-, Ο- ( ) 4 : n data, n/2. int sample( int data[], int n ) { int k = n/2 ; return data[k]

More information

구축환경 OS : Windows 7 그외 OS 의경우교재 p26-40 참조 Windows 의다른버전은조금다르게나타날수있음 Browser : Google Chrome 다른브라우저를사용해도별차이없으나추후수업의모든과정은크롬사용 한

구축환경 OS : Windows 7 그외 OS 의경우교재 p26-40 참조 Windows 의다른버전은조금다르게나타날수있음 Browser : Google Chrome 다른브라우저를사용해도별차이없으나추후수업의모든과정은크롬사용   한 수업환경구축 웹데이터베이스구축및실습 구축환경 OS : Windows 7 그외 OS 의경우교재 p26-40 참조 Windows 의다른버전은조금다르게나타날수있음 Browser : Google Chrome 다른브라우저를사용해도별차이없으나추후수업의모든과정은크롬사용 http://chrome.google.com 한림대학교웹데이터베이스 - 이윤환 APM 설치 : AUTOSET6

More information

untitled

untitled FORCS Co., LTD 1 2 FORCS Co., LTD . Publishing Wizard Publishing Wizard Publishing Wizard Publishing Wizard FORCS Co., LTD 3 Publishing Wizard Publidhing Wizard HTML, ASP, JSP. Publishing Wizard [] []

More information

4. #include <stdio.h> #include <stdlib.h> int main() { functiona(); } void functiona() { printf("hihi\n"); } warning: conflicting types for functiona

4. #include <stdio.h> #include <stdlib.h> int main() { functiona(); } void functiona() { printf(hihi\n); } warning: conflicting types for functiona 이름 : 학번 : A. True or False: 각각항목마다 True 인지 False 인지적으세요. 1. (Python:) randint 함수를사용하려면, random 모듈을 import 해야한다. 2. (Python:) '' (single quote) 는한글자를표현할때, (double quote) 는문자열을표현할때사용한다. B. 다음에러를수정하는방법을적으세요.

More information

Microsoft PowerPoint - java1-lab5-ImageProcessorTestOOP.pptx

Microsoft PowerPoint - java1-lab5-ImageProcessorTestOOP.pptx 2018 학년도 1 학기 JAVA 프로그래밍 II 514760-1 2018 년봄학기 5/10/2018 박경신 Lab#1 (ImageTest) Lab#1 은영상파일 (Image) 을읽어서정보를출력 Java Tutorials Lesson: Working with Images https://docs.oracle.com/javase/tutorial/2d/images/index.html

More information

歯MDI.PDF

歯MDI.PDF E08 MDI SDI(Single Document Interface) MDI(Multiple Document Interface) MDI (Client Window) (Child) MDI 1 MDI MDI MDI - File New Other Projects MDI Application - MDI - OK [ 1] MDI MDI MDI MDI Child MDI

More information

교육자료

교육자료 THE SYS4U DODUMENT Java Reflection & Introspection 2012.08.21 김진아사원 2012 SYS4U I&C All rights reserved. 목차 I. 개념 1. Reflection 이란? 2. Introspection 이란? 3. Reflection 과 Introspection 의차이점 II. 실제사용예 1. Instance의생성

More information

Microsoft PowerPoint - 04-UDP Programming.ppt

Microsoft PowerPoint - 04-UDP Programming.ppt Chapter 4. UDP Dongwon Jeong djeong@kunsan.ac.kr http://ist.kunsan.ac.kr/ Dept. of Informatics & Statistics 목차 UDP 1 1 UDP 개념 자바 UDP 프로그램작성 클라이언트와서버모두 DatagramSocket 클래스로생성 상호간통신은 DatagramPacket 클래스를이용하여

More information

(Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory :

(Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory : #2 (RAD STUDIO) In www.devgear.co.kr 2016.05.18 (Humphery Kim) RAD Studio : h=p://tech.devgear.co.kr/ : h=p://blog.hjf.pe.kr/ Facebook : h=p://d.com/hjfactory : hskim@embarcadero.kr 3! 1 - RAD, 2-3 - 4

More information

歯Writing_Enterprise_Applications_2_JunoYoon.PDF

歯Writing_Enterprise_Applications_2_JunoYoon.PDF Writing Enterprise Applications with Java 2 Platform, Enterprise Edition - part2 JSTORM http//wwwjstormpekr Revision Document Information Document title Writing Enterprise Applications

More information

07 자바의 다양한 클래스.key

07 자바의 다양한 클래스.key [ 07 ] . java.lang Object, Math, String, StringBuffer Byte, Short, Integer, Long, Float, Double, Boolean, Character. java.util Random, StringTokenizer Calendar, GregorianCalendar, Date. Collection, List,

More information

untitled

untitled API... 3 Class Cache... 5 Class ConnectionPool... 9 Class DataBind... 13 Class Log... 16 Class Mail... 19 Class Module... 26 Class Monitor... 35 Class Repository... 38 API... 71 Class Program... 73 Class

More information

ch09

ch09 9 Chapter CHAPTER GOALS B I G J A V A 436 CHAPTER CONTENTS 9.1 436 Syntax 9.1 441 Syntax 9.2 442 Common Error 9.1 442 9.2 443 Syntax 9.3 445 Advanced Topic 9.1 445 9.3 446 9.4 448 Syntax 9.4 454 Advanced

More information

02 C h a p t e r Java

02 C h a p t e r Java 02 C h a p t e r Java Bioinformatics in J a va,, 2 1,,,, C++, Python, (Java),,, (http://wwwbiojavaorg),, 13, 3D GUI,,, (Java programming language) (Sun Microsystems) 1995 1990 (green project) TV 22 CHAPTER

More information

11강-힙정렬.ppt

11강-힙정렬.ppt 11 (Heap ort) leejaku@shinbiro.com Topics? Heap Heap Opeations UpHeap/Insert, DownHeap/Extract Binary Tree / Index Heap ort Heap ort 11.1 (Priority Queue) Operations ? Priority Queue? Priority Queue tack

More information

歯처리.PDF

歯처리.PDF E06 (Exception) 1 (Report) : { $I- } { I/O } Assign(InFile, InputName); Reset(InFile); { $I+ } { I/O } if IOResult 0 then { }; (Exception) 2 2 (Settling State) Post OnValidate BeforePost Post Settling

More information

chap10.PDF

chap10.PDF 10 C++ Hello!! C C C++ C++ C++ 2 C++ 1980 Bell Bjarne Stroustrup C++ C C++ C, C++ C C 3 C C++ (prototype) (type checking) C C++ : C++ 4 C C++ (prototype) (type checking) [ 10-1] #include extern

More information

초보자를 위한 ASP.NET 21일 완성

초보자를 위한 ASP.NET 21일 완성 ASP.NET 21!!.! 21 ( day 2 ), Active Server Pages.NET (Web-based program -ming framework).,... ASP.NET. ASP. NET Active Server Pages ( ASP ),. ASP.NET,, ( ),.,.,, ASP.NET.? ASP.NET.. (, ).,. HTML. 24 ASP.

More information

MySQL-Ch10

MySQL-Ch10 10 Chapter.,,.,, MySQL. MySQL mysqld MySQL.,. MySQL. MySQL....,.,..,,.,. UNIX, MySQL. mysqladm mysqlgrp. MySQL 608 MySQL(2/e) Chapter 10 MySQL. 10.1 (,, ). UNIX MySQL, /usr/local/mysql/var, /usr/local/mysql/data,

More information

자바 프로그래밍

자바 프로그래밍 5 (kkman@mail.sangji.ac.kr) (Class), (template) (Object) public, final, abstract [modifier] class ClassName { // // (, ) Class Circle { int radius, color ; int x, y ; float getarea() { return 3.14159

More information

Contents Contents 2 1 Abstract 3 2 Infer Checkers Eradicate Infer....

Contents Contents 2 1 Abstract 3 2 Infer Checkers Eradicate Infer.... SV2016 정적분석보고서 201214262 라가영 201313250 서지혁 June 9, 2016 1 Contents Contents 2 1 Abstract 3 2 Infer 3 2.1 Checkers................................ 3 2.2 Eradicate............................... 3 2.3 Infer..................................

More information

Microsoft PowerPoint - web-part03-ch19-node.js기본.pptx

Microsoft PowerPoint - web-part03-ch19-node.js기본.pptx 과목명: 웹프로그래밍응용 교재: 모던웹을 위한 JavaScript Jquery 입문, 한빛미디어 Part3. Ajax Ch19. node.js 기본 2014년 1학기 Professor Seung-Hoon Choi 19 node.js 기본 이 책에서는 서버 구현 시 node.js 를 사용함 자바스크립트로 서버를 개발 다른서버구현기술 ASP.NET, ASP.NET

More information

OOP 소개

OOP 소개 OOP : @madvirus, : madvirus@madvirus.net : @madvirus : madvirus@madvirus.net ) ) ) 7, 3, JSP 2 ? 3 case R.id.txt_all: switch (menu_type) { case GROUP_ALL: showrecommend("month"); case GROUP_MY: type =

More information

5장.key

5장.key JAVA Programming 1 (inheritance) 2!,!! 4 3 4!!!! 5 public class Person {... public class Student extends Person { // Person Student... public class StudentWorker extends Student { // Student StudentWorker...!

More information

교육2 ? 그림

교육2 ? 그림 Interstage 5 Apworks EJB Application Internet Revision History Edition Date Author Reviewed by Remarks 1 2002/10/11 2 2003/05/19 3 2003/06/18 EJB 4 2003/09/25 Apworks5.1 [ Stateless Session Bean ] ApworksJava,

More information

비긴쿡-자바 00앞부속

비긴쿡-자바 00앞부속 IT COOKBOOK 14 Java P r e f a c e Stay HungryStay Foolish 3D 15 C 3 16 Stay HungryStay Foolish CEO 2005 L e c t u r e S c h e d u l e 1 14 PPT API C A b o u t T h i s B o o k IT CookBook for Beginner Chapter

More information

C프로-3장c03逞풚

C프로-3장c03逞풚 C h a p t e r 03 C++ 3 1 9 4 3 break continue 2 110 if if else if else switch 1 if if if 3 1 1 if 2 2 3 if if 1 2 111 01 #include 02 using namespace std; 03 void main( ) 04 { 05 int x; 06 07

More information

KYO_SCCD.PDF

KYO_SCCD.PDF 1. Servlets. 5 1 Servlet Model. 5 1.1 Http Method : HttpServlet abstract class. 5 1.2 Http Method. 5 1.3 Parameter, Header. 5 1.4 Response 6 1.5 Redirect 6 1.6 Three Web Scopes : Request, Session, Context

More information

untitled

untitled FORCS Co., LTD 1 OZ Query Designer User's Guide 2 FORCS Co., LTD FORCS Co., LTD 3 OZ Query Designer User's Guide 4 FORCS Co., LTD FORCS Co., LTD 5 OZ Query Designer User's Guide UI. (ODI)., ODI. 6 FORCS

More information

목차 INDEX JSON? - JSON 개요 - JSONObject - JSONArray 서울시공공데이터 API 살펴보기 - 요청인자살펴보기 - Result Code - 출력값 HttpClient - HttpHelper 클래스작성 - JSONParser 클래스작성 공공

목차 INDEX JSON? - JSON 개요 - JSONObject - JSONArray 서울시공공데이터 API 살펴보기 - 요청인자살펴보기 - Result Code - 출력값 HttpClient - HttpHelper 클래스작성 - JSONParser 클래스작성 공공 메신저의새로운혁신 채팅로봇 챗봇 (Chatbot) 입문하기 소 이 메 속 : 시엠아이코리아 름 : 임채문 일 : soulgx@naver.com 1 목차 INDEX JSON? - JSON 개요 - JSONObject - JSONArray 서울시공공데이터 API 살펴보기 - 요청인자살펴보기 - Result Code - 출력값 HttpClient - HttpHelper

More information

1

1 1 1....6 1.1...6 2. Java Architecture...7 2.1 2SDK(Software Development Kit)...8 2.2 JRE(Java Runtime Environment)...9 2.3 (Java Virtual Machine, JVM)...10 2.4 JVM...11 2.5 (runtime)jvm...12 2.5.1 2.5.2

More information

Mobile Service > IAP > Android SDK [ ] IAP SDK TOAST SDK. IAP SDK. Android Studio IDE Android SDK Version (API Level 10). Name Reference V

Mobile Service > IAP > Android SDK [ ] IAP SDK TOAST SDK. IAP SDK. Android Studio IDE Android SDK Version (API Level 10). Name Reference V Mobile Service > IAP > Android SDK IAP SDK TOAST SDK. IAP SDK. Android Studio IDE 2.3.3 Android SDK Version 2.3.3 (API Level 10). Name Reference Version License okhttp http://square.github.io/okhttp/ 1.5.4

More information

Microsoft Word - [Unioneinc] 특정컬럼의 통계정보 갱신_ _ldh.doc

Microsoft Word - [Unioneinc] 특정컬럼의 통계정보 갱신_ _ldh.doc 특정 Column 통계정보갱신가이드 유니원아이앤씨 DB 사업부이대혁 2015 년 03 월 02 일 문서정보프로젝트명서브시스템명 버전 1.0 문서명 특정 Column 통계정보갱신가이드 작성일 2015-03-02 작성자 DB사업부이대혁사원 최종수정일 2015-03-02 문서번호 UNIONE-201503021500-LDH 재개정이력 일자내용수정인버전 문서배포이력

More information

JMF2_심빈구.PDF

JMF2_심빈구.PDF JMF JSTORM http://wwwjstormpekr Issued by: < > Document Information Document title: Document file name: Revision number: Issued by: JMF2_ doc Issue Date: Status: < > raica@nownurinet

More information

sms_SQL.hwp

sms_SQL.hwp SMS+LMS 사용설명서 MSSQL + MYSQL (Table 연동방식) Insert 문장만으로귀사의전산시스템과연동하여 대량의문자메시지(SMS) 를저렴하고, 빠르고자동으로발송할수있는 문자메시지전송시스템을개발할수있습니다. 실행파일(exe) 파일을에디터로열어보시고 아이디, 비밀번호가노출되지않는지꼭확인해보시기바랍니다 2008. 11. 1. 발송 Table Table

More information

歯JavaExceptionHandling.PDF

歯JavaExceptionHandling.PDF (2001 3 ) from Yongwoo s Park Java Exception Handling Programming from Yongwoo s Park 1 Java Exception Handling Programming from Yongwoo s Park 2 1 4 11 4 4 try/catch 5 try/catch/finally 9 11 12 13 13

More information

Making a True Business Solution ANNUAL REPORT 2013 I. I. I I II. II. II II II II II II II II II II II II II II II II II III. III III III III III III III III III III III

More information

Contents. 1. PMD ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 2. Metrics ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 3. FindBugs ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 4. ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ

Contents. 1. PMD ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 2. Metrics ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 3. FindBugs ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 4. ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 정적분석서 - 영단어수집왕 - Team.# 3 과목명 소프트웨어모델링및분석 담당교수 유준범교수님 201011320 김용현 팀원 201111360 손준익 201111347 김태호 제출일자 2015-06-09 1 Contents. 1. PMD ㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍㆍ 2. Metrics

More information

JMF3_심빈구.PDF

JMF3_심빈구.PDF JMF JSTORM http://wwwjstormpekr Issued by: < > Revision: Document Information Document title: Document file name: Revision number: Issued by: JMF3_ doc Issue Date:

More information