±£´æjava¶ÔÏóµ½Êý¾Ý¿â£¬²¢´ÓÊý¾Ý¿â¶Á³öÉú³ÉÓû§½çÃæ
ÏòÊý¾Ý¿â±£´æ¶ÔÏ󣬲ÉÓÃObjectOutputStreamÏòÊý¾Ý¿âÖ±½ÓдÈë
/**
* Title: AF
* Description: ÏòÊý¾Ý¿âÖÐдÈë¶ÔÏó²âÊÔ³ÌÐò
* Copyright: Copyright 2009 ufgov, Inc.
* Company: ufgov
* ´´½¨Ê±¼ä: 2009-10-29
* @author ÁõÓÀΰ(manlge)
* @version 1.0
*/
public class WriteObjectToBlob {
/*
* ½¨±ísql
* CREATE TABLE "AF"."TABLE2" ("NAME" VARCHAR2(36) NOT NULL, "DATA" BLOB NOT NULL) TABLESPACE "AF"
*/
public static Connection getConnection(String host, int port, String dataBaseName,
String userName, String password) throws Exception {
String url = String.format("jdbc:oracle:thin:@%s:%s:%s", host, port,
dataBaseName);
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, userName, password);
return con;
}
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
*/
public static void main(String[] args) throws Exception {
Connection connection = getConnection("localhost", 1521, "ORCL", "AF", "1");
System.out.println(connection);
connection.setAut
Ïà¹ØÎĵµ£º
javaÖжÑÕ»(stack)ºÍ¶Ñ(heap)
Ò»¡¢¶ÑÕ»(stack)ºÍ¶Ñ(heap)£¿
£¨£±£©ÄÚ´æ·ÖÅäµÄ²ßÂÔ
¡¡¡¡°´ÕÕ±àÒëÔÀíµÄ¹Ûµã,³ÌÐòÔËÐÐʱµÄÄÚ´æ·ÖÅäÓÐÈýÖÖ²ßÂÔ,·Ö±ðÊǾ²Ì¬µÄ,ջʽµÄ,ºÍ¶ÑʽµÄ.
¡¡¾²Ì¬´æ´¢·ÖÅäÊÇÖ¸ÔÚ±àÒëʱ¾ÍÄÜÈ·¶¨Ã¿¸öÊý¾ÝÄ¿±êÔÚÔËÐÐʱ¿ÌµÄ´æ´¢¿Õ¼äÐèÇó,Òò¶øÔÚ±àÒëʱ¾Í¿ÉÒÔ¸øËûÃÇ·ÖÅä¹Ì¶¨µÄÄ ......
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
ѧϰǰÁ˽â
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJDKÊÇSun¹«Ë¾·¢²¼µÄJDK£¬³ýÁËSunÖ®Í⣠......
×î½üÔËÐгÌÐò£¬ÀÏÊÇÓöµ½ÄÚ´æÒç³öµÄÎÊÌ⣬Out of Memory(ϵͳÄÚ´æ²»×ã)µÄÒì³£¡£×Ðϸ²é×ÊÁÏ£¬ºÃºÃѧϰÁËÒ»ÏÂÐéÄâ»úµÄ¼¸Ö»£¬²ÅÖªµÀ£¬ÕâÊÇÒòΪJavaÐéÄâ»úĬÈÏ·ÖÅäµÄÄÚ´æÖ»ÓÐ64M£¬Èç¹ûÓ¦ÓõıȽϴ󣬳¬³öÁË64M£¬JavaÐéÄâ»ú¾Í»áÅ׳öOutOfMemoryError£¬²¢Í£Ö¹ÔËÐС£ËùÒÔ£¬ ......
»¨ÁË´ó°ëÌìµÄʱ¼äÖÕÓÚ½â¾öÁËÎÊÌ⣬ÏÂÃæ·ÖÏíÒ»ÏÂÎҵĹý³Ì£º
ÎÒµÄϵͳ°²×°µÄÊÇjdk6,netbeansºÍMycrosoft SqlServer 2005£¬javaÁ¬½ÓÊý¾Ý¿âÒ»°ãÒª·ÖÁù²¿×ß
1.×¢²áÇý¶¯
2.ÓÃÇý¶¯¹ÜÀíÀà´´½¨Á¬½Ó
3.´´½¨Óï¾ästatement·â×°sql½Å±¾Óï¾ä
4.Ö´ÐÐ
5.´¦Àí·µ»ØµÄ½á¹û
6.¹Ø±ÕÏà¹ØÁ¬½Ó
ÔÚÕâÀïÁ¬½ÓµÄÊÇSqlServer2005£¬ÊôÓÚµÚÈý·½Çý¶¯ ......
×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
1.ÕâÊǰüµÄ´úÂë
create or replace package DB_Oper is
-- Author : LIUBING
-- Created : 2009-10-28 15:01:30
-- Purpose : ²âÊÔOracleµ ......