1 package com.student.dbc ; 2 import java.sql.* ; 3 public class DatabaseConnection { 4     private static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;//mysql驱动 5      private static final String DBURL = "jdbc:mysql://localhost:3306/java_web?useUnicode=true&characterEncoding=UTF-8" ;//数据库地址 6     private static final String DBUSER = "root" ;//数据库用户名 7     private static final String DBPASSWORD = "root" ;//数据库密码 8     private Connection conn = null ; 9     public DatabaseConnection() throws Exception{10         try{11             Class.forName(DBDRIVER) ;12             this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;13         }catch(Exception e){14             throw e ;15         }16     }17     public Connection getConnection(){18         return this.conn ;19     }20     public void close() throws Exception{21         if(this.conn != null){22             try{23                 this.conn.close() ;24             }catch(Exception e){25                 throw e ;26             }27         }28     }29 }