connectdbutil.java

简单的流言板系统,用myeclipse进行编写的,采用简单的jstl+javabean+servlet+jsp,属于三层架构.

package me.work.utils;

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

public final class ConnectDBUtil {

	/**
	 * this method provides a connection to DB
	 * 
	 * @throws ClassNotFoundException
	 *             when cannot load jdbcodbcdriver
	 * @throws SQLException
	 */
	public static final Connection getConnection()
			throws ClassNotFoundException, SQLException {
		// load the JdbcOdbcDriver
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		// get a connection
		return DriverManager.getConnection("jdbc:odbc:forum", "sa", "");

	}

	/**
	 * close sql connection
	 * 
	 * @param con
	 *            connection to close
	 * @throws SQLException
	 */
	public static final void closeConnection(Connection con)
			throws SQLException {
		if (con != null) {
			con.close();
		}
	}
}