excelreader.java

来自「可以运用该程序」· Java 代码 · 共 44 行

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 );
            		}
        	}
    	}
}