连接SQL Server - Java

最新推荐文章于 2023-11-24 16:01:25 发布

永生天地

最新推荐文章于 2023-11-24 16:01:25 发布

阅读量1k

点赞数

文章标签： sql server sqlserver string properties exception user

本文链接：https://blog.csdn.net/xys_777/article/details/5672394

版权

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Test {
private Connection conn;
private String CLASSFORNAME=com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url ="jdbc:sqlserver://127.0.0.1:1433;databaseName=framework";
private String user="sa";
private String password="";

boolean ConnectionDataBase()
{

    Properties sysProps = System.getProperties();
    sysProps.put("user",user);
    sysProps.put("password",password);
     try
    {
    Class.forName(CLASSFORNAME);
    conn= DriverManager.getConnection(url, sysProps);
    return true;
    }
  catch(Exception e)
  {
   e.printStackTrace();
   return false;
  }
}

}

//"com.microsoft.jdbc.sqlserver.SQLServerDriver""