/* This source for connect Microfost SQL Server 2000 and test servic infomation This source is modify by GongTao http://support.microsoft.com/default.aspx?scid=kb;en-us;313100 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";