复制 import   java.sql.*; public   class   JdbcDriver   {   public   static   void   main(String[]   srg)   {   String   driverName   =   "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动   String   dbURL   =   "jdbc:sqlserver://localhost:1433;   DatabaseName=xq_sql";   //连接服务器和数据库sample   String   userName   =   "sa";   //默认用户名   String   userPwd   =   "1234";   //密码    String sql=" SELECT * FROM xq_mem";    Connection   dbConn;   Statement state=null;   ResultSet rs=null;    try{   Class.forName(driverName);   dbConn   =   DriverManager.getConnection(dbURL,使数据示例 userName, userPwd);   // it works well..   //dbConn   =   DriverManager.getConnection(dbURL);   // doesnt work!   state=dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);   System.out.println( "Connection SQL Server 2005 Successful! ");   //如果连接成功   控制台输出Connection   Successful!   rs=state.executeQuery(sql);   while(rs.next()){   String id=rs.getString(1);   String username=rs.getString(2);   System.out.print(id+" ");   System.out.print(username+"\n");   }catch(Exception   e){   e.printStackTrace(); }   }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.

(责任编辑：应用开发)