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(
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
Ò»¸öÏîĿҪµ÷ÓÃjavaµÄwebservice£¬µ«ÊÇÀÏÊÇÅ׳öÒì³£....
Òì³£:WSS4JInHandler: Request does not contain required Security header
µ÷Ó÷½·¨ÊÇ FindXXXX(header myHeader,params xxx)
ÆäÖÐheaderÖ ......
java±àдµÄ´®¿Ú³ÌÐò¡£ÔÚwindows²âÊÔÈ«²¿Í¨¹ý£¬µ«ÊÇÔÚlinuxÏÂÆäËûÊý¾Ý¶¼ÄÜͨ¹ý£¬µ«ÊÇÿµ±Óöµ½int=10µÄʱºò£¬¾Í³öÏÖ¶à·¢Ò»¸ö×Ö½Ú£¬¡£ÎªÊ²Ã´£¿
ÔÚlinuxÀïÃæ jspwin.dll = libjsplux86.so
ÎÒÏÖÔÚÓõÄÊÇcom-linux3 ......