testjdbc.java

测试数据库是否连接成功！测试是否加载了驱动程序

import   java.sql.*;     
 public   class   testjdbc   {   
            public   static   void   main(String[]   args){     
                  String   driverClassName   =   "com.microsoft.jdbc.sqlserver.SQLServerDriver";   
                  String   url   =   "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=luowei";     
                  String   uid   =   "sa";   
                    String   pwd   =   "986215";   
                    try{     
                          Class.forName(driverClassName);     
                    }catch(Exception   e){     
                          e.printStackTrace();     
                          System.err.println("找不到驱动程序路径。");     
                          System.exit(0);     
                  }     
                  Connection   conn   =   null;     
                  PreparedStatement   ps   =   null;   
                  ResultSet   rs   =   null;     
                  String   sql   =   "select   *   from  yonghu ";     
                  try{     
                          conn   =   DriverManager.getConnection(url,uid,pwd);     
                          ps   =   conn.prepareStatement(sql);     
                          rs   =   ps.executeQuery();     
                          System.out.println("table   categories:");     
                          System.out.println("id\t\tname");     
                          while(rs.next()){     
                                  String   id   =   rs.getString(1);     
                                  String   name   =   rs.getString(2);     
                                  System.out.println(id   +   "\t\t"   +   name);     
                          }     
                  }catch(SQLException   e){     
                          e.printStackTrace();     
                          System.err.println("连接数据库失败.");     
                          System.exit(0);     
                  }finally{     
                          if(rs   !=   null){     
                                  try{     
                                          rs.close();     
                                  }catch(SQLException   e){     
                                          e.printStackTrace();     
                                          System.err.println("不能关闭数据库连接");     
                                          System.exit(0);     
                                  }     
                          }     
                          if(ps   !=   null){     
                                  try{     
                                          ps.close();     
                                  }catch(SQLException   e){     
                                          e.printStackTrace();     
                                          System.err.println("不能关闭数据库连接");     
                                          System.exit(0);     
                                  }     
                          }     
                          if(conn   !=   null){     
                                  try{     
                                          conn.close();     
                                  }catch(SQLException   e){     
                                          e.printStackTrace();     
                                          System.err.println("不能关闭数据库连接");     
                                          System.exit(0);     
                                  }     
                          }     
                  }     
                  System.out.println("数据库连接测试成功.");     
          }     
  }