areadao.java

来自「该代码是一个销售管理系统的源代码」· Java 代码 · 共 93 行

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;
  }
}