connectionmanager.java

JSP初学者

package xinwen;
import java.sql.*;

public class ConnectionManager {

	private static final String DRIVER_CLASS = "sun.jdbc.odbc.JdbcOdbcDriver";
	private static final String DATABASE_URL = "jdbc:odbc:xinwen";
	private static final String DATABASE_USRE = "yu";
	private static final String DATABASE_PASSWORD = "yu";

	/**
	 * 杩斿洖杩炴帴
	 *
	 * @return Connection
	 */
	public static Connection getConnection() {
		Connection dbConnection = null;
		try {
			Class.forName(DRIVER_CLASS);
			dbConnection = DriverManager.getConnection(DATABASE_URL,
					DATABASE_USRE, DATABASE_PASSWORD);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return dbConnection;
	}

	/**
	 * 鍏抽棴杩炴帴
	 *
	 * @param dbConnection
	 *            Connection
	 */
	public static void closeConnection(Connection dbConnection) {
		try {
			if (dbConnection != null && (!dbConnection.isClosed())) {
				dbConnection.close();
			}
		} catch (SQLException sqlEx) {
			sqlEx.printStackTrace();
		}

	}

	/**
	 * 鍏抽棴缁撴灉闆