Java Connection MySQL Database

Import Mysql-connector-java-5.1.21-bin.jar before connecting

1  PackageCom.student.dbc;2 ImportJava.sql.* ;3  Public classDatabaseConnection {4     Private Static FinalString dbdriver = "Org.gjt.mm.mysql.Driver";//mysql Drive5      Private Static FinalString Dburl = "Jdbc:mysql://localhost:3306/java_web?useunicode=true&characterencoding=utf-8";//Database address6     Private Static FinalString DBUSER = "root";//database user name7     Private Static FinalString Dbpassword = "root";//Database Password8     PrivateConnection conn =NULL ;9      PublicDatabaseConnection ()throwsexception{Ten         Try{ One Class.forName (dbdriver); A              This. conn =drivermanager.getconnection (Dburl,dbuser,dbpassword); -}Catch(Exception e) { -             Throwe; the         } -     } -      PublicConnection getconnection () { -         return  This. Conn; +     } -      Public voidClose ()throwsexception{ +         if( This. conn! =NULL){ A             Try{ at                  This. Conn.close (); -}Catch(Exception e) { -                 Throwe; -             } -         } -     } in}

Java Connection MySQL Database