MS-SQL 2000, JDBC 연결

2008. 2. 24. 02:56

1. JDK1.5 설치
http://java.sun.com/j2se/1.5.0/download.jsp
- 환경설정은 검색해서 찾아보고 설정해주고

2. MS-SQL2000 설치

3. MS-SQL2000 SP3 설치
http://www.microsoft.com/downloads/details.aspx?displaylang=ko&FamilyID=90DCD52C-0488-4E46-AFBF-ACACE5369FA3
kor_sql2ksp3.exe 다운로드

4. MS-SQL JDBC CONNECTOR 설치
http://www.microsoft.com/downloads/results.aspx?pocId=3&freetext=jdbc&DisplayLang=en
-> SQL Server 2000 Driver for JDBC 다운받고 설치

(설치된 경로)
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib 에 있는 파일들을
C:\자바폴더\jre\lib\ext 에 복사시킨다.

-> SQL Server 2000 Driver for JDBC SP3
->-> setup.exe 다운받고 설치

5. 1433 (MS-SQL)포트 열려있는지 확인
윈도우 -> 시작 -> 실행 -> "cmd"

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\>netstat -an
Active Connections
Proto Local Address    Foreign Address    State
TCP    0.0.0.0:1433 0.0.0.0:0    LISTENING
UDP    0.0.0.0:1434 *:*
C:\>_

6. 연결 테스트 Source
/* connMSSql.java */

import java.sql.*;

public class connMSSql {
  public static void main(String[] args) {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

String sDB_Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String sDB_ID = "sa"; // SQL ID
    String sDB_Pass = "1234"; // SQL Password
    // "jdbc:microsoft:sqlserver://아이피:포트;DatabaseName=데이터베이스이름"
    String sDB_URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=PUBS";
    String sQuery = " SELECT * FROM SALES ";

try {
      Class.forName(sDB_Driver);
      conn = DriverManager.getConnection(sDB_URL , sDB_ID, sDB_Pass);
      stmt = conn.createStatement();
      rs = stmt.executeQuery(sQuery);

while(rs.next()) {
        System.out.println( "============================" );
        System.out.println( "STOR_ID = "+ rs.getString("STOR_ID") );
        System.out.println( "ORD_NUM = "+ rs.getString("ORD_NUM") );
        System.out.println( "ORD_DATE = "+ rs.getString("ORD_DATE") );
        System.out.println( "QTY = "+ rs.getString("QTY") );
        System.out.println( "PAYTERMS = "+ rs.getString("PAYTERMS") );
        System.out.println( "TITLE_ID = "+ rs.getString("TITLE_ID") );
      }
    } catch(Exception e) {
      System.out.println("[Error] "+ e);
    } finally {
      if( rs != null ) rs.close();
      if( stmt != null ) stmt.close();
      if( conn != null ) conn.close();
    }
  }
}

darkrrr

MS-SQL 2000, JDBC 연결

티스토리툴바