数据表格如下:
要求统计出各省,县,镇的人口
第一步:把数据写入数据库
第2步,取得所有的非重复的镇
SELECT province, states, town
FROM population
GROUP BY province, states, town
第3步,循环所有的镇
String sql = "";
for(int i=0;i<states.length;i++)
{
sql = "select * from population where province =? and states = ? and town = ?",states[1],states[2],states[3];
List result = exex(sql);
for(int j=0;j<result.size();j++)
{
//完全列出
}
sql = "select town,count(t_number) from population where province =? and states = ? and town = ?",states[1],states[2],states[3];
List result2 = exce(sql);
for(int k =0;k<result2.size();k++)
{
//完全显示
}
}