MySQL数据库连接测试程序

来源：互联网发布：js中字符串长度函数编辑：程序博客网时间：2024/05/21 04:01

MySQL数据库连接测试程序：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class MySQLConnTest {    public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";    public static final String DBURL = "jdbc:mysql://localhost:3306/dbname";    public static final String DBUSER = "root";    public static final String DBPASS = "admin";    public static void main(String[] args) {        Connection conn = null;        Statement stmt = null;        try {            Class.forName(DBDRIVER);            System.out.println("数据库驱动正确");            try {                conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);                System.out.println("数据库用户名密码正确");                stmt = conn.createStatement();                System.out.println("数据库连接正常");            } catch (Exception e) {                System.out.println("数据库用户名密码不正确");            }        } catch (Exception e) {            System.out.println("数据库驱动不正确");        }finally{            try {                stmt.close();            } catch (SQLException e) {                e.printStackTrace();            }            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }        }    }}

0 0