package org.sosostudio.dbunifier.test;
import org.sosostudio.dbunifier.DbUnifier;
import org.sosostudio.dbunifier.Row;
import org.sosostudio.dbunifier.RowSet;
import org.sosostudio.dbunifier.dbsource.DbSource;
import org.sosostudio.dbunifier.dbsource.JdbcDbSource;
import org.sosostudio.dbunifier.oom.Direction;
import org.sosostudio.dbunifier.oom.OrderByClause;
import org.sosostudio.dbunifier.oom.SelectSql;
public class Sample {
public static void main(String[] args) {
DbSource dbSource = new JdbcDbSource("com.mysql.jdbc.Driver",
"jdbc:mysql://localhost:3306/test", "root", "password");
DbUnifier unifier = new DbUnifier(dbSource);
SelectSql selectSql = new SelectSql()
.setTableName("CS_USER")
.setColumns("*")
.setOrderByClause(
new OrderByClause().addOrder("USERNAME", Direction.ASC));
RowSet rowSet = unifier.executeSelectSql(selectSql, 3, 2);
for (int i = 0; i < rowSet.size(); i++) {
Row row = rowSet.getRow(i);
String username = row.getString("USERNAME");
System.out.println(username);
}
}
}
转载于:https://my.oschina.net/u/1765218/blog/266260