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³ÌÐò£¬Èç³öÏÖ´íÎó£¬ÌáʾC³ÌÐòÖеĴíÎ󣬱àÒë³É¹¦¾ÍÔËÐУ¬ÏÔʾCµÄÔËÐнá¹û£¬×îºÃ°ÑCµÄÔËÐÐʱ¼äºÍÄÚ´æµÈ¶¼ÏÔʾ³öÀ´
¸÷λ´ó¸ç´ó½ã°ï°ï棬СµÜ¸Ð¼¤²»¾¡£¡
ÓÃjavaµÄ½ø³ÌÀàÊÔÊÔ
ÎÒ¸øÄãת ......
Ö±½ÓÔÚsqlÓï¾äÖÐд£º
sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... "
È»ºó
Rs.open sql,CONN,3,2
Response.Write Rs.recordcount
µ«ÊÇûÓдò¿ª£¬±¨´í
ADODB.Records ......
ÈçÌ⣬¾ÍÊǽâ¾öÔÚÒ»¸öwordÄ£°åÖУ¬Ìæ»»Ä³Ð©ÌØÊâÎÄ×Ö£¨Èç°Ñ×Ö·û'title_name'Ìæ»»³É'linuxϵͳϲÙ×÷word'£©£¬µ±È»ÄÜÌæ»»ÊéǩҲ¿ÉÒÔ£¬ÓÉÓÚÔÚlinux·þÎñÆ÷£¬ËùÓв»ÄÜÓÃjacob,»¹Óдø.dllµÄjava2word¶¼²»Ä ......
ÎÒĿǰÔÚ±¾µØµÄlinuxÉÏдÁËÒ»¸öswingµÄ½çÃæ£¬Ïëͨ¹ýÕâ¸ö½çÃæÀ´¿ØÖÆÆäËüµçÄÔµÄlinuxÖØÆô¡£
ÎÒÖªµÀÓÃRuntime.getRuntime().exec("shutdown -r");¿ÉÒÔ¿ØÖƱ¾»úLinuxÖØÆô£¬µ«ÊÇÔõô¿ØÖÆÔ¶³ÌµÄlinuxÖØÆôÄØ£¿ ......
ÏÖÔÚÎÒµÄÇé¿öÊÇÕâÑù£º
ÎÒµÄ ......