java web中常用的mysql连接数据库的语句

java web中，常用的mysql连接数库，除了需要配置好驱动程序，还有一点很重要的就是要经常会使用到这些语句：

import java.sql.Connection;

import java.sql.DriverManager;

public class DatabaseConnection{

private static final String DBDRIVER = "org.gjt.mm.mysql.Driver";

private static final String DBURL = "jdbc:mysql://localhost:3306/mldn";

private static final String DBUSER = "root";

private static final String DBPASSWORD = "mysqladmin";

private Connection conn = null;

public DatabaseConnection() throws Exception{

    try{

            Class.forName(DBDRIVER);

            this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);

         }catch(Exception e){

             throw e;

          }

     {

 public Connection getConnection(){

   return this conn;

 }

public void close() throws Exception{

   if (this.conn!=null){

       try{

              this.conn.close();

           }catch(Exception e){

              throw e;

        }

     }

   }

}