使用org.springframework.jdbc.support.JdbcUtils关闭数据库链接

218 阅读1分钟

参考KmImeetingReadTakeServiceImp

import org.springframework.jdbc.support.JdbcUtils;
public void meetingChange(){
    Connection conn=null;
    Connection updateConn=null;
    PreparedStatement st=null;
    PrearedStatement updateSt=null;
    ResultSet rs =null;
    String sql="";
    String updateSql="";
    
    try{
        conn = (Connection) ConnectionProviderUtil.getConnection(getConnectionParam());
        sql = "select 字段 from 表 where 条件";
        st = conn.prepareStatement(sql);
        rs = st.executeQuery();
        while(rs.next()){//更新批处理
            
        }
        
    }catch(Exception e){
        e.printStackTrace();
    }finally{
        JdbcUtils.closeResultSet(rs);
        JdbcUtils.closeStatement(st);
        JdbcUtils.closeConnection(conn);
    } 
}