?? 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(); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -