测试b3log的查询方法

DROP TABLE IF EXISTS `aircraft`;CREATE TABLE `aircraft` (  `AircraftID` smallint(4) unsigned NOT NULL AUTO_INCREMENT,  `AircraftTypeID` smallint(4) unsigned NOT NULL,  `RegNum` char(6) NOT NULL,  `LastMaintEnd` date NOT NULL,  `NextMaintBegin` date NOT NULL,  `NextMaintEnd` date NOT NULL,  PRIMARY KEY (`AircraftID`),  UNIQUE KEY `RegNum` (`RegNum`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8;---- Dumping data for table `aircraft`--INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3451, 503, 'ZX6488', '2007-10-01', '2008-10-23', '2008-10-31');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3465, 503, 'ZX5373', '0000-00-00', '2008-10-14', '2008-10-21');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3467, 616, 'ZX7283', '2008-02-05', '2008-12-02', '2008-10-09');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3452, 617, 'ZX5464', '2006-10-04', '2009-01-03', '2009-01-21');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3469, 616, 'ZX5382', '2008-04-16', '2009-04-08', '2009-04-18');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3145, 503, 'ZX5731', '2008-04-17', '2009-12-20', '2009-12-30');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3425, 504, 'ZX6821', '2008-06-22', '2009-05-25', '2009-06-04');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3427, 616, 'ZX5921', '2008-10-01', '2010-03-02', '2010-04-02');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3189, 616, 'ZX582', '2008-08-07', '2008-11-05', '2008-11-12');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3470, 616, 'ZX5173', '2008-05-20', '2009-10-05', '2009-10-15');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3125, 617, 'ZX1386', '2007-12-12', '2009-02-01', '2009-02-22');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3128, 617, 'ZX7634', '2008-03-07', '2009-05-07', '2009-05-18');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3565, 503, 'ZX5830', '2008-11-19', '2009-11-15', '2009-12-15');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3201, 617, 'ZX7472', '2008-10-15', '2009-10-15', '2009-10-27');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3223, 618, 'ZX1037', '2008-12-06', '2009-09-16', '2009-09-30');INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3130, 616, 'ZX7391', '2008-09-15', '2009-04-15', '2009-05-15');

import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import org.b3log.latke.Latkes;import org.b3log.latke.repository.jdbc.JdbcFactory;import org.b3log.latke.repository.jdbc.AbstractJdbcDatabaseSolution;import org.b3log.latke.repository.jdbc.util.Connections;//import com.mysql.jdbc.Connection;import java.sql.Connection;public class test_queryPage { /**     * the holder of the databaseSolution.     */    private static AbstractJdbcDatabaseSolution databaseSolution;        public static boolean executeSql(final String sql, final Connection connection) throws SQLException {        //LOGGER.log(Level.FINEST, "executeSql: {0}", sql);        final Statement statement = connection.createStatement();        ResultSet rs;        System.out.println("刘利新test_query");        System.out.println(sql);        rs=statement.executeQuery(sql);        while(rs.next()){System.out.println(rs.getString("RegNum"));}        final boolean isSuccess = !statement.execute(sql);        statement.close();        return isSuccess;    }  /** * @param args * @throws SQLException  */public static void main(String[] args) throws SQLException {// TODO Auto-generated method stubLatkes.initRuntimeEnv();final Connection connection = Connections.getConnection();/*try {            databaseSolution = (AbstractJdbcDatabaseSolution) Class.forName("org.b3log.latke.repository.mysql.MysqlJdbcDatabaseSolution").newInstance();            String mySQL2=databaseSolution.getRandomlySql("aircraft",5);            System.out.println(mySQL2);            mySQL2="select * from aircraft";            boolean ka=JdbcUtil.executeSql(mySQL2, connection);            System.out.println(ka);                    } catch (final Exception e) {                    }finally {            connection.close();        }*/JdbcFactory aProduct=JdbcFactory.createJdbcFactory();try {String mySQL3=aProduct.getRandomlySql("aircraft", 5);System.out.println(mySQL3);//mySQL3="select * from aircraft";boolean ka=executeSql(mySQL3, connection);            System.out.println(ka);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {            connection.close();        }}}

输出：

SELECT * FROM aircraft ORDER BY RAND() LIMIT 5
刘利新test_query
select * from aircraft
ZX5373
ZX7283
ZX5464
ZX5382
ZX5731
ZX6821
ZX5921
ZX582
ZX5173
ZX1386
ZX7634
ZX5830
ZX7472
ZX1037
ZX7391
false

order by rand()是一种随机查询

源代码：http://pan.baidu.com/share/link?shareid=473253822&uk=3878681452