jdbcutil.java

一个前台基于AJAX

package com.demo2.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * 
 * @author liumei
 *  数据库操作
 */
public class JdbcUtil {
	/**
	 * 获取连接
	 * @return
	 */
	public static Connection getConnection() {
		Connection conn = null;
		try {
			Class.forName(Constants.DRIVER_CLASS);
			conn = DriverManager.getConnection(Constants.DB_URL,
					Constants.DB_USER, Constants.DB_PWD);

		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
/**
 *  关闭连接
 * @param conn
 */

	public static void closeConnection(Connection conn) {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
/**
 * 回滚
 * @param conn
 */
	public static void rollback(Connection conn) {
		try {
			conn.rollback();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}