十行代码测试连接数据库

因为项目在多和环境多个数据库中执行,项目代码连接数据库不成功,所以想做个简单的工具,单纯测试数据库是否能连接成功,以确认数据库网络是不是畅通.

编辑TestJdbc.java文件

import java.sql.Connection;
import java.sql.DriverManager;

public class TestJdbc{
    public static void main(String[] args) {
        String driverName = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false";
        String username = "root";
        String password = "root";

        try {
            Class.forName(driverName);
            Connection conn = DriverManager.getConnection(url,
                    username, password);
            conn.close();
            System.out.println("connect success!\nurl:"+url+"\nusername:"+username
                +"\npassword:"+password+"\ndriverName:"+driverName);
        } catch (Exception e) {
            System.out.println("connect fail!\nurl:"+url+"\nusername:"+username
                +"\npassword:"+password+"\ndriverName:"+driverName);
            e.printStackTrace();
        }
    }
}

或者核心代码(10行)

import java.sql.Connection;
import java.sql.DriverManager;

public class TestJdbc{
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false",
                "root", "root");
        conn.close();
    }
}

将数据库连接驱动mysql-connector-java-5.1.46.jar放在TestJdbc.java所在的目录下

在此目录打开cmd命令框,编译代码

javac TestJdbc.java

然后在cmd中运行代码

java -cp mysql-connector-java-5.1.46.jar;. TestJdbc

显示下面信息则表示连接数据库成功

connect success!
url:jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false
username:root
password:root
driverName:com.mysql.jdbc.Driver

也可以编辑run.bat快捷测试

javac TestJdbc.java
java -cp mysql-connector-java-5.1.46.jar;. TestJdbc
pause

需要测试其他的数据库,只需更换数据库驱动jar和数据库配置即可.