Java and MS SQL Server 2000

[Hanna Habashy]

hi:
I have never accessed a database from my Java application before. Now, I am learning MS SQL server 2000. How can I access the data stored in SQL server throw my Java application?

[James Swan]

- you need to download some JDBC drivers for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5&DisplayLang=en
- run the setup.exe program which installs the drivers
the setup program installs 3 jars to the following location:
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\
- include these jars in your classpath
- try some code
- of course you need to fill in some blanks such as:
- servername
- db name
- user/password
- table details

import java.sql.*;
import java.util.*;
public class TestSQLServerConnection {
    public static void main(String[] args) {
        Connection connection = null;
        try {
            DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
            connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://myserver:1433;DatabaseName=myDB;User=myUser;Password=myPassword");
    
            Statement statement = connection.createStatement();
            String sql = "select * from myTable";
                       
            ResultSet rs = statement.executeQuery(sql);
            while (rs.next()) {
                int myInt = rs.getInt("myInt");
                String myString = rs.getString("MyString");
                ...
            }
            rs.close();
            statement.close();
    
        } catch (SQLException e) {
            e.printStackTrace();
            
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}