Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶ÁÈ¡oracleÖÐblog×Ö¶Î

 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
 String URL=dbmes.url;
 Connection con = DriverManager.getConnection(URL,dbmes.usrname,dbmes.pwd);
try{
// ×¼±¸Óï¾äÖ´ÐжÔÏó
 String bh=request.getParameter("dwmc");
 Statement stmt = con.createStatement();
 String sql = "select tp1 from HJ_ZDQY_TAB where dwmc='"+bh+"'";
 
 ResultSet rs = stmt.executeQuery(sql);
 if (rs.next()) {
  Blob tp1 = rs.getBlob("tp1");
  long size1 = tp1.length();
  if(size1<=0){
   rs.close();
   response.sendRedirect("../images/error.jpg");
  }else{
   byte[] bs1 = tp1.getBytes(1, (int)size1);
   response.setContentType("image/jpeg");
   response.getOutputStream().write(bs1);
   rs.close();
  }
 }else {
  rs.close();
  response.sendRedirect("../images/error.gif");
 }
}
finally{
  
 con.close();
}
     out.clear();
  out=pageContext.pushBody();


Ïà¹ØÎĵµ£º

½øÈë oracle enterprise managerment ³öÏÖÎÊÌâ

    ÎÊÌâ1£º ½øÈëʱÐèÒªÖ÷»úÉí·ÝÖ¤Ã÷£º ½â¾ö·½°¸£º¹ÜÀí¹¤¾ß——±¾µØ°²È«²ßÂÔ——Óû§È¨ÀûÖ¸ÅÉ——×÷ΪÅú´¦Àí×÷ÒµµÈ¼£¨×îºóÒ»Ï——Ìí¼Ó±¾»úµÄÕ˺ÅÓëÃÜÂë ......

ѧϰOracleÖÐBlobºÍClobÒ»µãµãÐĵÃ

BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾ­ÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......

MyeclipseÖÐÁ¬½ÓOracleµÄ¾­µä´úÂë

 package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
 public static void main(String[] args)
 {
     try{ 
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
     System.out.p ......

Oracle Ðм¶ËøµÄ¿ªÏú

Ê×ÏÈÀ´¸´Ï°Ò»ÏÂÐм¶ËøµÄ»úÖÆ¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼Ê±±ØÑ¡ÏÈÉêÇëÒ»¸öTXËø£¨±£»¤»Ø¹ö¶Î¡¢»Ø¹öÊý¾Ý¿é£©£¬Ö»ÓÐÏÈÉêÇëµ½»Ø¹ö¶Î×ÊÔ´ºó²ÅÄÜ¿ªÊ¼Ò»¸öÊÂÎñ£¬²ÅÄܽøÐÐDML²Ù×÷¡£Õâ¸ö¶¯×÷Íê³Éºó£¬ÊÂÎñ¾Í¿ÉÒÔ¿ªÊ¼ÐÞ¸ÄÊý¾ÝÁË¡£µ±ÐÞ¸ÄÊý¾Ý±íµÄ¼Ç¼ʱ£¬×ñÑ­ÒÔϵIJÙ×÷˳Ðò¡£
1.»ñµÃ±íµÄTMËø£¨±£»¤ÊÂÎñÖ´Ðйý³ÌÖÐÆäËüÓû§²»ÄÜÐ޸ıí½á¹¹£©
2.ÔÚ ......

8¸öDBA×î³£ÓÃµÄ¼à¿ØOracleÊý¾Ý¿âµÄ³£ÓÃshell½Å±¾

±¾ÎĽéÉÜÁË8¸ö³£ÓÃµÄ¼à¿ØÊý¾Ýshell½Å±¾¡£Ê×ÏȻعËÁËһЩDBA³£ÓõÄUnixÃüÁÒÔ¼°½âÊÍÁËÈçºÎͨ¹ýUnix CronÀ´¶¨Ê±Ö´ÐÐDBA½Å±¾¡£ÍøÉÏÒ²ÓкöàÀàËÆµÄÎÄÕ£¬µ«»ù±¾É϶¼²»ÄÜÕý³£ÔËÐУ¬»¨µãʱ¼äÖØÐÂÕûÀíÁËÏ£¬ÒÔºó¾ÍÄÜÖ±½ÓʹÓÃÁË¡£
Ò»£®Í¬Ê±ÎÄÕ»¹½éÉÜÁË8¸öÖØÒªµÄ½Å±¾À´¼à¿ØOracleÊý¾Ý¿â£º
1.¼ì²éʵÀýµÄ¿ÉÓÃÐÔ
2.¼ì²é¼àÌýÆ÷µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ