SQLServer之JDBC驱动代码

   SQLServer之JDBC驱动代码 收藏
最近写了一段sqlserver的JDBC代码，使用的是2000的自带的数据库，但要注意只有win2000(03server)或者xp打了sp2的补丁，1433端口才能打开，否则是不能成功的

import java.sql.*;

public class test{
   
    public static void main(String [] args){
       
        Connection conn=null;
        Statement stm=null;
        ResultSet rs=null;
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;User=sa;Password=sa";
            conn=DriverManager.getConnection(url);
            stm=conn.createStatement();
            rs=stm.executeQuery("SELECT * from Employees");
           
            while(rs.next()){
                String firstname=rs.getString(2);
                String lastname=rs.getString(3);
                System.out.println(firstname+":"+lastname);
            }
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        finally{
            try{
                rs.close();
                stm.close();
                conn.close();
            }
            catch(Exception e){
            }
        }
    }
}

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/echott/archive/2006/05/18/744043.aspx