java直接连接sql server 和网上说的不一样！！！！！！！请帮忙！！！！！
我参考的是 http://dev.csdn.net/article/65/65494.shtm
SQL Server for JDBC驱动程序 是在http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp下的没让我选择目录就安装上了
我执行的是http://dev.csdn.net/article/65/65494.shtm最下面的那段代码
请指教
问题点数：0、回复次数：8Top
1 楼drugon（更高，更远，更强）回复于 2005-04-02 12:05:17 得分 0
import java.sql.*;
public class ConnectSQLServer
{
public static void main(String[] args)
{
Connection con;
DatabaseMetaData meta;
ResultSet set,info;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
System.out.println("ClassNotFoundException ->"+e);
}
try
{
String url="jdbc:microsoft:sqlserver://210.22.25.62:3003;DatabaseName=mobile;user=MarsGw;password=witlu!@@@" ;
String user = "MarsGw";
String password = "witlu!@@@";
//con = DriverManager.getConnection(url,user,password);
con = DriverManager.getConnection(url);
if (con!=null)
System.out.println("Connection successfull !");
else System.out.println("Connection failure !");
meta=con.getMetaData();
System.out.println("getDatabaseProductName()->"+meta.getDatabaseProductName());
System.out.println("getSchemaTerm() ->"+meta.getSchemaTerm() );
System.out.println("getURL() ->"+meta.getURL() );
System.out.println("getUserName() ->"+meta.getUserName() );
set=meta.getCatalogs();
while (set.next())
{
System.out.println("TABLE_SCHEM ->"+set.getString(1));
// System.out.println("TABLE_CATALOG ->"+set.getString(2));
}
String type[]={"TABLE"};
String column[]={"TABLE_CAT","TABLE_SCHEM","TABLE_NAME","TABLE_TYPE","REMARKS"};
//String column[]={"TABLE_CAT","TABLE_SCHEM","TABLE_NAME","TABLE_TYPE","REMARKS","TYPE_CAT", "TYPE_SCHEM","TYPE_NAME","SELF_REFERENCING_COL_NAME","REF_GENERATION"
info=meta.getTables(null,null,"%",type);
ResultSetMetaData me=info.getMetaData();
for (int i=1;i<=me.getColumnCount();i++)
System.out.println(me.getColumnName(i));
while (info.next())
{
for (int i=1;i<=5;i++)
// System.out.println(column[i-1]);
System.out.println(column[i-1]+"<----->"+info.getString(i));
System.out.println();
}
}
catch (Exception e)
{
System.out.println("Exception ->"+e);
}
}
}Top
2 楼ericqgn（看法劳动撒发 ）回复于 2005-04-02 13:39:34 得分 0
数据库的url只保留jdbc:microsoft:sqlserver://210.22.25.62:3003;DatabaseName=mobile就行了，用户名和密码在getConnection(url,"username","password")就行了
Top
3 楼webshop（牧羊人）回复于 2005-04-02 14:38:58 得分 0
这样就可以了吗？Top
4 楼WHF_0000（无情）回复于 2005-04-02 16:27:50 得分 0
to:drugon(更高，更远，更强) 还是不行！！！！！！！居然提示我没有适当的驱动程序Top
5 楼zxbrgjs（GoFace）回复于 2005-04-02 16:32:48 得分 0
得去找到那几个包,然后把它们加到项目中?Top
6 楼WHF_0000（无情）回复于 2005-04-02 17:15:38 得分 0
包名叫什么？？？Top
7 楼xiahongboy（夏雨天）回复于 2005-04-02 18:28:50 得分 0
你下载的jdbc驱动呀。
Top
8 楼WHF_0000（无情）回复于 2005-04-05 08:34:30 得分 0
我下过了Top
