Java connection MySQL database instance code _java

Copy Code code as follows:

package Com.abc.dao;

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.ResultSet;
Import java.sql.SQLException;
Import java.sql.Statement;

Public class Basedao {
 public Connection getconn ()
 {
  Connection conn=null;
  try {
   class.forname ("Com.mysql.jdbc.Driver");
  catch (ClassNotFoundException e) {
  //TODO auto-generated catch block
   E.printsta Cktrace ();
 }
  String url= "Jdbc:mysql://127.0.0.1:3306/user";
  try {
   conn=drivermanager.getconnection (URL, "root", "");
  catch (SQLException e) {
  //TODO auto-generated catch block
   e.printstacktrace ();
 } 
  return conn
&NBSP}
 public void CloseAll (ResultSet rs,statement stat,connection conn)
 {
  if (rs!=null)
   try {
    rs.close ();
   catch (SQLException e) {
   //TODO auto-generated catch block
    E. Printstacktrace ();
  }
  if (stat!=null)
   try {
    stat.close ()
   catch (SQLException e) {
   //TODO auto-generated catch block
    E. Printstacktrace ();
  }
  if (conn!=null)
   try {
    conn.close ()
   catch (SQLException e) {
   //TODO auto-generated catch block
    E. Printstacktrace ();
  }
 }
}