ɾ³ýSQLServer²éѯ·ÖÎöÆ÷ÖеÄÁ¬½Ó¼Ç¼
SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀï¶¼»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers
¶ÔÓÚ2005ϵÄstudioÈçºÎɾ³ý
ɾ³ýC:\Documents and Settings\{User}\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellϵÄmru.dat
Ïà¹ØÎĵµ£º
ÔÚÊÓͼÉÏ´´½¨Ë÷ÒýµÄÁíÒ»¸öºÃ´¦ÊÇ£º²éѯÓÅ»¯Æ÷¿ªÊ¼ÔÚ²éѯÖÐʹÓÃÊÓͼË÷Òý
£¬
¶ø²»ÊÇÖ±½ÓÔÚ from
×Ó¾äÖÐÃüÁîÊÓͼ¡£ÕâÑùÒ»À´£¬¿É´ÓË÷ÒýÊÓͼ¼ìË÷Êý¾Ý¶øÎÞÐèÖØÐ±àÂ룬ÓÉ´Ë´øÀ´µÄ¸ßЧÂÊҲʹÏÖÓвéѯ»ñÒæ¡£ÔÚÊÓͼÉÏ´´½¨µÄµÚÒ»¸öË÷Òý±ØÐëÊÇΨһ¾Û¼¯Ë÷Òý¡£ÔÚ´´
½¨Î¨Ò»¾Û¼¯Ë÷Òýºó£¬¿É´´½¨ÆäËü·Ç¾Û¼¯Ë÷Òý¡£ÊÓͼÉϵÄË÷ÒýÃüÃû¹æÔòÓë± ......
ÔÚʹÓÃÊý¾Ý¿âµÄ¹ý³ÌÖУ¬¾³£»áÓöµ½Êý¾Ý¿âÇ¨ÒÆ»òÕßÊý¾ÝÇ¨ÒÆµÄÎÊÌ⣬»òÕßÓÐͻȻµÄÊý¾Ý¿âË𻵣¬ÕâʱÐèÒª´ÓÊý¾Ý¿âµÄ±¸·ÝÖÐÖ±½Ó»Ö¸´¡£µ«ÊÇ£¬´Ëʱ»á³öÏÖÎÊÌ⣬ÕâÀï˵Ã÷¼¸ÖÖ³£¼ûÎÊÌâµÄ½â¾ö·½·¨¡£
¹ÂÁ¢Óû§µÄÎÊÌâ
±ÈÈ磬ÒÔǰµÄÊý¾Ý¿âµÄºÜ¶à ......
package com.test.util;
import java.sql.*;
public class ConnectDB {
private Connection conn=null;
private PreparedStatement pt=null;
private ResultSet rs=null;
private String uname="sa";
private String upwd="sa";
private String url="jdbc:microsoft:sqlserv ......