如何开始使用 Microsoft JDBC

Driver d = (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

				

con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");

				

import java.*;

public class Connect{

     private java.sql.Connection  con = null;

     private final String url = "jdbc:microsoft:sqlserver://";

     private final String serverName= "localhost";

     private final String portNumber = "1433";

     private final String databaseName= "pubs";

     private final String userName = "user";

     private final String password = "password";

     // Informs the driver to use server a side-cursor,

     // which permits more than one active statement

     // on a connection.

     private final String selectMethod = "cursor";



     // Constructor

     public Connect(){}



     private String getConnectionUrl(){

          return url serverName ":" portNumber ";databaseName=" databaseName ";selectMethod=" selectMethod ";";

     }



     private java.sql.Connection getConnection(){

          try{

               Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

               con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);

               if(con!=null) System.out.println("Connection Successful!");

          }catch(Exception e){

               e.printStackTrace();

               System.out.println("Error Trace in getConnection() : "   e.getMessage());

         }

          return con;

      }



     /*

          Display the driver properties, database details

     */



     public void displayDbProperties(){

          java.sql.DatabaseMetaData dm = null;

          java.sql.ResultSet rs = null;

          try{

               con= this.getConnection();

               if(con!=null){

                    dm = con.getMetaData();

                    System.out.println("Driver Information");

                    System.out.println("\tDriver Name: "  dm.getDriverName());

                    System.out.println("\tDriver Version: "  dm.getDriverVersion ());

                    System.out.println("\nDatabase Information ");

                    System.out.println("\tDatabase Name: "  dm.getDatabaseProductName());

                    System.out.println("\tDatabase Version: "  dm.getDatabaseProductVersion());

                    System.out.println("Avalilable Catalogs ");

                    rs = dm.getCatalogs();

                    while(rs.next()){

                         System.out.println("\tcatalog: "  rs.getString(1));

                    }

                    rs.close();

                    rs = null;

                    closeConnection();

               }else System.out.println("Error: No active Connection");

          }catch(Exception e){

               e.printStackTrace();

          }

          dm=null;

     }



     private void closeConnection(){

          try{

               if(con!=null)

                    con.close();

               con=null;

          }catch(Exception e){

               e.printStackTrace();

          }

     }

     public static void main(String[] args) throws Exception

       {

          Connect myDbTest = new Connect();

          myDbTest.displayDbProperties();

       }

}



				
			   
			   

                       标签：
                   
                   
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com

特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有