Azure将java Web App（java）连接到SQLDatabase

Question

尝试在Azure中连接Web App-Java和SQL数据库。我使用了这个示例和这个页面：https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-java-simple-windows/

import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class SQLDatabaseTest {

public String getDatabase(){

    String connectionString = "";

    connectionString = "jdbc:sqlserver://mydatabase.database.windows.net:1433;database=mydatabase;user=[Server admin]@mydatabase;password=[My Password];encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";

    // Declare the JDBC objects.
    Connection connection = null;
    Statement statement = null;
    ResultSet resultSet = null;
    PreparedStatement prepsInsertPerson = null;
    PreparedStatement prepsUpdateAge = null;

    try {           
        connection = DriverManager.getConnection(connectionString);

        return "Connected";      
    }
    catch (Exception e) {
        e.printStackTrace();
    }
    finally {
        // Close the connections after the data has been handled.
        if (prepsInsertPerson != null) try { prepsInsertPerson.close(); } catch(Exception e) {}
        if (prepsUpdateAge != null) try { prepsUpdateAge.close(); } catch(Exception e) {}
        if (resultSet != null) try { resultSet.close(); } catch(Exception e) {}
        if (statement != null) try { statement.close(); } catch(Exception e) {}
        if (connection != null) try { connection.close(); } catch(Exception e) {}
    }

   return "Not Connected"; 


   }
}

Answer 1

我想通了出了什么问题。因为我使用的是Mac，所以没有将sqljdbc42.jar文件添加到类路径中。在windows中，您只需运行。exe，但在Mac上，您需要手动添加它。

这个答案帮助我将它添加到类路径:https://stackoverflow.com/a/1676261/1436690