javaÁ¬½ÓSQL2005µÄÎÊÌâ
ÔÚ΢ÈíÏÂÔØÁËsqljdbc.jarÎļþ£¬·Åµ½ÁËJava\jre1.6.0_06\lib\extĿ¼Ï£¬µ«ÊÇ»¹ÊDz»ÄÜ·ÃÎÊÊý¾Ý¿â£¬ËµÕÒ²»µ½Çý¶¯³ÌÐò
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at test.Hello.getConnection(Hello.java:25)
at test.Hello.displayDbProperties(Hello.java:43)
at test.Hello.main(Hello.java:79)
Error Trace in getConnection() : com.microsoft.jdbc.sqlserver.SQLServerDriver
Error: No active Connection
ÇëÎÊÔõô½â¾ö
Äã°ÑÇý¶¯µ¼Èëµ½ÏîÄ¿ÀïÃæÈ¥¡£¡£¡£
ÔÚ2005ϵ¼Èësqljdbc4.jar¿´°Ñ
End_rbody_60350310//-->
¸Ã»Ø¸´ÓÚ2009-10-12 13:29:59±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÏëʹÓÃLuceneµÄ´úÂ룬·¢ÏÖÒªimportÒ»ÅúÎļþ£º
============
import org.apache.lucene.analysis.standard.StandardAnalyzer;
import org.apache.lucene.document.Document;
¡¡¡¡¡¡
===== ......