测试数据库连接是否可用

项目运行时，显示数据库异常，让我们非常苦恼，我们可以用一段简短的代码测试一下。

首先，新建一个web项目，在web项目中导入如下图所示jar包：

导入上述jar包，然后新建一个类

package zzz;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.Test;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class DataBaseConnect {

  public Connection getConnection() {

         DriverManagerDataSource dataSource = new DriverManagerDataSource();
         dataSource.setDriverClassName("oracle.jdbc.OracleDriver");
         dataSource.setUrl("jdbc:oracle:thin:@10.1.102.162:1521/DRO");
         dataSource.setUsername("JS");
         dataSource.setPassword("JS");

         Connection connection = null;
         try {
             connection = dataSource.getConnection();
         } catch (SQLException e) {
             e.printStackTrace();
             return null;
         }

         System.out.println(connection);

         if (connection != null) {
             try {
              String sql = "select * from user_";
                 PreparedStatement pstmt;
                 pstmt = (PreparedStatement)connection.prepareStatement(sql);
                 ResultSet rs = pstmt.executeQuery();
                 int col = rs.getMetaData().getColumnCount();
                 System.out.println("============================");
                 while (rs.next()) {
                     for (int i = 1; i <= col; i++) {
                         System.out.print(rs.getString(i) + "\t");
                         if ((i == 2) && (rs.getString(i).length() < 8)) {
                             System.out.print("\t");
                         }
                      }
                     System.out.println("");
                 }
                     System.out.println("============================");

                 connection.close();
             } catch (SQLException e) {
                 e.printStackTrace();
                 return null;
             }
         }

         return connection;
     }

  @Test
  public void testConn(){
   Connection connection = this.getConnection();
   System.out.println(connection);
  }
}