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();		}	}}