MySQL Test link

public class Getconnectionmysql {public static Connection getconnection () {String driver= "com.mysql.jdbc.Driver"; Get the MySQL database driver class string url= "Jdbc:mysql://133.96.46.100:3306/test"; Connect the database (test is the database name) string name= "root";//Username string pwd= "root";//Connect MySQL password connection conn= null;try { Class.forName (driver);} catch (ClassNotFoundException E1) {System.out.println ("Driver load Failed"); E1.printstacktrace ();} Try{conn=drivermanager.getconnection (URL,NAME,PWD);//Get Connection object System.out.println ("Database successfully connected! "); return conn;} catch (SQLException e) {e.printstacktrace (); return null;} finally {if (conn!=null) {try {conn.close ();} catch (SQLException e) {e.printstacktrace ();}}}} 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=getconnectionmysql.getconnection ();}} 

　　

MySQL Test link