jdbctemplate.java

tapestry json 实现从数据库读取数据生成树

package com.xino.db;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * JDBC模板
 * 
 * @author 
 */
public abstract class JdbcTemplate {
	//private Log log = LogFactory.getLog(JdbcTemplate.class);

	/**
	 * 获取数据库连接
	 * 
	 * @return
	 */
	public Connection getConnection() {
		Connection conn = null;
		try {
			//conn = SpringUtil.getDataSource().getConnection();
			String driverName = "oracle.jdbc.driver.OracleDriver";
			String url = "jdbc:oracle:thin:@192.168.6.18:1521:xino";
			String user = "xinodrug_new";
			String passwd = "xinodrug_new";
			try {
				Class.forName(driverName);
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				//log.fatal("获取数据库驱动失败!");
			}
			conn = DriverManager.getConnection(url, user, passwd);
		} catch (SQLException e) {
			e.printStackTrace();
			//log.fatal("获取数据库连接失败！");
		}
		return conn;
	}

	public void closeConnection(Connection conn) {
		try {
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
			//log.fatal("数据库连接关闭失败！");
		}
	}

	public void rollback(Connection conn) {
		try {
			if (conn != null) {
				conn.rollback();
			}
		} catch (SQLException e) {
			e.printStackTrace();
			//log.fatal("数据库回滚失败！");
		}
	}

	public void closeResultset(ResultSet rs) {
		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
			//log.fatal("数据集ResultSet关闭失败!");
		}
	}
}