package com.zxc.connection; import java.sql.Connection; import java.sql.DriverManager; public class DBConnection { public static final String name="com.mysql.jdbc.Driver";//jdbc驱动名 public static final String url="jdbc:mysql://127.0.0.1/bz";//数据库的url,改变bz可以改变数据库 public static final String user="root";//mysql用户名 public static final String password="root";//mysql密码 public Connection con=null; public DBConnection(){ //数据库连接类的构造器,当实例化DBConnection类时,自动连接数据库 try { Class.forName(name); System.out.println("数据库连接类加载成功"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.println("数据库连接类加载失败"); } try { con=DriverManager.getConnection(url,user,password); System.out.println("数据库连接成功"); } catch (Exception e) { // TODO Auto-generated catch block System.out.println("数据库连接失败"); } } public void DBClose(){ //数据库关闭方法,需要调用。 try { con.close(); System.out.println("数据库关闭成功"); } catch (Exception e) { // TODO Auto-generated catch block System.out.println("数据库关闭失败"); } } }