java导出oracle数据(单表).pdf

package com.sync.util; import java.io.BufferedReader; import java.io.InputStreamReader; import mons.logging.Log; import mons.logging.LogFactory; import com.metinform.util.StringUtil; import com.sync.hbm.SyncOrigtab; import com.sync.hbm.SyncTargtab; import com.sync.init.ServiceDao; import com.sync.init.SyncThreadDao; public class SyncExpImpUtil { private static Log log = LogFactory.getLog(SyncExpImpUtil.class); /** * 导出 * @param userName 数据库用户名 * @param passWor 数据库密码 * @param dataBaseName 数据库名 * @param tabName 表名 * @param a ress 导出地址 * @param where 数据过滤条件 */ public static boolean exp(String userName,String passWord,String dataBaseName,String tabName,String a ress,String where){ boolean bool = false; // 拼装DOS 命令进行数据库备份 StringBuffer exp = new StringBuffer(exp ); exp.append(userName); exp.append(/); exp.append(passWord); exp.append(@); exp.append(dataBaseName); exp.append( TRIGGERS=N ); if(StringUtil.isNotEmpty(tabName)){ exp.append( tables=); exp.append(tabName); } exp.append( file=); exp.append(a ress); if(StringUtil.isNotEmpty(where)){ exp.append( query=\\\where ); exp.append(where); exp.append( \\\ ); } try { (exp.toString()); //System.out.println(exp.toString()); Process p = Runtime.getRuntime().exec(exp.toString()); InputStreamReader isr = new InputStreamReader(p.getErrorStream()); BufferedReader br = new BufferedReader(isr); String line = null; while ((line = br.readLine()) != null){ if(line.indexOf(错 )!=-1){ break; } } p.destroy(); p.waitFor(); bool = true; } catc