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);
}
}
}
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);
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货