com.me.DAO.DAO1.java Source code

Introduction

Here is the source code for com.me.DAO.DAO1.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.me.DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;

/**
 *
 * @author pranalinarkar
 */
public class DAO1 {
    private String driver;
    private String dburl;
    private String dbuser;
    private String dbpassword;

    public DAO1() {
        driver = "com.mysql.jdbc.Driver";
        dburl = "jdbc:mysql://localhost:3306/moviedb";
        dbuser = "root";
        dbpassword = "Windows@123";

        DbUtils.loadDriver(driver);
    }

    public Connection getConnection() {
        Connection conn = null;
        try {
            conn = DriverManager.getConnection(dburl, dbuser, dbpassword);

        } catch (SQLException ex) {
            Logger.getLogger(DAO1.class.getName()).log(Level.SEVERE, null, ex);
        }
        return conn;
    }

    public void close(Connection connection) {
        if (connection != null) {
            try {
                DbUtils.close(connection);
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}