Java connection to MySQL

 PackageDBHelper;ImportJava.sql.*;  Public classDemo { Public Static voidMain (string[] args) {String driver= "Com.mysql.jdbc.Driver"; String DbName= "Test"; String Passwrod= "Root"; String UserName= "Root"; String URL= "jdbc:mysql://localhost:3306/" +DbName; String SQL= "SELECT * FROM Test"; Try{class.forname (driver); Connection Conn=drivermanager.getconnection (URL, userName, passwrod); PreparedStatement PS=conn.preparestatement (SQL); ResultSet RS=Ps.executequery ();  while(Rs.next ()) {System.out.println ("ID:" + rs.getint (1) + "Name:" + rs.getstring (2) ); }             //To close a record set            if(rs! =NULL) {                Try{rs.close (); } Catch(SQLException e) {e.printstacktrace (); }            }             //Close Declaration            if(PS! =NULL) {                Try{ps.close (); } Catch(SQLException e) {e.printstacktrace (); }            }             //Close linked Objects            if(Conn! =NULL) {                Try{conn.close (); } Catch(SQLException e) {e.printstacktrace (); }            }         } Catch(Exception e) {e.printstacktrace (); }    } }

Java connection to MySQL