关于连接sql server

Question

java连接到sql server 2005 应该做哪些工作?  我写了一些代码  运行却有异常 显示 
 [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
请高手指教,最好把完整的代码贴出来.

Answer 1

import java.sql.*;import java.net.URL;class java2sqlserver {       public static void main(String[] args)        {              String url="jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=739555;DatabaseName=northwind";              String query="Select * From Categories";              try              {                     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                     //DriverManager.setLogStream(System.out);                     Connection con=DriverManager.getConnection(url);                     checkForWarning(con.getWarnings());                     Statement stmt=con.createStatement();                     ResultSet rs=stmt.executeQuery(query);                     dispResultSet(rs);                     rs.close();                     stmt.close();                     con.close();              }              catch(SQLException ex)              {            System.out.println(ex.toString()+"----SQLException caught----");                     while(ex!=null)                     {                            System.out.print("SQLState:"+ex.getSQLState());                            System.out.print("Message:"+ex.getMessage());                            System.out.print("Vendor:"+ex.getErrorCode());                ex=ex.getNextException();                            System.out.println("");                     }              }              catch(java.lang.Exception ex)              {                     ex.printStackTrace();              }}                            private static boolean checkForWarning(SQLWarning warn)              {                     boolean rc=false;                     if(warn!=null)                     {                            System.out.println("----Warning----");                            rc=true;                            while(warn!=null)                            {                            System.out.print("SQLState:"+warn.getSQLState());                            System.out.print("Message:"+warn.getMessage());                            System.out.print("Vendor:"+warn.getErrorCode());                            System.out.println("");                            warn=warn.getNextWarning();                              }                     }                     return rc;              }                private static void dispResultSet(ResultSet rs) throws SQLException              {            int i;                     ResultSetMetaData rsmd=rs.getMetaData();                     int numCols=rsmd.getColumnCount();                     for(i=1;i<=numCols;i++)                     {                            if(i>1) System.out.print(",    ");                            System.out.print(rsmd.getColumnLabel(i));                       }                     System.out.println("");                     boolean more=rs.next();                     while(more)                     {                            for(i=1;i<numCols;i++)                            {                                   if(i<1) System.out.print(",    ");                                   System.out.println(rs.getString(i));                            }                            System.out.println("");                            more=rs.next();                     }              }              //System.out.println("Hello World!");       }  

Answer 2

http://topic.csdn.net/t/20021016/14/1101494.html