小型Java Web项目之DatabaseConnection

做JavaWeb项目必然离不开数据库，这里使用的是MySQL数据库进行开发。具体链接类如下：

package dbc;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.*;


public class DatabaseConnection {
    private static final String driver = "com.mysql.jdbc.Driver";
    private static final String url = "jdbc:mysql://localhost:3306/myproject?characterEncoding=utf8&useSSL=true";
    private static final String user = "**";
    //这里写上用户名
    private static final String password = "**";
    //这里写上密码
    private Connection conn = null;
    public DatabaseConnection() throws SQLException{
        try {
            Class.forName(driver);
            this.conn = DriverManager.getConnection(url, user, password);   
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public Connection getConn() {
        return this.conn;
    }
    public void close(){
        if(this.conn != null){
            try {
                this.conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

数据库的连接还是比较容易的，但也应该很熟练。