Utility Class For Getting SQL Connection and Closing It

The following is a sample class which you can use as an utility in getting the mysql connections
and closing it (rather than writing the same code again and again to get and close the connection)

/* @author Kushal Paudyal*/
package com.ghumti.kschool.core.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import com.ghumti.fw.domain.KSEntity;

public class KSDBConnection extends KSEntity {
	private String dbUserName = "root";
	private String dbPassword = "";
	private String dbURL = "jdbc:mysql://localhost:3306/";
	private String database = "kschool";
	private String driver = "com.mysql.jdbc.Driver";

	public Connection getConnection() {
		Connection conn = null;
		try {
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(getDbURL() + getDatabase(),
					getDbUserName(), getDbPassword());

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			return conn;
		}

	}

	public void closeConnection(Connection dbConnection, String className) {
		try {
			dbConnection.close();
		} catch (SQLException e1) {
			System.out.println(className
					+ ": Could not close database connection");
			e1.printStackTrace();
		}

	}

	/*
	 * Usage Example
	 */
	public static void main(String args[]) throws Exception {
		KSDBConnection ksdb = new KSDBConnection();
		Connection conn = ksdb.getConnection();

		String sqlQuery = "Select * from myTable";
		Statement st = conn.createStatement();
		st.execute(sqlQuery);

		/*
		 * Finally Close the connection The second parameter is just used for
		 * error printing
		 */
		ksdb.closeConnection(conn, KSDBConnection.class.getName());

	}

}

  1. How to extract plain Text from HTML Website easily in Java
  2. How To Find What Java Version You Are Using?
  3. Computing the total, free and usable disk space easily using JDK 1.6
  4. Creating java.util.date and java.util.sql objects from Calendar object
  5. Bar Code Generation In Java Using iText API
  6. Simple Tag Generator In Java For Music Blogs
  7. Tutorial on Converting an List of Strings or Numbers to a CSV file with optional sorting
  8. Calling URL Browser From Java Application
  9. Java Reflection Tutorial – List Methods Of A Class
  10. Cleaning Punctuation And White Spaces From A String
  11. Java Tutorial – Using JCIFS to copy files to shared network drive using username and password
  12. Prime Number Finder In Java
  13. How to setup and run the Microsoft’s Command Line BCP Utility Without Installing SQL Server Client?
  14. Utility Class For Getting SQL Connection and Closing It
  15. Dropping Stored Procedure and Granting Execute Permission
  16. Finding MAX length of the data in DB column
  17. SQL – How To Find The Physical Location Of MySQL Database (Data Location)
  18. Quick SQL Reference – Find Duplicate Data In A Table Using Having Clause
  19. Java Design Pattern – Singleton Pattern
  20. Reading / Writing File in Java and String Manipulation
  21. How to capture a screenshot using Java and save it to a file?
  22. Calculating The Difference Between Two Dates In Terms of Months
  23. 005: MySQL – Selecting a set of random rows from a table
  24. SQL – Finding Nth Highest Row In DB Table
  25. Getting The Name Of Currently Logged In User In The System
  26. How To Set And Get System Clipboard Contents In Java
  27. RGB To Hex and Hex To RGB Conversion Using Java and Regular Expressions
  28. Generating Nepali Unicode Sequence For Characters
  29. Java Tool To Compare Two Lists and Spit Out The Differences – Working Example
  30. Replacing non-ASCII characters using Java Regular Expressions
  31. SQL – How To Retrieve Data With Maximum Length?
  32. Calculating Folder Size In Java
Tagged , , , , , , , , . Bookmark the permalink.

3 Responses to Calculating Folder Size In Java

  1. Pingback: Sanjaal.com » Latest Updates

  2. Jamie says:

    This approach uses less memory:

    public static class SizeCounter implements FileFilter
    {
    private long total = 0;
    public SizeCounter(){};
    public boolean accept(File pathname) {
    if ( pathname.isFile()) {
    total+=pathname.length();
    } else {
    pathname.listFiles(this);
    }
    return false;
    }
    public long getTotal()
    {
    return total;
    }
    }

    private static long getFileOrDirectorySize(File file) {
    SizeCounter counter = new SizeCounter();
    file.listFiles(counter);
    return counter.getTotal();
    }

  3. kushalzone says:

    Thank you Jamie for your optimized solution.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.