Home  >  Article  >  Java  >  Java method to detect success in connecting to mysql database

Java method to detect success in connecting to mysql database

黄舟
黄舟Original
2017-09-02 13:19:373408browse

This article mainly introduces the method of java connecting to mysql database and testing whether the connection is successful. Combined with the complete example form, it analyzes the specific steps and related operation skills of java to connect to mysql database based on jdbc and return the connection status. Friends in need can refer to it. Next

The example in this article describes how to connect java to mysql database and test whether the connection is successful. Share it with everyone 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";  //获取mysql数据库的驱动类
    String url="jdbc:mysql://localhost:3306/test"; //连接数据库(kucun是数据库名)
    String name="root";//连接mysql的用户名
    String pwd="123456";//连接mysql的密码
    try{
      Class.forName(driver);
      Connection conn=DriverManager.getConnection(url,name,pwd);//获取连接对象
      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")+"");
    }
  }
}

The above is the detailed content of Java method to detect success in connecting to mysql database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn