第ä¸æ¥ï¼
ä¸è½½å®è£
æ°æ®åºï¼Microsoft SQL Server 2000(SP4)ï¼,å¨å®è£
è¿ç¨ä¸è®¾ç½®sqçå¯ç 为"maowei",å½ç¶ä½ ä¹å¯ä»¥ä¸è®¾ç½®å¯ç ï¼è®°ä½è¿éä¸å®è¦ç»æ°æ®åºè¦ä¸SP4çè¡¥ä¸ï¼å®è£
好æ°æ®åºä»¥åï¼æå¼<å¼å§>-----<ç¨åº>-----<MicrosoftSQL Server>-----<ä¼ä¸ç®¡çå¨>ï¼å¨âä¼ä¸ç®¡çå¨âä¸æ°å»ºä¸ä¸ªæ°æ®åºæ件test,并å¨æ°æ®åºtestä¸å建ç«ä¸å¼ 表first_tableï¼è¡¨ä¸çå段åä¸å段å¼åå«ï¼æ³¨ææ°æ®ç±»åä¸é¿åº¦ï¼ãç¶åå¯å¨<æå¡ç®¡çå¨>,è®°ä½ä¸å®è¦å¯å¨ã
æ°å»ºä¸ä¸ªæ°æ®åºæ件testï¼å¹¶å»ºç«è¡¨first_tableï¼
å¯å¨æå¡ç®¡çå¨
第äºæ¥ï¼
å®è£
并é
ç½®JAVA JDK æ使ç¨ççæ¬æ¯jdk-1_5_0_08,å¯ä»¥å°
http://java.sun.comä¸è½½å°ãJDKçå®è£
å¾
ç®åï¼ä¸ç´ç¹ä¸ä¸æ¥å°±å¯ä»¥äºãå¨è¿éæå®è£
çè·¯å¾ä¸æ¯é»è®¤çï¼å®è£
å¨C:/diskplay ,好äºå®è£
æåï¼
ç¶åè¦åçå°±æ¯é
ç½®JAVAçè¿è¡ç¯å¢ï¼å³å»"æççµè"---"é«çº§"---"ç¯å¢åé",å¨ç¨æ·åé
ééæ©âæ°å»ºâ
åéåï¼"CLASSPATH"ï¼
åéå¼ï¼".;C:/diskplay/Java/jdk1.5.0_08/lib/tools.jar;C:/diskplay/Java/jdk1.5.0_08/jre/lib/dt.jar;"
åæ°å»ºä¸ä¸ªåéåï¼"JAVA_HOME",
åéå¼:"C:/diskplay/Java/jdk1.5.0_08",
å¨ä¸é¢çç³»ç»åééæä¸ä¸ªåéå为Path,å¨å®çåéå¼åé¢éå ä¸";C:/diskplay/Java/jdk1.5.0_08/bin;",
好äº.ç°å¨JAVçè¿è¡ç¯å¢æ们就å®è£
并é
置好äº,ä½è¦æ³¨æå ç¹:
1.ä¸é¢å¨é
ç½®JAVAåéå¼,è·¯å¾ä¸å®è¦ä¸ä½ å®è£
çJAVAè·¯å¾ä¸è´,å 为ææ¯å®è£
å¨C:/diskplay æ以åéå¼çè·¯
å¾æé½æ¯è®¾ç½®å¨è¿ä¸ªç®å½ä¸.
2.ä¸é¢çåéå¼ä¸å
æ¬ä¸å¯¹"",åéå¼çå
容æ¯""éé¢çå
容.
ç°å¨ä½ å¯ä»¥å¨DOSä¸æµè¯ä¸ä¸ä½ çJAVAç¯å¢æ¯å¦é
ç½®æå,å¨DOSä¸è¾å
¥javac,å¦æè½çå°ä¸å¾,表示å®è£
æå.
第ä¸æ¥:
å®è£
è¿æ¥SQLæ°æ®åºçJDBC驱å¨ç¨åº,å¯ä»¥å°è¿éä¸è½½(
http://www.microsoft.com/downloads/details.aspx?FamilyID=ee91ad1a-1ee4-49e1-95ea-e3f0e39114a9&DisplayLang=en),æ§è¡ä¸è½½å°çå¯æ§è¡æ件ï¼ä¸ååªéè¦ç¹å»ä¸ä¸æ¥ï¼è³å°åºç°finishæé®ï¼å®æå®è£
.
注ï¼
(1) ms_JDBC_setupé»è®¤å®è£
è·¯å¾ä¸ºï¼
c:/Program Files/Microsoft SQL Server 2000 Driver for JDBC
(2)å®è£
ç®å½/lib/ä¸çä¸ä¸ªjaræ件å³æ¯è¦çJDBC驱å¨æ ¸å¿
msbase.jar
mssqlserver.jar
msutil.jar
(3)å°ä»¥ä¸ä¸ä¸ªæ件æ·è´è³javaå®è£
ç®å½ä¸çjre/lib/extç®å½ä¸,å°±å¯ä»¥æ·è´è³
C:/diskplay/Java/jre1.5.0_08/lib/extç®å½ä¸
第åæ¥ï¼
ç°å¨å¼å§ç¨åºä¹¦åè¿ç¨äºãå¨Cççæ ¹ç®å½ä¸ï¼å
¶å®çç®å½ä¹å¯ä»¥ï¼å»ºç«ä¸ä¸ªè®°äºæ¬æ件ä¿
å为:java_sqljdbc.java,注ææ件çåç¼åæ¯.java ä¸è¦é©¬èç»ææäºjava_sqljdbc.java.txt.è¿ç¹å¾éè¦ã
ç¶åå¨éé¢åå
¥ä»¥ä¸ç代ç 并ä¿åã
package Lesson3;
import java.sql.*; //å¼å
¥sqlä¸çææç±»
public class Testdb
{
public static void main(String args[])
{
try
{
//注åSQL Server JDBC驱å¨ç¨åº
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driver);
//è¿æ¥å°æå®æ°æ®åºçURL
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
String User ="sa"; //è½æå¼æ°æ®åºçç¨æ·å
String Password = "maowei"; //å®è£
æ¶è®¾ç½®çå¯ç æçå¯ç æ¯maowei
//ä½¿ç¨ DriverManager ç±»ç getConnection æ¹æ³å¯¹æ°æ®åºè¿è¡è¿æ¥
Connection conn = DriverManager.getConnection(URL,User,Password);
Statement stmt=conn.createStatement();
//æ¥è¯¢first_table表
String sql = " select * from first_table ";
ResultSet rs = stmt.executeQuery(sql);
//游æ åä¸ç§»å¨ï¼è¿å表ä¸çæææ°æ®ï¼
while(rs.next())
{
//è¾å
¥è¡¨ä¸çå段å¼
System.out.println(rs.getString("title")+rs.getString("URL")+rs.getString("name")+rs.getString("age"));
}
//å
³éæå¼çæµ
rs.close();
stmt.close();
conn.close();
}//å¼å¸¸å¤çå¯ä»¥ä¸ç¨ç®¡å®ãç
§åä¸æ¥å°±å¯ä»¥äº
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
}
}
æåï¼ç¹å»å¼å§----è¿è¡----cmd,æå¼DOSçªå£ï¼è¿å
¥å°Cçæ ¹ç®å½ä¸è¾å
¥ï¼java_sqljdbc.java
å
ç¼è¯javaæ件为classæ件ï¼åè¾å
¥ï¼java java_sqljdbc å¦æè½çå°æååºæ°æ®åºä¸çå¼ï¼å°±è¡¨ç¤ºä¸åOK~~