Java EncodedResource.getReader方法代码示例

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
/**
 * Read a script from the given resource and build a String containing the lines.
 * @param resource the resource to be read
 * @return {@code String} containing the script lines
 * @throws IOException in case of I/O errors
 */
private String readScript(EncodedResource resource) throws IOException {
	LineNumberReader lnr = new LineNumberReader(resource.getReader());
	try {
		String currentStatement = lnr.readLine();
		StringBuilder scriptBuilder = new StringBuilder();
		while (currentStatement != null) {
			if (StringUtils.hasText(currentStatement) &&
					(this.commentPrefix != null && !currentStatement.startsWith(this.commentPrefix))) {
				if (scriptBuilder.length() > 0) {
					scriptBuilder.append('\n');
				}
				scriptBuilder.append(currentStatement);
			}
			currentStatement = lnr.readLine();
		}
		maybeAddSeparatorToScript(scriptBuilder);
		return scriptBuilder.toString();
	}
	finally {
		lnr.close();
	}
}
 

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
@Test
public void readAndSplitScriptContainingComments() throws Exception {

	EncodedResource resource = new EncodedResource(new ClassPathResource("test-data-with-comments.sql", getClass()));
	LineNumberReader lineNumberReader = new LineNumberReader(resource.getReader());

	String script = JdbcTestUtils.readScript(lineNumberReader);

	char delim = ';';
	List<String> statements = new ArrayList<String>();
	JdbcTestUtils.splitSqlScript(script, delim, statements);

	String statement1 = "insert into customer (id, name) values (1, 'Rod; Johnson'), (2, 'Adrian Collier')";
	String statement2 = "insert into orders(id, order_date, customer_id) values (1, '2008-01-02', 2)";
	String statement3 = "insert into orders(id, order_date, customer_id) values (1, '2008-01-02', 2)";
	// Statement 4 addresses the error described in SPR-9982.
	String statement4 = "INSERT INTO persons( person_id , name) VALUES( 1 , 'Name' )";

	assertEquals("wrong number of statements", 4, statements.size());
	assertEquals("statement 1 not split correctly", statement1, statements.get(0));
	assertEquals("statement 2 not split correctly", statement2, statements.get(1));
	assertEquals("statement 3 not split correctly", statement3, statements.get(2));
	assertEquals("statement 4 not split correctly", statement4, statements.get(3));
}
 

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
private static String readScript(Resource resource) throws IOException {
	EncodedResource encoded = resource instanceof EncodedResource ? (EncodedResource) resource : new EncodedResource(resource);
	LineNumberReader lnr = new LineNumberReader(encoded.getReader());
	String currentStatement = lnr.readLine();
	StringBuilder scriptBuilder = new StringBuilder();
	while (currentStatement != null) {
		if (StringUtils.hasText(currentStatement) && (SQL_COMMENT_PREFIX != null && !currentStatement.startsWith(SQL_COMMENT_PREFIX))) {
			if (scriptBuilder.length() > 0) {
				scriptBuilder.append('\n');
			}
			scriptBuilder.append(currentStatement);
		}
		currentStatement = lnr.readLine();
	}
	return scriptBuilder.toString();
}
 

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
/**
 * Read a script from the provided resource, using the supplied comment prefix
 * and statement separator, and build a {@code String} containing the lines.
 * <p>Lines <em>beginning</em> with the comment prefix are excluded from the
 * results; however, line comments anywhere else &mdash; for example, within
 * a statement &mdash; will be included in the results.
 * @param resource the {@code EncodedResource} containing the script
 * to be processed
 * @param commentPrefix the prefix that identifies comments in the SQL script &mdash;
 * typically "--"
 * @param separator the statement separator in the SQL script &mdash; typically ";"
 * @return a {@code String} containing the script lines
 * @throws IOException in case of I/O errors
 */
private static String readScript(EncodedResource resource, String commentPrefix, String separator)
		throws IOException {
	LineNumberReader lnr = new LineNumberReader(resource.getReader());
	try {
		return readScript(lnr, commentPrefix, separator);
	}
	finally {
		lnr.close();
	}
}
 

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
/**
 * Read a script from the provided resource, using the supplied comment prefix
 * and statement separator, and build a {@code String} containing the lines.
 * <p>Lines <em>beginning</em> with the comment prefix are excluded from the
 * results; however, line comments anywhere else &mdash; for example, within
 * a statement &mdash; will be included in the results.
 * @param resource the {@code EncodedResource} containing the script
 * to be processed
 * @param commentPrefix the prefix that identifies comments in the SQL script &mdash;
 * typically "--"
 * @param separator the statement separator in the SQL script &mdash; typically ";"
 * @return a {@code String} containing the script lines
 * @throws IOException in case of I/O errors
 */
private static String readScript(EncodedResource resource, String commentPrefix, String separator)
		throws IOException {

	LineNumberReader lnr = new LineNumberReader(resource.getReader());
	try {
		return readScript(lnr, commentPrefix, separator);
	}
	finally {
		lnr.close();
	}
}
 

import org.springframework.core.io.support.EncodedResource; //导入方法依赖的package包/类
/**
 * Read a script from the provided resource, using the supplied comment prefix
 * and statement separator, and build a {@code String} containing the lines.
 * <p>Lines <em>beginning</em> with the comment prefix are excluded from the
 * results; however, line comments anywhere else &mdash; for example, within
 * a statement &mdash; will be included in the results.
 *
 * @param resource      the {@code EncodedResource} containing the script
 *                      to be processed
 * @param commentPrefix the prefix that identifies comments in the SQL script &mdash;
 *                      typically "--"
 * @param separator     the statement separator in the SQL script &mdash; typically ";"
 * @return a {@code String} containing the script lines
 * @throws IOException in case of I/O errors
 */
private static String readScript(EncodedResource resource, String commentPrefix, String separator)
        throws IOException {
    LineNumberReader lnr = new LineNumberReader(resource.getReader());
    try {
        return readScript(lnr, commentPrefix, separator);
    } finally {
        lnr.close();
    }
}