java method to connect to the mysql database and test whether the connection was successful

This article illustrates the method of java connecting to mysql database and testing whether the connection is successful. To share for your reference, the details are as follows:

package com.test.tool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCUtlTool {
  public static Connection getConnection(){
    String driver="com.mysql.jdbc.Driver";  // To obtain mysql The driver class for the database 
    String url="jdbc:mysql://localhost:3306/test"; // Connect to database ( kucun Is the database name) 
    String name="root";// The connection mysql The user name 
    String pwd="123456";// The connection mysql The password 
    try{
      Class.forName(driver);
      Connection conn=DriverManager.getConnection(url,name,pwd);// Get connection object 
      return conn;
    }catch(ClassNotFoundException e){
      e.printStackTrace();
      return null;
    }catch(SQLException e){
      e.printStackTrace();
      return null;
    }
  }
  public static void closeAll(Connection conn,PreparedStatement ps,ResultSet rs){
    try{
      if(rs!=null){
        rs.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
    try{
      if(ps!=null){
        ps.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
    try{
      if(conn!=null){
        conn.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
  }
  public static void main(String[] args) throws SQLException
  {
    Connection cc=JDBCUtlTool.getConnection();
    if(!cc.isClosed())
    System.out.println("Succeeded connecting to the Database!");
    Statement statement = cc.createStatement();
    String sql = "select * from test2";
    ResultSet rs = statement.executeQuery(sql);
    while(rs.next()) {
      System.out.println(rs.getString("id")+"");
    }
  }
}

For more information about java, please refer to Java+MySQL Database programming Summary, Java Data Structure and Algorithm Tutorial, Java File and Directory Operation Skills Summary, Java Operation Skills Summary of DOM Nodes and Java Cache Operation Skills Summary.

I hope this article has been helpful in java programming.