jdbctemplate.java

一个较简单的论坛——中国精英论坛,是我的一个练习

package com.common;
//jdbc操作模板，由方法传入连接对象，由hibernate控制事务
import java.sql.*;
public class JDBCTemplate {
	public void query(String sql,Handler handler,Connection conn){
		try{
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);
			if(handler!=null)
				handler.handler(rs);
			rs.close();
			stmt.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public void query(String sql,PreparedStatementSetter setter,Handler handler,Connection conn){
		try{
			PreparedStatement pstmt=conn.prepareStatement(sql);
			if(setter!=null)
				setter.setter(pstmt);
			ResultSet rs=pstmt.executeQuery();
			if(handler!=null)
				handler.handler(rs);
			rs.close();
			pstmt.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public void execute(String sql,PreparedStatementSetter setter,Connection conn){
		try{
			PreparedStatement pstmt=conn.prepareStatement(sql);
			if(setter!=null)
				setter.setter(pstmt);
			pstmt.execute();
			pstmt.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}