java method to connect to the mysql database and test whether the connection was successful
- 2020-09-16 07:30:25
- OfStack
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.