数据库连接问题(JDBC)

mysql数据库连接实例如下(filename: DBConnection.java)

//package package com.dengtao.dbc; 

//import sql package import java.sql.*;

 public class DBConnection {

   // 定义连接所需的各个字符串 

   String private DBDRIVER = "com.mysql.jdbc.Driver"; 

  String private DBURL = "jdbc:mysql://localhost/DBName? user=username&&password=password"; 

  String private Connection = null;

  //定义DBConnection的构造函数

  public DBConnection() {

     try {

         Class.forname(DBDRIVER);

         this.conn = DriverManager.getConnection(DBURL);

      }
      catch(Exception e) {
          e.printstrack();
      }
  }

 

public Connection getConnection() {
  return this.conn
}

 

public void close() {
   try {
       this.conn.close();
   }
   catch(Exception e) {
       e.printstrack():
   }
}

 在后面的使用中,只需要实例化该类即可,如

  DBConnection dbc = new DBConnection();