MySql连接数据库常用参数及代码解读

package util;

import Java.sql.Connection;
import java.sql.DriverManager;


public class DbUtil {

 private String dbUrl="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true";
 private String dbUserName="root";
 private String dbPassword="passwd";
 private String jdbcName="com.mysql.jdbc.Driver";
 
 
 public Connection getCon() throws Exception{
  Class.forName(jdbcName);
  Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword);
  return con;
 }
 
 
 public void closeCon(Connection con) throws Exception{
  if(con!=null){
   con.close();
  }
 }
 
 public static void main(String[] args) {
  DbUtil dbUtil=new DbUtil();
  try {
   dbUtil.getCon();
   System.out.println("数据库连接成功");
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
}

 Connection con=null;
 try{
   con=dbUtil.getCon();
   （数据库操作语句）
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   try {
    dbUtil.closeCon(con);
   } catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }