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

java µ÷ÓÃͨÓô洢¹ý³Ì£¨Sqlserver£©


package com.wfy.system.dao;   
  
import java.sql.CallableStatement;   
import java.sql.Connection;   
import java.sql.ResultSet;   
import java.sql.SQLException;   
import java.sql.Types;   
import java.text.DateFormat;   
import java.text.SimpleDateFormat;   
import java.util.ArrayList;   
import java.util.HashMap;   
import java.util.List;   
import java.util.Map;   
  
import org.springframework.dao.DataAccessException;   
import org.springframework.jdbc.core.ConnectionCallback;   
import org.springframework.jdbc.core.JdbcTemplate;   
  
import com.wfy.util.JDOM;   
  
/**  
*   
* ´æ´¢¹ý³Ìͨ¹ý´ËÀàµ÷Óà  
*   
* @author ½ðöÎ  
*   
*/  
public class DynamicDataProcedureExecuteDAO {   
private Map getSqlServerData(JdbcTemplate jdbcTemplate, final List<?> procedureList){   
   Map returnMap = (Map) jdbcTemplate.execute(new ConnectionCallback(){   
    public Map doInConnection(Connection conn) throws SQLException,   
      DataAccessException {   
     /**  
     * ÓÉÓÚsqlserver¸úoracle µÄµ÷Ó÷½Ê½ÓÐËù²»Í¬£¬ËùÒÔÐèÒª·Ö¿ªµ÷Ó㬵«ÊÇÎÒ¶Ôoracle´æ´¢¹ý³Ì²»ÊìϤ£¬ËùÒÔûÓÐд£¬ÒÔºó»á²¹Éϵġ£  
     * ÎÒµÄͨÓ÷½Ê½Êǽ«´«ÈëÊý¾Ý½øÐзâ×°£¬ÔÙ½«´«³öÊý¾Ý·âװΪmap·µ»Ø¸øÓû§  
     *   
     * List.get(0) Öдæ·ÅµÄÊÇ&n


Ïà¹ØÎĵµ£º

SQLSERVER 2000 convertº¯Êýת»»ÈÕÆÚ¸ñʽ


SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ
2008-01-23 15:47
SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ2008-01-15 15:51SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ
SQL ServerÖÐÎİæµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
ÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄܾ­ ......

½« Session ·ÅÈë SQLServer ±£´æ


        SQLServer ģʽ¾ÍÊÇ£¬°ÑSession ´æ·ÅÔÚ SQL Server Êý¾Ý¿âÀעÒâ²»ÊÇ Oracle £¬¶¯¶¯½ÅÖº¶¼Äܲµ½Ô­ÒòÀ²£©£¬ÏÂÃæ¿ªÊ¼ËµÃ÷Ò»ÏÂÉèÖõľßÌå²½Ö裺
1¡¢   Æô¶¯Ïà¹ØµÄÊý¾Ý¿â·þÎñ£¨Èçͼ£©
ÔËÐÐSQL Server ·þÎñ¹ÜÀíÆ÷ → Æô¶¯ SQL Server £¨×îºÃÉèΪ¿ª»ú×Ô¶¯ÔËÐУ© ......

sqlserverÒÆÖ²ÎªOracle±Ê¼Ç

Oracle±Ê¼Ç
l         ¹ØÓÚTRUNCº¯Êý
   SELECT
   RELATED_ID ,
      DOC_ID ,
      CAT_ID ,
      CAT_CODE ,
      RELEASE_DATE ,
&n ......

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

sqlserver:openrowset / oracle:table/view@dblinkÃû

Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý;  ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ