如何连接SQL Server 7.0

Question

要怎么详细，就是这样用jdbc建立和SQL SERVER 7.0的连接！代码怎么写！
客户机怎么连接！

Answer 1

以下是Oracle的代码。改一下就是SQL的
package com.west163.wlywest.test;
import java.sql.*;public class JdbcCon{
public JdbcCon(){
}

public java.sql.ResultSet ExcuteSQL(String sSQL){
java.sql.ResultSet res;

res = null;
try{
System.out.println("Registering JDBC driver...");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("Connecting to the database...");
Connection jdbclink = DriverManager.getConnection("jdbc:oracle:thin:@uisqds029:1521:orcl","system","manager");
System.out.println("Connect OK...");
Statement stament = jdbclink.createStatement();
System.out.println("Executing Query...");
res = stament.executeQuery(sSQL);
}
catch(SQLException ex){
}
return res;
}
}

Answer 2

很简单:
import java.sql.*;
import java.util.*;public class DataBase
{
String       sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String       sConnStr  = "jdbc:odbc:DataSourceName";
        Connection   conn      = null;
        Statement    stmt      = null;
        ResultSet    rs        = null;
  
        public DataBase()
        {
         try
                {
                 Class.forName(sDBDriver);
                }
                catch(java.lang.ClassNotFoundException e)
                {
                 System.err.println("DataBase(): " + e.getMessage());
                }
        }
        
        public ResultSet executeQuery(String sql)
        {
         try
         {
         conn    = DriverManager.getConnection(sConnStr,"sa","sa"); 
                        stmt    = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
                        rs      = stmt.executeQuery(sql);
                }
                catch(SQLException ex)
                {
                 System.err.println("DataBase.executeQuery:"+ex.getMessage());
                }
                return rs;
        }
}