mssql2000如何利用JDBC连接两个数据库……在线等
我现在有条SQL语句select   count(1)   from   changjie.dbo.Sm_deliver_backup   a  
where   a.itemid=998806  
and   a.[time]   > =   20070616000000   and   a.[time]   <   20070616240000
and   substring(CONVERT   (varchar(50),usernumber),0,8)   in  
(select   number   from   shike.dbo.[sm_分省市号码段]     where   省= '福建 ')

我想利用JDBC连接changjie和Shike这两个数据库，JDBC该如何编写。
我现在JDBC是这样的
public   ConnectJdbc()//利用构造方法设置数据库驱动程序和连接好数据库
{
try
{
        Class.forName(DriverName);  
}catch(ClassNotFoundException   e)
{
        e.printStackTrace();
        System.out.println( "数据库驱动程序加载异常! "+e);
}

try
{

        conn=DriverManager.getConnection( "jdbc:microsoft:sqlserver://192.168.2.139:1433;DatabaseName=changjie;User=sa;Password=63586500 ");
}catch(SQLException   e)
{
    e.printStackTrace();
    System.out.println( "数据库连接程序加载异常! "+e);
}
        }
这只能连上changjie数据库，想要同时连上changjie和Shike两个数据库该怎么写这个JDBC？

------解决方案--------------------
conn1=DriverManager.getConnection( "jdbc:microsoft:sqlserver://192.168.2.139:1433;DatabaseName=changjie;User=sa;Password=63586500 ");

conn2=DriverManager.getConnection( "jdbc:microsoft:sqlserver://192.168.2.139:1433;DatabaseName=changjie;User=sa;Password=63586500 ");

conn1和conn2 用的时候分开用；我没用过，你试以下吧

------解决方案--------------------
conn=DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;User=sa;Password=sa ");

------解决方案--------------------
还有别的答案没有啊？
---------------------------------
答案是：没有！
------解决方案--------------------
//=====================================================================
//
// File: connectDS.java
// Summary: This Microsoft SQL Server 2005 JDBC Driver sample application
// demonstrates how to connect to a SQL Server database by
// using a data source object. It also demonstrates how to
// retrieve data from a SQL Server database by using a stored
// procedure.
// Date: April 2006
//
//---------------------------------
//
// This file is part of the Microsoft SQL Server JDBC Driver Code Samples.
// Copyright (C) Microsoft Corporation. All rights reserved.
//
// This source code is intended only as a supplement to Microsoft
// Development Tools and/or on-line documentation. See these other
// materials for detailed information regarding Microsoft code samples.
//
// THIS CODE AND INFORMATION ARE PROVIDED "AS IS " WITHOUT WARRANTY OF
// ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO
// THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
// PARTICULAR PURPOSE.
//
//=====================================================================

import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class connectDS {

public static void main(String[] args) {

// Declare the JDBC objects.
Connection con = null;
CallableStatement cstmt = null;