SQL与MySQL数据库连接实现-优快云博客

本文详细介绍了如何使用Java通过JNDI配置实现与SQL Server、MySQL和Oracle数据库的连接，包括连接参数设置、异常处理及成功连接的验证。

<?xml version="1.0" encoding="UTF-8"?>
<Context>
<!—sqlserver连接
<Resource name="jndi/ERP" auth="Container"
type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;SelectMethod=cursor"
username="sa"
password=""/>
-->

</Context>

import java.sql.*;
public class TestConnection
{
    public void getSqlConnection()
    {
    //Connection conn=null;
    try
    {
      Class.forName("com.microsoft.jdbc.sqlServer.SQLServerDriver");
      String url="jdbc:microsoft:sqlServer://localhost:1433;DatabaseName=Northwind;SelectMethod=cursor";
      String user="sa";
      String password="";
      Connection conn=DriverManager.getConnection(url,user,password);
      System.out.println("sql连接成功");

    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    }
    public void getMysqlConnection()
    {
    try
    {
      Class.forName("com.mysql.jdbc.Driver");
  //数据库名称test
      String url="jdbc:mysql://localhost:3306;DatabaseName=test;SelectMethod=cursor";
      String user="root";
      String password="sa";
      Connection conn=DriverManager.getConnection(url,user,password);
      System.out.println("Mysql连接成功");

    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    }
    public void getOracleConnection()
    {
    try
    {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      String url="jdbc:oracle:thin:@localhost:1521:XIAOHUA";
      String user="SCOTT";
      String password="sqh";
      Connection conn=DriverManager.getConnection(url,user,password);
      System.out.println("oracle连接成功");
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    }
    public void getSQL2005Connection()
    {
    try
    {
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
      String url="jdbc:sqlserver://127.0.0.1:1433;databaseName=wsmnc";
      String user="sa";
      String password="nc";
      Connection conn=DriverManager.getConnection(url,user,password);
      System.out.println("oracle连接成功");
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    }
    public static void main(String[] args)throws Exception
    {

       new TestConnectiongetSqlConnection();

    }
}

几种数据库的连接方式