ÈçºÎ×öÒ»¸öSqlServerµÄ²éѯÆ÷
ÎÒÖ»Ïë×öÒ»¸ö¼òµ¥µÄ¿ÉÒÔ²éѯSqlServerÊý¾Ý¿â±íµÄ¹¦ÄÜ!
˵°×Á˾ÍÊÇÓÃasp.net×öÒ»¸öweb°æµÄ²éѯ·ÖÎöÆ÷
¸Ð¾õ²»ÊǺÜÄÑ
¾ÍÊǰѸ÷ÖÖsqlµÄ²éѯÌõ¼þ¹Ì¶¨ËÀ
È»ºóÁô×ÅtextboxÖ®ÀàµÄ
×÷ΪÄãµÄ²éѯÊý¾Ý
ºÇºÇ.ÍøÉÏÏÂÔØ¹ý...
¼òµ¥µÄÓï·¨·ÖÎöÆ÷ÓÃJSʵÏÖ->Òì²½»Øµ÷¸ø·þÎñÆ÷¶ËÖ´ÐÐ->·µ»ØÒ»¸ö×°ÔØÊý¾ÝµÄ¶ÔÏó±ÈÈçTable->¿Í»§¶ËÊÕµ½ºóÖ±½Ó·ÅÈëÈÝÆ÷ÏÔʾ
·Å¸öÎı¾¿ò£¬ÈÃËû×Ô¼ºÐ´sqlÓï¾ä
´ËÎÊÌâ¹Ø¼üÔÚ ½á¹û¼¯µÄÏÔʾ!ÿ¸ö±íµÄ×ֶβ»Ò»Ñù!Òª¶¯Ì¬ÏÔʾ!
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
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ºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
Ŀǰ·þÎñÆ÷ÎïÀíÄÚ´æÊÇ8G ²Ù×÷ϵͳÊÇÆóÒµ°æ2003ϵͳ£¬ÒѾʹÓÃÁË5GµÄÎïÀíÄڴ棬ÏÖÐéÄâÄÚ´æÉèÖÃÊÇ×îСֵ2G£¬×î´óÖµÊÇ4G
ÆäÖÐÊý¾Ý¿âÄÚ´æÊ¹ÓÃÇé¿öÊÇ1.7G×óÓÒ
·ÖÎö£ºÎïÀíÄڴ泬¹ýÁËÐéÄâÄÚ´æµÄ×î´óÉèÖ÷¶Î§
......