com.shift.framework.model
Class ModelDAO

java.lang.Object
  com.shift.framework.model.ModelDAO

All Implemented Interfaces:

Resource

public class ModelDAO
extends java.lang.Object
implements Resource

DB¿ÍÀÇ ¿¬°áÀ» ´ã´çÇÏ´Â ÀÏÀ» °¡Áø °´Ã¼

Since:

2007.01.10

Version:

1.0

Author:

Shift Information & Communication

Constructor Summary

ModelDAO(java.sql.Connection conn)
DB¿ÍÀÇ ¿¬°áÀ» ´ã´çÇÏ´Â ÀÏÀ» °¡Áø °´Ã¼¸¦ »ý¼ºÇÑ´Ù.

Method Summary

void	call(java.util.Map map) ½ºÅä¾î ÇÁ·Î½ÃÀú¸¦ È£ÃâÇÏ´Â ¸Þ¼ÒµåÀÌ´Ù.
boolean	execute() SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
int[]	executeBatch(java.util.List models) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
void	executeQuery(java.util.Map param, ModelSet set) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
void	executeQuery(ModelSet set) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
void	executeQuery(java.lang.Object param, ModelSet set) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
int	executeUpdate(java.util.Map map, Model model) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
int	executeUpdate(Model model) SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå
java.lang.String	getRealPath(java.lang.String path) »ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¸¦ Àý´ë°æ·Î·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå
Resource	getResource() Resource °´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå
java.net.URL	getResource(java.lang.String path) »ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¸¦ URL°´Ã¼·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå
java.io.InputStream	getResourceAsStream(java.lang.String path) »ó´ë°æ·Î·Î ÁöÁ¤µÈ ¸®¼Ò½º¸¦ InputStreamÀ¸·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå
java.util.Set	getResourcePaths(java.lang.String path) »ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¿¡ ÀÖ´Â ¸ðµç ¸®¼Ò½º¸¦ Set°´Ã¼·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå
SqlHelper	getSqlHelper() SqlHelper°´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå
SQLMap	getSqlMap() SQLMap°´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå
java.lang.String[][]	loadCSV(java.io.InputStream is) CSV ÆÄÀÏÀ» Àоî¿À´Â ¸Þ¼Òµå
java.lang.String[][]	loadCSV(java.io.InputStream is, java.lang.String enc) CSV ÆÄÀÏÀ» Àоî¿À´Â ¸Þ¼Òµå
void	setQuery(java.lang.String sql) SQL¹®À» µî·ÏÇÏ´Â ¸Þ¼Òµå

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ModelDAO

public ModelDAO(java.sql.Connection conn)

DB¿ÍÀÇ ¿¬°áÀ» ´ã´çÇÏ´Â ÀÏÀ» °¡Áø °´Ã¼¸¦ »ý¼ºÇÑ´Ù.

Parameters:

conn -

Method Detail

getRealPath

public java.lang.String getRealPath(java.lang.String path)

»ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¸¦ Àý´ë°æ·Î·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå

Specified by:

getRealPath in interface Resource

Parameters:

path - °¡»óÀÇ °æ·Î

Returns:

Àý´ë °æ·Î

Since:

1.0

getResource

public java.net.URL getResource(java.lang.String path)
                         throws java.net.MalformedURLException

»ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¸¦ URL°´Ã¼·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå

Specified by:

getResource in interface Resource

Parameters:

path - path - ÀÚ¿ø¿¡ÀÇ °æ·Î¸¦ ÁöÁ¤ÇÏ´Â ¹®ÀÚ¿­

Returns:

URL °´Ã¼

Throws:

java.net.MalformedURLException - ¿Ã¹Ù¸¥ Çü½ÄÀ¸·Î °æ·Î¸íÀÌ ÁöÁ¤µÇÁö ¾ÊÀº °æ¿ì

Since:

1.0

getResourceAsStream

public java.io.InputStream getResourceAsStream(java.lang.String path)

»ó´ë°æ·Î·Î ÁöÁ¤µÈ ¸®¼Ò½º¸¦ InputStreamÀ¸·Î º¯È¯ÇÏ´Â ¸Þ¼Òµå

Specified by:

getResourceAsStream in interface Resource

Parameters:

path - ÀÚ¿ø¿¡ÀÇ °æ·Î¸¦ ÁöÁ¤ÇÏ´Â ¹®ÀÚ¿­

Returns:

InputStream °´Ã¼

Since:

1.0

getResourcePaths

public java.util.Set getResourcePaths(java.lang.String path)

»ó´ë°æ·Î·Î ÁöÁ¤µÈ À§Ä¡¿¡ ÀÖ´Â ¸ðµç ¸®¼Ò½º¸¦ Set°´Ã¼·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå

Specified by:

getResourcePaths in interface Resource

Parameters:

path - ÀÚ¿ø°úÀÇ Á¶ÇÕ¿¡ »ç¿ëÇÏ´Â °æ·Î·Î '/'·Î ½ÃÀ۵ȴÙ.

Returns:

Set°´Ã¼

Since:

1.0

getResource

public Resource getResource()

Resource °´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå

Returns:

Resource°´Ã¼

Since:

1.0

getSqlHelper

public SqlHelper getSqlHelper()

SqlHelper°´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå

Returns:

SqlHelper °´Ã¼

Since:

1.0

getSqlMap

public SQLMap getSqlMap()

SQLMap°´Ã¼¸¦ ¹ÝȯÇÏ´Â ¸Þ¼Òµå

Returns:

SQLMap °´Ã¼

executeUpdate

public int executeUpdate(Model model)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

model - Model °´Ã¼

Returns:

SQL¹®À» ½ÇÇàÇÑ °á°ú

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

Since:

1.0

executeUpdate

public int executeUpdate(java.util.Map map,
                         Model model)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

map - Map °´Ã¼

model - Model °´Ã¼

Returns:

SQL¹®À» ½ÇÇàÇÑ °á°ú

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

Since:

1.0

executeBatch

public int[] executeBatch(java.util.List models)
                   throws java.sql.SQLException,
                          java.lang.IllegalArgumentException,
                          java.lang.IllegalAccessException,
                          java.lang.reflect.InvocationTargetException

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

models - Model °´Ã¼ List

Returns:

½ÇÇà°á°ú

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

Since:

1.0

executeQuery

public void executeQuery(java.lang.Object param,
                         ModelSet set)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException,
                         java.lang.Exception

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

param - ÆĶó¸ÞŸ °´Ã¼

set - Model °´Ã¼

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

Since:

1.0

executeQuery

public void executeQuery(java.util.Map param,
                         ModelSet set)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException,
                         java.lang.Exception

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

param - ÆĶó¸ÞŸ °´Ã¼

set - Model °´Ã¼

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

Since:

1.0

execute

public boolean execute()
                throws java.sql.SQLException,
                       java.lang.IllegalArgumentException,
                       java.lang.IllegalAccessException,
                       java.lang.reflect.InvocationTargetException,
                       java.lang.Exception

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Returns:

trueÀÌ¸é ¼º°øÀÌ°í falseÀÌ¸é ½ÇÆÐÀÌ´Ù.

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

executeQuery

public void executeQuery(ModelSet set)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException,
                         java.lang.Exception

SQL¹®À» ½ÇÇàÇÏ´Â ¸Þ¼Òµå

Parameters:

set -

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

Since:

1.0

call

public void call(java.util.Map map)
          throws java.sql.SQLException,
                 java.lang.IllegalArgumentException,
                 java.lang.IllegalAccessException,
                 java.lang.reflect.InvocationTargetException,
                 java.lang.Exception

½ºÅä¾î ÇÁ·Î½ÃÀú¸¦ È£ÃâÇÏ´Â ¸Þ¼ÒµåÀÌ´Ù.

Parameters:

map - IN, IN OUT, OUT parameter¸¦ ÀÔ·ÂÇϱâ À§ÇØ »ç¿ëÇÏ´Â °´Ã¼ÀÌ´Ù.

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

setQuery

public void setQuery(java.lang.String sql)
              throws java.lang.Exception

SQL¹®À» µî·ÏÇÏ´Â ¸Þ¼Òµå

Parameters:

sql -

Throws:

java.lang.Exception

Since:

1.0

loadCSV

public java.lang.String[][] loadCSV(java.io.InputStream is)
                             throws java.io.IOException

CSV ÆÄÀÏÀ» Àоî¿À´Â ¸Þ¼Òµå

Parameters:

is -

Returns:

CSVÆÄÀÏÀ» String[][] 2Â÷¿ø ¹è¿­·Î º¯È¯ÇÑ °´Ã¼

Throws:

java.io.IOException

Since:

1.0

loadCSV

public java.lang.String[][] loadCSV(java.io.InputStream is,
                                    java.lang.String enc)
                             throws java.io.IOException

CSV ÆÄÀÏÀ» Àоî¿À´Â ¸Þ¼Òµå

Parameters:

is -

enc -

Returns:

CSVÆÄÀÏÀ» String[][] 2Â÷¿ø ¹è¿­·Î º¯È¯ÇÑ °´Ã¼

Throws:

java.io.IOException

Since:

1.0