wanghuanqiufly的专栏

DB2:SELECT agent_id,table_name FROM TABLE (SNAPSHOT_LOCK('EBANK',-1)) AS LOCK where table_name is not nullFORCE APPLICATION(agent_id);SQLServer:select request_session_id spid, OBJECT_N...

将数据库中存储的二进制转换为本地文件，前提需要知道文件类型Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); File file = new File("ff."+filetype); OutputStream output = new FileOutputStream(fil...

List columnNameList = new ArrayList(); ResultSet rs = conn.getMetaData().getColumns(null, null, tableName, "%"); while(rs.next()) { columnNameList.add(...