dbmanager.java

ajax 入门小例. 实现仿 google 自动提示.

/*************************************************
 @Copyright (C), 2008, lzpeng 
 @File name:      DBManager.java
 @Author:         lzpeng
 @CreateDate:     2008-6-28  
 *************************************************/
package cn.com.lzpeng.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;

import java.sql.ResultSet;

/**
 * 数据库访问控制类
 */
public class DBManager {
	private static String DRIVER = "com.mysql.jdbc.Driver";
	private static Connection conn = null;
	private static String URL = "jdbc:mysql://localhost:3306/suggestDB?user=root&password=root";

	/**
	 * Description : 取得数据库连接
	 * 
	 * @return conn Connection对象
	 * @exception Exception
	 */
	public static Connection getConn() throws Exception {
		Class.forName(DRIVER);
		conn = DriverManager.getConnection(URL);
		return conn;
	}

	/**
	 * Description :关闭数据库连接
	 * 
	 * @param rs 
	 *            ResultSet对象
	 * @param pstm
	 *            PreparedStatement对象
	 */
	public static void closeAll(ResultSet rs, PreparedStatement pstm,
			Connection conn) throws Exception {
		if (rs != null) {
			rs.close();
		}
		if (pstm != null) {
			pstm.close();
		}
		if (conn != null && !conn.isClosed()) {
			conn.close();
		}
	}

}