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

javaÁ¬½Ósql 2005ÎÊÌâ ÔÚÏߵȡ£¡£¡£¡£


import java.sql.*;

public class Test {
public static void main(String[] srg) {
  String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //¼ÓÔØJDBCÇý¶¯
  String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test";  //Á¬½Ó·þÎñÆ÷ºÍÊý¾Ý¿âtest
  String userName = "sa";  //ĬÈÏÓû§Ãû
  String userPwd = "123";  //°²×°sql server 2005ʱµÄÃÜÂë
  Connection dbConn;

  try {
  Class.forName(driverName);
  dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
  System.out.println("Connection Successful!");  //Èç¹ûÁ¬½Ó³É¹¦ ¿ØÖÆÌ¨Êä³öConnection Successful!
  } catch (Exception e) {
  e.printStackTrace();
  }
}
}
ÉÏÃæÊÇ´úÂë  µ«ÊÇÁ¬½Ó²»ÉÏ  Ìáʾ´íÎó£º
com.microsoft.sqlserver.jdbc.SQLServerException: ÎÞ·¨´ò¿ªµÇ¼ËùÇëÇóµÄÊý¾Ý¿â "test"¡£µÇ¼ʧ°Ü¡£
at com.microsoft.sqlserver.jdbc.SQLServerException.makefromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(


Ïà¹ØÎÊ´ð£º

aspÄÜÖ´Ðж¯Ì¬T-SQLÂð£¿

Ô­Ìû×Ó£ºhttp://topic.csdn.net/u/20090910/12/813a40a2-922d-4f6a-b30b-a16b9a608f81.html?seed=1336087098&r=59699368#r_59699368

ÏÂÃæµÄ´úÂëÓдíÎóÂð£¿sqlÓï¾äÔÚQueryÖÐÊÇ¿ÉÒÔÖ´Ðгö½á¹ûµÄ¡£
Set C ......

ASPµ÷ÓÃSQL´æ´¢¹ý³Ì

¸÷λ´óÏÀ£ºÇëÎÊÔõÑùÔÚASP³ÌÐòÖе÷ÓÃSQL´æ´¢¹ý³Ì£¿Ð»Ð»£¬Çë¸ø¸öÀý×Ó£¡
http://hi.baidu.com/lz0830/blog/item/e847e5e9077fde39b80e2db9.html


1 ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
set con ......

linux£¬winÏÂjava ÔËÐÐËÙ¶ÈÏà²îÈç´ËÖ®´ó£¬¸ßÊÖÖ¸µã

ǰ¶Îʱ¼äд¹ýÒ»¸öСÏîÄ¿Ö÷ÒªÊÇ´¦ÀítarÎļþ½âѹ£¬2½øÖÆÎļþ´¦Àí£¬xmlÎļþ´¦ÀíµÈÒµÎñ£¬winÏÂÅÜ27906ms£¬¶ølinuxÏÂÈ´ÒªÅÜ224818ms¡£Í¬ÑùµÄÒµÎñÈ´Ïà²î8±¶µÄʱ¼ä¡£
¸ßÊÖÖ¸µãÕâ¸öÊÇʲôԭÒò¡£

linuxÏÂÓкܶàÊÇÒª×Ô¼º ......

linuxÏÂjavaµ÷ÓÃC£«£«¿âÖк¯ÊýµÄÎÊÌâ

²»ÖªµÀÊÇʲôԭÒò£¬ÎÒ¸ÃÈçºÎ´¦Àí£¬Çë´óϺÃÇÖ¸½ÌÁË£¬Ð¡µÜÔÚ´Ëл¹ý¡£¡£¡£¡£
´íÎóÐÅÏ¢ÈçÏ£º
The program being debugged was signaled while in a function called from GDB.
GDB has restored the context t ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ