JAVA连接SQLSERVER的例子.doc

JAVA连接SQLSERVER的例子 set classpath=.;C:\MyJava\JDBCPack\MSSQL\msbase.jar;C:\MyJava\JDBCPack\MSSQL\msutil.jar;C:\MyJava\JDBCPack\MSSQL\mssqlserver.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 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