¶ÁÈ¡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();
Ïà¹ØÎĵµ£º
DBA Ö°Ôð¼°ÈÕ³£¹¤×÷Ö°Ôð:
1.°²×°ºÍÉý¼¶Êý¾Ý¿â·þÎñÆ÷,ÒÔ¼°Ó¦ÓóÌÐò¹¤¾ß¹¹½¨ºÍÅäÖÃÍøÂç»·¾³.
2.ÊìϤÊý¾Ý¿âϵͳµÄ´æ´¢½á¹¹Ô¤²âδÀ´µÄ´æ´¢ÐèÇó,Öƶ©Êý¾Ý¿âµÄ´æ´¢·½°¸.
3.¸ù¾Ý¿ª·¢ÈËÔ±Éè¼ÆµÄÓ¦ÓÃϵͳÐèÇó´´½¨Êý¾Ý¿â´æ´¢½á¹¹.
4.¸ù¾Ý¿ª·¢ÈËÔ±Éè ......
Ê×ÏÈÀ´¸´Ï°Ò»ÏÂÐм¶ËøµÄ»úÖÆ¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼Ê±±ØÑ¡ÏÈÉêÇëÒ»¸öTXËø£¨±£»¤»Ø¹ö¶Î¡¢»Ø¹öÊý¾Ý¿é£©£¬Ö»ÓÐÏÈÉêÇëµ½»Ø¹ö¶Î×ÊÔ´ºó²ÅÄÜ¿ªÊ¼Ò»¸öÊÂÎñ£¬²ÅÄܽøÐÐDML²Ù×÷¡£Õâ¸ö¶¯×÷Íê³Éºó£¬ÊÂÎñ¾Í¿ÉÒÔ¿ªÊ¼ÐÞ¸ÄÊý¾ÝÁË¡£µ±ÐÞ¸ÄÊý¾Ý±íµÄ¼Ç¼ʱ£¬×ñÑÒÔϵIJÙ×÷˳Ðò¡£
1.»ñµÃ±íµÄTMËø£¨±£»¤ÊÂÎñÖ´Ðйý³ÌÖÐÆäËüÓû§²»ÄÜÐ޸ıí½á¹¹£©
2.ÔÚ ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......