eclipse 连接SQLserver2000

最新推荐文章于 2024-09-09 10:06:48 发布

牛起

最新推荐文章于 2024-09-09 10:06:48 发布

阅读量440

点赞数

文章标签： sqlserver eclipse string exception jdbc import

本文链接：https://blog.csdn.net/scmylidong/article/details/6012285

版权

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;
        }
    }
}