? / * This source for connect Microfost SQL Server 2000 and test servic infomationThis source is modify by GongTaohttp: //support.microsoft.com/default.aspx scid = kb; en-us; 313100set classpath = .; C: / MyJava / JDBCPACK / MSSQL / MSBASBAS.jar; C: /myjava/jdbcPack/Mssql/msutil.jar; c: /myjava/jdbcPack/Mssql/msqlser.jar
* / Import java.sql. *; import java.io. *;
import java *; public class Connect {private java.sql.Connection con = null; private final String url = "jdbc: microsoft: sqlserver: //";. private final String serverName = "GONGTAO"; private final String portNumber = " 1433 "; private final String databaseName =" pubs "; private final String userName =" sa "; private final String 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 driverties, database details * /
Public void displayDbproperties () {java.sql.databaseMetadata DM = NULL; java.sql.resultset = 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:" rgetstring 1));}}}}} RS = null; closeconnection ();} else system.out.println ("error: no activity");} 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 {connection {connection {connection {connection = New connection (); mydbtest.displaydbproperties ();
