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

JavaÈçºÎ·Àsql×¢Èë

²ÉÓÃÔ¤±àÒëÓï¾ä¼¯£¬ËüÄÚÖÃÁË´¦ÀíSQL×¢ÈëµÄÄÜÁ¦£¬Ö»ÒªÊ¹ÓÃËüµÄsetString·½·¨´«Öµ¼´¿É£º
          String sql= "select * from users where username=? and password=?;
          PreparedStatement preState = conn.prepareStatement(sql);
          preState.setString(1, userName);
          preState.setString(2, password);
          ResultSet rs = preState.executeQuery();


Ïà¹ØÎĵµ£º

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

 declare @XML XML
SET @XML='<root>
 <OLDVALUE>
  <H_Action id="1130">030</H_Action>
  <D_Action>030</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber> ......

JAVAÖÐÓÃÓÚ´¦Àí×Ö·û´®µÄ¡°ÈýÐֵܡ±

JAVAÖÐÓÃÓÚ´¦Àí×Ö·û´®µÄ“ÈýÐֵܔ
JAVAÖÐÓÃÓÚ´¦Àí×Ö·û´®³£ÓõÄÓÐÈý¸öÀࣺjava.lang.String¡¢java.lang.StringBuffer¡¢java.lang.StringBuilder£¬ÕâÈýÕߵĹ²Í¬Ö®´¦¶¼ÊÇfinalÀ࣬²»ÔÊÐí±»¼Ì³Ð£¬ÕâÖ÷ÒªÊÇ´ÓÐÔÄܺͰ²È«ÐÔÉÏ¿¼Âǵģ¬ÒòΪÕ⼸¸öÀà¶¼ÊǾ­³£±»Ê¹ÓÃ×ŵģ¬ÇÒ¿¼Âǵ½·ÀÖ¹ÆäÖеIJÎÊý±»ÐÞ¸ÄÓ°Ïìµ½ÆäËüµÄÓ¦Óᣠ......

JAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ

½üÆÚ£¬ÔÚ¸ø¿Í»§×öÒ»¸öDemoÒ³ÃæÊ±£¬ÐèÒªÓÃJAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ£¬Ôڴ˹ý³ÌÖУ¬Óöµ½Ò»Ð©ÎÊÌ⣬ÀýÈ磺Á¬½ÓOracleÊý¾Ý¿â¶ÁÈ¡blob×Ö¶ÎÊý¾Ý£¬¶ÔͼƬbyteÊý¾Ý½øÐÐËõ·ÅµÈ£»Ìش˼Ǽ£¬¸ø×Ô¼º±¸Íü£¬¸ø´ó¼Ò²Î¿¼¡£
Õû¸öÁ÷³Ì·ÖΪËIJ½£¬Á¬½ÓoracleÊý¾Ý¿â -> ¶ÁÈ¡blobͼƬ×Ö¶Î -> ¶ÔͼƬ½øÐÐËõ·Å ->°ÑͼƬչʾÔÚ ......

[×ªÔØ]Java°²×°ÅäÖã¨linux£©


°²×°java£º
´ò¿ªÖÕ¶Ë£¬Ö´ÐÐÒÔÏÂÃüÁ»òʹÓÃAdept/ÐÂÁ¢µÃÈí¼þ¹ÜÀíÆ÷£¬ÔÚÆäÖзֱðËÑË÷"sun-java6-jre"ºÍ"sun-java6-jdk"²¢±ê¼Ç°²×°¡£
sudo apt-get install sun-java6-jre
Èç¹û¿Õ¼ä¸»Ô££¬½¨Òé°²×°Ò»¸öJDK¡£
sudo apt-get install sun-java6-jdk
Ìáʾ£º°²×°¹ý³ÌÖÐÐèÒªÄã»Ø´ðÊÇ·ñͬÒâʹÓÃЭÒ飨ÖÕ¶ËÖкìÀ¶É«µÄÌáʾ½çÃæ£ ......

Access µÄ SQL µÄ¼Ç¼¼äµÄ¼Ó¼õ¼ÆËã

Access µÄ SQL ÖУ¬¼ÆËãÏàÓ¦±àºÅµÄ¼Ç¼֮¼ä ¼Ó ¼õ µÄ²éѯÃüÁî
ÀýÈç ¼ÆËãIDΪ 6 µÄ ºÏ¼Æ ¼õÈ¥ ID Ϊ 2¡¢3¡¢4 ÒÔ¼°¼ÓÉÏ ID Ϊ 5 µÄºÏ¼Æ
SELECT SUM(R) AS ½á¹û
from
(
  SELECT ºÏ¼Æ  AS R from T1 WHERE (ID = 6) UNION
  SELECT -ºÏ¼Æ AS R from T1 WHERE (ID = 2) UNION
  SELECT -ºÏ¼Æ AS R f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ