Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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(


Ïà¹ØÎÊ´ð£º

java±àÒëÔËÐÐc³ÌÐò£¬²¢ÏÔʾ½á¹û

ͨ¹ýjava³ÌÐò£¬ÏȱàÒëc³ÌÐò£¬Èç³öÏÖ´íÎó£¬ÌáʾC³ÌÐòÖеĴíÎ󣬱àÒë³É¹¦¾ÍÔËÐУ¬ÏÔʾCµÄÔËÐнá¹û£¬×îºÃ°ÑCµÄÔËÐÐʱ¼äºÍÄÚ´æµÈ¶¼ÏÔʾ³öÀ´

¸÷λ´ó¸ç´ó½ã°ï°ï棬СµÜ¸Ð¼¤²»¾¡£¡
ÓÃjavaµÄ½ø³ÌÀàÊÔÊÔ
ÎÒ¸øÄãת ......

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

Ö±½ÓÔÚsqlÓï¾äÖÐд£º
sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... "
È»ºó
Rs.open sql,CONN,3,2
Response.Write Rs.recordcount

µ«ÊÇûÓдò¿ª£¬±¨´í
ADODB.Records ......

java´®¿Ú±à³ÌlinuxÓÐÎÊÌâ¡£¡£

java±àдµÄ´®¿Ú³ÌÐò¡£ÔÚwindows²âÊÔÈ«²¿Í¨¹ý£¬µ«ÊÇÔÚlinuxÏÂÆäËûÊý¾Ý¶¼ÄÜͨ¹ý£¬µ«ÊÇÿµ±Óöµ½int=10µÄʱºò£¬¾Í³öÏÖ¶à·¢Ò»¸ö×Ö½Ú£¬¡£ÎªÊ²Ã´£¿

ÔÚlinuxÀïÃæ jspwin.dll = libjsplux86.so

ÎÒÏÖÔÚÓõÄÊÇcom-linux3 ......

Çó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ºÅ