eclipse 连接SQLserver2000

来源：互联网发布：图片相似度算法tensor 编辑：程序博客网时间：2024/06/05 16:44

import java.sql.*;

public class clsmain {
    public static void main(String[] args) {
    Connection objCon=getConnection();

        try
        {
         Statement stmt=objCon.createStatement();
         ResultSet rst=stmt.executeQuery("Select * from sysusers");
         while(rst.next())
         {
         System.out.println(rst.getString("name"));
         }
        }
        catch(SQLException e)
        {
        e.printStackTrace();
        }
    }

    public static Connection getConnection()
    {
    String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
        String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=master";
        String userName = "sa";
        String userPwd = "sa";
        Connection con=null;

        try
        {
            Class.forName(driverName);
            con=DriverManager.getConnection(dbURL, userName, userPwd);
            System.out.println("Connection Successful!");
            return con;
        }
        catch (Exception e)
        {
            e.printStackTrace();
            return con;
        }
    }
}

jboss-4.2.2.GA/server/default/lib/sqljdbc4.jar 加入。

安装SQLserver sp4。