<%!
Connection DB_Connection() throws ClassNotFoundException, SQLException,Exception
{
  String url = "주소";
  Class.forName("oracle.jdbc.driver.OracleDriver");
  Connection conn=DriverManager.getConnection(url,"아이디","비밀번호");
  return conn;
}
%>

// null값이 있을 경우 공백을 리턴한다.
public static final String parseNull(String str) {
return parseNull( str, "" );
}

public static final String parseNull(String str, String defaultVal) {
String val = null;

if( str == null || str.equals("") || str.equals("null"))
val = defaultVal;
else             
val = str.trim();
return val;
}



/*문서번호 생성*/
public String Random_number(String strn)
{
Random random =new Random();
String str = "";
for(int j = 0; j < 8 ; j++)
{
str = str + random.nextInt();
}
String strs = str.substring(1,9);
return strn+strs;
}

/*CLOB 쓰기 */
public void Bufferwrite(CLOB cl , StringBuffer str) throws SQLException,IOException
{
BufferedWriter writer = new BufferedWriter(cl.getCharacterOutputStream());
writer.write(str.toString());
writer.close();
}


/*CLOB 읽기*/
public String getClobdata(Reader r) throws IOException
{
if(r!=null)
{
char[] buff = new char[512];
int len = -1;
String clobValue;
StringBuffer buffer = new StringBuffer(512);
while( (len = r.read(buff)) != -1)
{
buffer.append(buff, 0, len);
}
clobValue = buffer.toString();
return clobValue;
} else {
return "";
}
}