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

jdbcÓëSQLserverÁ¬½Ó

package com.tongying.www.until;

public class Resource {
// MySQlÊý¾Ý¿âµÄ×ÊÔ´
/* public static final String DRIVER="com.mysql.jdbc.Driver";
public static final String URL="jdbc:mysql://localhost:3306/msg";
public static final String USER="root";
public static final String PASSWORD ="root";
*/
//MSSQL
public static final String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public static final String URL="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=student";
public static final String USER="sa";
public static final String PASSWORD ="sa";


}

package com.tongying.www.test;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import com.tongying.www.until.Resource;

public class Test1 {
  public static void main(String[]args){
  Test1 test=new Test1();
  test.Query();
  }
  //Á¬½ÓÊý¾Ý¿â
  public void Query(){
  Connection conn=null;
  Statement stmte=null;
  ResultSet res=null;
&n


Ïà¹ØÎÊ´ð£º

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

sqlserver count,order by ²éѯÂý

±íÖÐÊý¾Ý 700ÍòÌõ×óÓÒ£¬29¸ö×ֶΣ¬×Ô¶¯Ôö³¤ÁÐÉèΪÖ÷¼ü£¬ ʹÓÃcount£¨1£© ²éѯ×ÜÌõÊýÐèÒª1·ÖÖÓ£¬
select top 1000 ×Ö¶ÎÃû  from ±í order by ʱ¼ä(¸Ã×Ö¶ÎÓÐÖØ¸´ÖµºÍnullÖµ)  ÕâÑùµÄÓï¾ä²éѯ¸üÊÇÂýµÃ»ù± ......

sqlserver¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.

Ö»¸øSELECT ,

UPDATEµÄÖ»¸øÄ³Ð©±í

¸ö²»»á

µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã

Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

  ......

sqlserver 2005»Ö¸´Êý¾ÝµÄÎÊÌâ

×î½üÊý¾Ý¿â±»¸Ä£¬Ï뽫֮»Ö¸´µ½ÉÏÖÜǰµÄÊý¾Ý£¬¿ÉÒÔŪÂð£¿
×Ô¼ºÃ»ÓÐÈ¥±¸·Ý¡£
try:
Log Explorer

http://download.csdn.net/source/620271

ѹËõ°üÀïÓÐÒ»¸ö×¢²á»ú£¬ÓÃÀ´²úÉú×¢²áÂë¡£

´ò¿ªlo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ