±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1147  |  »Ø¸´: 5

ÎÒ°®Ð¡³æ×Ó

гæ (ÕýʽдÊÖ)

[ÇóÖú] eclipeÁ¬½ÓSQL server2005µÄ´óÄÑÌâ ÒÑÓÐ2È˲ÎÓë

¾À½áÁËÁ½ÌìÁË£¬Ò²ÖØ×° ÁËsql server2005,µ«ÊÇÎÊÌ⻹ÊÇûÓнâ¾ö

ÎÒÓÃÓû§Ãûsa,ÔÚÊý¾Ý¿âµÄ¹ÜÀíÆ÷ÖÐ Äܹ»µÇ½sql server·þÎñÆ÷£¬µ«ÊÇ£¬ÔÚeclipseÖоÍÊÇÁ¬²»ÉÏÁË£¬
ǰ¼¸ÌìÁ¬ÉÏÁË£¬ÏÖÔÚ²»ÖªµÀÔõô°ìÁË¡£¡£¡£¡£¡£¡£
¶Ë¿Ú1433£¬Ó¦¸ÃûÓÐÎÊÌ⣬ÔÚDOSÏ£¬telnet ûÓÐÎÊÌ⣬ÎÒµÄeclipseµÄ³ÌÐòÈçÏ£¨³ÌÐòÖÐÏÔʾЦÁ³µÄµØ·½ÎªÓÒÀ¨ºÅ£©£¬ÔÚ¹¤³ÌÖÐÒ²ÒýÈëÁËsqljdbc4.jarÇý¶¯£¬»·¾³±äÁ¿Ò²¼ÓÈëÁËsqljdbc4.jarµÄ·¾¶

import java.sql.*;

public class resql{
public static void main(String[] srg) {
  String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //¼ÓÔØJDBCÇý¶¯
  String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=school";  //Á¬½Ó·þÎñÆ÷ºÍÊý¾Ý¿âschool
  String userName = "sa";  //ĬÈÏÓû§Ãû
  String userPwd = "123456";  //ÃÜÂë
  Connection dbConn;

  try {
   Class.forName(driverName);
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
  
   Statement st=dbConn.createStatement();
   String sg="select * from student";
   ResultSet rs=st.executeQuery(sg);
   while(rs.next())
   {
           System.out.println(rs.getString("id"+"\t"+rs.getString("sname"+"\t"+rs.getString("phone");
   }
   
   st.close();
   dbConn.close();
   System.out.println("Connection Successful!132";  //Èç¹ûÁ¬½Ó³É¹¦ ¿ØÖÆÌ¨Êä³öConnection Successful!
   
  } catch (Exception e) {
   e.printStackTrace();
  }
}
}
    ÏÖÔÚÀÏÊdzöÏÖµÄÎÊÌâÊÇ£º
Èçͼ¡£¡£¡£¡£ÊµÔÚ²»ÖªµÀÎÊÌâÔÚÄÄÀïÁË¡£¡£¡£¡£¡£¡£¸Ð¾õÊý¾Ý¿âûÓÐÎÊÌâѽ¡£¡£¡£¡£¡£

eclipeÁ¬½ÓSQL server2005µÄ´óÄÑÌâ
wt.jpg
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

me_yu

ľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÎÒ°®Ð¡³æ×Ó: ½ð±Ò+5, ¡ïÓаïÖú 2014-06-29 19:26:56
ÎÒ°®Ð¡³æ×Ó: ½ð±Ò+25, ¡ïÓаïÖú, лл»Ø´ð£¬½ð±Ò¶¼Ë͸øÄãÀ²¡£ 2014-08-06 11:42:10
ÕâÑùµÄÎÊÌâÔÚcsdnÎʻشðµÄÈËÓ¦¸Ã¸ü¶àµã
http://blog.csdn.net/fanpeii/article/details/7033977

[ ·¢×ÔСľ³æ¿Í»§¶Ë ]
Ìý£¬¼Å¾²µÄÒ¹ÀÌïÒ°ÀïÍÜÉùºÍ³æÃù£¬ºÃ²»»¶¿ì£¡
2Â¥2014-06-29 08:57:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÎÒ°®Ð¡³æ×Ó

гæ (ÕýʽдÊÖ)

ÒýÓûØÌû:
2Â¥: Originally posted by me_yu at 2014-06-29 08:57:33
ÕâÑùµÄÎÊÌâÔÚcsdnÎʻشðµÄÈËÓ¦¸Ã¸ü¶àµã
http://blog.csdn.net/fanpeii/article/details/7033977

ËäȻû°ïÉÏæ£¬»¹ÊÇллÄã¡£¡£¡£¡£¡£¡£ÏÖÔÚ½â¾öÁË¡£¡£¡£¡£¡£¡£
3Â¥2014-06-29 19:26:48
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

claro

½ð³æ (СÓÐÃûÆø)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

½â¾öÁ˾͹ØÁ˰ɣ¬¿´ÁËÇóÖú²Å½øÀ´µÄ¡£

[ ·¢×ÔÊÖ»ú°æ http://muchong.com/3g ]
4Â¥2014-07-21 06:37:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÎÒ°®Ð¡³æ×Ó

гæ (ÕýʽдÊÖ)

ÒýÓûØÌû:
4Â¥: Originally posted by claro at 2014-07-21 06:37:31
½â¾öÁ˾͹ØÁ˰ɣ¬¿´ÁËÇóÖú²Å½øÀ´µÄ¡£

¶î£¬²»ºÃÒâ˼ÁË£¬ÎÒÒÔΪ×Ô¶¯¹ØÌùÁËÄØ¡£¡£

[ ·¢×ÔÊÖ»ú°æ http://muchong.com/3g ]
5Â¥2014-07-21 09:27:04
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

Îĵ¶Ô£

гæ (СÓÐÃûÆø)

ÄãºÃ£¬ÇëÎÊÄãÊÇÔõô½â¾ö£¿

·¢×ÔСľ³æIOS¿Í»§¶Ë
6Â¥2018-11-25 21:53:10
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ ÎÒ°®Ð¡³æ×Ó µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏÇóµ÷¼ÁÒ»Ö¾Ô¸¹þ¹¤´ó324 +10 ãÆÐñ¶« 2026-03-28 12/600 2026-04-02 14:37 by olim
[¿¼ÑÐ] 279Çóµ÷¼Á +3 ¸µÎÄÇï 2026-04-02 3/150 2026-04-02 13:05 by 1753564080
[¿¼ÑÐ] 311Çóµ÷¼Á +16 zchqwer 2026-04-01 18/900 2026-04-02 10:15 by ²»³Ôô~µÄ؈
[¿¼²©] 26ÄêÉ격 +3 staryer 2026-03-30 4/200 2026-04-01 23:21 by ai4pharm
[¿¼ÑÐ] 0856£¬269·ÖÇóµ÷¼Á +8 ÓÐѧÉϾÍÐÐÇóÇóÁ 2026-03-30 11/550 2026-04-01 22:33 by 2026²ÄÁϵ÷¼Á
[¿¼ÑÐ] 266·ÖÇó²ÄÁÏ»¯¹¤Ò±½ð¿óÒµµÈרҵµÄµ÷¼Á +7 ÍÛºôºßºôºß 2026-03-26 7/350 2026-04-01 20:47 by cqupH
[¿¼ÑÐ] 265Çóµ÷¼Á +11 yelck 2026-04-01 12/600 2026-04-01 19:12 by 549790059
[¿¼ÑÐ] »·¾³¹¤³Ìµ÷¼Á +9 hyzzzzzzz. 2026-04-01 9/450 2026-04-01 14:20 by salamander`
[¿¼ÑÐ] 333Çóµ÷¼Á +4 °¢¿ÆÒÝ 2026-03-31 4/200 2026-04-01 09:11 by jp9609
[¿¼ÑÐ] Çóµ÷¼Á£º085600²ÄÁÏÓ뻯¹¤£¬¿¼²Ä¿Æ»ù£¬×Ü·Ö319 +17 678lucky 2026-03-31 21/1050 2026-04-01 01:40 by 1018329917
[¿¼ÑÐ] 289Çóµ÷¼Á +7 BrightLL 2026-03-29 7/350 2026-03-31 22:05 by 544594351
[¿¼ÑÐ] ²ÄÁϹ¤³Ì085601Êý¶þÓ¢Ò»335Çóµ÷¼Á +5 Ë«ÂíβƦÀϰå2 2026-03-31 5/250 2026-03-31 19:07 by Wang200018
[¿¼ÑÐ] 299Çóµ÷¼Á +8 àÅàÅàÅàÅ2 2026-03-27 8/400 2026-03-31 18:23 by lizhi8172
[¿¼ÑÐ] ±¾2Ò»Ö¾Ô¸C9-333·Ö£¬²ÄÁÏ¿ÆÑ§Ó빤³Ì£¬Çóµ÷¼Á +9 ÉýÉý²»½µ 2026-03-31 9/450 2026-03-31 18:01 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] ±¾¿Æ211ÉúÎïҽѧ¹¤³Ì085409Çóµ÷¼Á339·Ö +7 Àï×Óľyy 2026-03-29 7/350 2026-03-31 14:35 by fmesaito
[¿¼ÑÐ] 313Çóµ÷¼Á +6 Âô¸ö¹Ø×Ó°É 2026-03-31 6/300 2026-03-31 10:58 by Jaylen.
[¿¼ÑÐ] 293·ÖÇóµ÷¼Á£¬ÍâÓïΪ¶íÓï +5 ¼ÓÒ»Ò»¾Å 2026-03-31 5/250 2026-03-31 09:39 by zhshch
[¿¼ÑÐ] 105500ҩѧÇóµ÷¼Á£¬Ò»Ö¾Ô¸É½¶«´óѧҩѧ£¬348·Ö +3 gr¹þ¹þ¹þ 2026-03-28 3/150 2026-03-30 18:56 by Ô´_2020
[¿¼ÑÐ] Çóµ÷¼Á +7 Çà´º²ÃΪÈý½Ø 2026-03-29 7/350 2026-03-30 13:14 by laoshidan
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +3 raojunqi0129 2026-03-28 3/150 2026-03-28 15:27 by ÂäÉ˼
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û