JAVA与 SQL server2008进行连接

最新推荐文章于 2021-02-24 10:10:32 发布

于小烦同学

最新推荐文章于 2021-02-24 10:10:32 发布

阅读量873

点赞数 1

分类专栏： Java

本文链接：https://blog.csdn.net/junwei_yu/article/details/16948847

版权

Java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

import java.sql.*;

public class Test {
 public static void main(String [] args) throws SQLException
 {
  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String url="jdbc:sqlserver://localhost:1433;databaseName=test"; 
  
  String userName="sa"; //"MVF7JLVWLQ934VP";
  //String userPwd= "password";
  
 try
{
    Class.forName(driverName);
    System.out.println("加载驱动成功！");
}catch(Exception e){
    e.printStackTrace();
    System.out.println("加载驱动失败！");
}
try{
    Connection dbConn=DriverManager.getConnection(url,userName,userPwd);
    dbConn.clearWarnings();
    System.out.println("连接数据库成功！");
    
    Statement SqlStatement = dbConn.createStatement();
    ResultSet SqlResult = SqlStatement.executeQuery("SELECT * FROM STUDENT");
    
    while(SqlResult.next() == true) {
        System.out.println(SqlResult.getString(1) + "\t" + SqlResult.getString(2)+ "\t" + SqlResult.getString(3));
    }
}catch(Exception e)
{
    e.printStackTrace();
    System.out.print("SQL Server连接失败！");
}        
}

}