随着数据量的增大,oracle的查询速度就有点捉襟见肘,这个时候我们需要把数据从oracle数据库导入到hbase,然后使用hbase进行查询数据。
废话不多说,直接上代码.
public class Getdata {
private static Connection conn;
private static Statement st;
private ResultSet rs;
static {
conn = Getconn.getConntection();
try {
st = conn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public List<Cfmx> getCfmxInfo(String tableName, int pagebegin, int pageEnd) {
String sql = "select id, ghdjid, xmmc, xmdm, je, sl, gg, cfrq, jx from (select rownum rn, id, ghdjid, xmmc, xmdm, je, sl, gg, cfrq, jx from "
+ tableName
+ " where rownum<"
+ pageEnd
+ ") s where s.rn >"
+ pagebegin;
System.out.println(sql);
List<Cfmx> list = new ArrayList<Cfmx>();
try {
rs = st.executeQuery(sql);
int count = 0;
while (rs.next()) {
Cfmx c = new Cfmx();
c.setId(String.valueOf(rs.getDouble(1)));
c.setGhdjid(rs.getString(2));
c.setXmmc(rs.getString(3));
c.setXmdm(rs.getString(4));
c.setJe(rs.getString(5));
c.setSl(rs.getString(6));
c.setGg(rs.getString(7));
c.setCfrq(rs.getString(8));
c.setJx(rs.getString(9));
// c.setJgdj(rs.getString(10));
// c.setJgid(rs.getString(11));
list.add(c);
count++;
}
System.out.println("共导出" + count + "条数据");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
}
public clas