一直显示语法错误,将“}”插入到完整 Block 中 语法错误,将“}”插入到完整 Block 中 语法错误,将“}”插入到完整 Block 中 语法错误
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class ExcelReader
{
public static void main( String [] args )
{
Connection c = null;
Statement stmnt = null;
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc:Book1", "", "" );
stmnt = c.createStatement();
String query = "SELECT test1 FROM [Sheet1$] WHERE test1='测试'";
ResultSet rs = stmnt.executeQuery( query );
System.out.println( "查得匹配'测试'的test1的记录为:" );
while( rs.next() )
{
System.out.println( rs.getString( "test1" ) );
}
}
catch( Exception e )
{
System.err.println( e );
}
finally
{
try {
stmnt.close();
c.close();
}
catch( Exception e )
{
System.err.println(e);
}
}
}
}