cityservice.java

jsp 关于注册和登陆还有一些其他功能的jsp网叶

package com.db;
import java.sql.ResultSet;
import java.util.*;


public class CityService {
   public static CityService getInstance(){
	 return  new CityService();
   }
    
   public List<String> getProvince(){
	   List<String> province = new ArrayList<String>();
	   String sql =" SELECT distinct state,sz_code from city "+
	               " where sz_code like '%%0000' order by sz_code";
	    
	   Object param[]=new Object[]{};
	   try {
		  DatabaseConnection db = new DatabaseConnection();
		  ResultSet rs =db.query(sql, param); 
		   
		  while(rs.next()){
			  String data = rs.getString(1); 
			  province.add(data);
		  }
	   } catch (Exception e) {
		   System.out.println(e.getMessage());
	   }	   
	   return province;	   
   }
   
   public List<String> getCity(String province){
	   List<String> city = new ArrayList<String>();
	   String sql =" select city from city "+
	               " where state='"+province+"' and "+
	               " sz_code like '%%%%00' and "+
	               " state<>city order by sz_code";
	   Object param[]=new Object[]{};
	   try {
		  DatabaseConnection db = new DatabaseConnection();
		  ResultSet rs =db.query(sql, param);
		  while(rs!=null && rs.next()){
			  String data = rs.getString(1);
			  city.add(data);
		  }
	   } catch (Exception e) {
		   System.out.println(e.getMessage());
	   }	   
	   return city;
   } 
}