import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLDecoder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class Test {
private static final Logger logger = LoggerFactory.getLogger(FinanceCheckUtil.class);
/**
* 把sql文件中的sql语句读取出来
* @param sqlFileName
* @return
*/
@SuppressWarnings({ "deprecation", "unused" })
private static String getSql(String sqlFileName) {
String sqlFolderName = "aaa";
String FileName = "bbb";
sqlFileName = "sql" + File.separator + sqlFolderName + File.separator + FileName ;
String sql = null;
BufferedReader br = null;
InputStreamReader inputStreamReader = null;
InputStream is = null;
StringBuffer sb = null;
String text = null;
URL url = Test.class.getClassLoader().getResource(sqlFileName);//反射
try {
File file = new File(URLDecoder.decode(url.getFile()));
is = new FileInputStream(file);
inputStreamReader = new InputStreamReader(is, "UTF-8");
br = new BufferedReader(inputStreamReader);
sb = new StringBuffer();
while ((text=br.readLine()) != null) {
sb.append(text + "\n");
}
sql = sb.toString();
} catch (IOException e) {
logger.error("读取文件异常:" + sqlFileName + e.getMessage(), e);
} finally {
try {
br.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
inputStreamReader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return sql;
}
}
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLDecoder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class Test {
private static final Logger logger = LoggerFactory.getLogger(FinanceCheckUtil.class);
/**
* 把sql文件中的sql语句读取出来
* @param sqlFileName
* @return
*/
@SuppressWarnings({ "deprecation", "unused" })
private static String getSql(String sqlFileName) {
String sqlFolderName = "aaa";
String FileName = "bbb";
sqlFileName = "sql" + File.separator + sqlFolderName + File.separator + FileName ;
String sql = null;
BufferedReader br = null;
InputStreamReader inputStreamReader = null;
InputStream is = null;
StringBuffer sb = null;
String text = null;
URL url = Test.class.getClassLoader().getResource(sqlFileName);//反射
try {
File file = new File(URLDecoder.decode(url.getFile()));
is = new FileInputStream(file);
inputStreamReader = new InputStreamReader(is, "UTF-8");
br = new BufferedReader(inputStreamReader);
sb = new StringBuffer();
while ((text=br.readLine()) != null) {
sb.append(text + "\n");
}
sql = sb.toString();
} catch (IOException e) {
logger.error("读取文件异常:" + sqlFileName + e.getMessage(), e);
} finally {
try {
br.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
inputStreamReader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return sql;
}
}