zipcodedao.java

用Ajax技术实现一个邮政编码查找的功能.

package com.accp.xdj.zipcode.server.dao;

import java.sql.*;
import com.ConnectionManage;

public class ZipCodeDAO {
  public String getAreaInfo(String code) {
    String areaInfo = null;
    //定义查询数据库的SQL语句
    String sql = "select * from zipcode where code = ?";
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
      conn = ConnectionManage.getConnection();
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, code);
      rs = pstmt.executeQuery();
      if (rs.next()) {
        areaInfo = rs.getString("area") + "|" + rs.getString("city");
        System.out.println(code);
      }
      else {
        //如果没有查询到地区信息，取邮编前4位补“00”继续查询
        pstmt.setString(1, code.substring(0, 4) + "00");
        rs = pstmt.executeQuery();
        if (rs.next()) {
          areaInfo = rs.getString("area") + "|" + rs.getString("city");
        }
      }
    }
    catch (SQLException e) {
      System.out.println(e.toString());
    }
    finally {
      ConnectionManage.close(conn);
      ConnectionManage.close(rs);
      ConnectionManage.close(pstmt);
    }
    return areaInfo;
  }
}