//import com.microsoft.*;

//注意：在java与sql server 连接时不需要这个包，其他书上说这个包是必需的，这个问题有待进一步讨论

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();

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>