【Java开源代码栏目提醒】:网学会员Java开源代码为您提供AreaDao.java参考,解决您在AreaDao.java学习中工作中的难题,参考学习。
package com.dao;
import com.tool.JDBConnection;
import java.util.*;
import java.sql.*;
import com.domain.AreaVO;
public class AreaDao {
private JDBConnection connection = null;
List list = null;
public AreaDao() {
connection = new JDBConnection();
this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
}
public List areaSelectProvicne() {
list = new ArrayList();
AreaVO area = null;
String sql = "select csxx_sfmc from tb_area group by csxx_sfmc";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
area = new AreaVO();
area.setCsxx_sfmc(rs.getString("csxx_sfmc"));
list.add(area);
}
}
catch (SQLException ex) {
}
connection.closeConnection();
return list;
}
public List listProvicne() {
list = new ArrayList();
AreaVO area = null;
String sql = "select csxx_csjc,csxx_sfmc from tb_area group by csxx_sfmc,csxx_csjc";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
area = new AreaVO();
area.setCsxx_csjc(rs.getString("csxx_csjc"));
area.setCsxx_sfmc(rs.getString("csxx_sfmc"));
list.add(area);
}
}
catch (SQLException ex) {
}
connection.closeConnection();
return list;
}
public List areaSelectCity(String provicne) {
list = new ArrayList();
AreaVO area = null;
String sql = "select csxx_csmc from tb_area where csxx_sfmc='"+provicne+"'";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
area = new AreaVO();
area.setCsxx_csmc(rs.getString("csxx_csmc"));
list.add(area);
}
}
catch (SQLException ex) {
}
connection.closeConnection();
return list;
}
public List areaCity(String provicne) {
list = new ArrayList();
AreaVO area = null;
String sql = "select * from tb_area where csxx_sfmc='"+provicne+"'";
ResultSet rs = connection.executeQuery(sql);
try {
while (rs.next()) {
area = new AreaVO();
area.setCsxx_csjc(rs.getString("csxx_csjc"));
area.setCsxx_sfmc(rs.getString("csxx_sfmc"));
area.setCsxx_csmc(rs.getString("csxx_csmc"));
area.setCsxx_yb(rs.getString("csxx_yb"));
area.setCsxx_dhqh(rs.getString("csxx_dhqh"));
list.add(area);
}
}
catch (SQLException ex) {
}
connection.closeConnection();
return list;
}
}
上一篇:
AreaCollectRow.java
下一篇:
让我掉下眼泪的