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

ÈçºÎ×öÒ»¸öSqlServerµÄ²éѯÆ÷

ÎÒÖ»Ïë×öÒ»¸ö¼òµ¥µÄ¿ÉÒÔ²éѯSqlServerÊý¾Ý¿â±íµÄ¹¦ÄÜ!

˵°×Á˾ÍÊÇÓÃasp.net×öÒ»¸öweb°æµÄ²éѯ·ÖÎöÆ÷



¸Ð¾õ²»ÊǺÜÄÑ
¾ÍÊǰѸ÷ÖÖsqlµÄ²éѯÌõ¼þ¹Ì¶¨ËÀ
È»ºóÁô×ÅtextboxÖ®ÀàµÄ
×÷ΪÄãµÄ²éѯÊý¾Ý

ºÇºÇ.ÍøÉÏÏÂÔØ¹ý...

¼òµ¥µÄÓï·¨·ÖÎöÆ÷ÓÃJSʵÏÖ->Òì²½»Øµ÷¸ø·þÎñÆ÷¶ËÖ´ÐÐ->·µ»ØÒ»¸ö×°ÔØÊý¾ÝµÄ¶ÔÏó±ÈÈçTable->¿Í»§¶ËÊÕµ½ºóÖ±½Ó·ÅÈëÈÝÆ÷ÏÔʾ

·Å¸öÎı¾¿ò£¬ÈÃËû×Ô¼ºÐ´sqlÓï¾ä

´ËÎÊÌâ¹Ø¼üÔÚ ½á¹û¼¯µÄÏÔʾ!ÿ¸ö±íµÄ×ֶβ»Ò»Ñù!Òª¶¯Ì¬ÏÔʾ!


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

sqlserver³ö¹ÊÕÏÁË£¬ÄѵÀÄÚ´æÕæµÄ²»×ãÁËÂ𣿼±

Ŀǰ·þÎñÆ÷ÎïÀíÄÚ´æÊÇ8G ²Ù×÷ϵͳÊÇÆóÒµ°æ2003ϵͳ£¬ÒѾ­Ê¹ÓÃÁË5GµÄÎïÀíÄڴ棬ÏÖÐéÄâÄÚ´æÉèÖÃÊÇ×îСֵ2G£¬×î´óÖµÊÇ4G
ÆäÖÐÊý¾Ý¿âÄÚ´æÊ¹ÓÃÇé¿öÊÇ1.7G×óÓÒ

·ÖÎö£ºÎïÀíÄڴ泬¹ýÁËÐéÄâÄÚ´æµÄ×î´óÉèÖ÷¶Î§
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ