Java web 之mysql连接

package com.gaozhen.dbutils;


import java.sql.DriverManager;
import java.sql.SQLException;


import javax.servlet.jsp.tagext.TryCatchFinally;


import com.mysql.jdbc.Connection;




public class Conn {
 static Connection cn=null;
public static Connection getConnection(){
 
 try{
  Class.forName("com.mysql.jdbc.Driver").newInstance();
 }
 catch(Exception e){
  System.out.print(e.toString());
 }
 try{
  String url="jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8";
  String user="root";
  String password="root";
  cn=(Connection) DriverManager.getConnection(url,user,password);
 }
 catch(SQLException e){
  System.out.print(e.toString());
 }
 return cn;
}
public void close()throws Exception{  
       if(cn!=null){  
           cn.close();  
       }  
   }  


}