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();
}
}
}
}