package com.yourcompany.struts;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class QueryDao {
	public List queryProvince()throws Exception {
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		List lst=new ArrayList();
		try{
			conn=new DBConnection().getConnection();
			pstmt=conn.prepareStatement("SELECT * FROM PROVINCE ");
			rs=pstmt.executeQuery();
			while(rs.next()){
				QueryVO vo=new QueryVO();
				vo.setId(rs.getString("ID"));
				vo.setName(rs.getString("PNAME"));
				lst.add(vo);
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return lst;
	}
	public List queryCity(String province_id)throws Exception {
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		List lst=new ArrayList();
		try{
			conn=new DBConnection().getConnection();
			pstmt=conn.prepareStatement("SELECT * FROM CITY WHERE PID=? ");
			pstmt.setInt(1, Integer.parseInt(province_id));
			rs=pstmt.executeQuery();
			while(rs.next()){
				QueryVO vo=new QueryVO();
				vo.setId(rs.getString("ID"));
				vo.setName(rs.getString("CNAME"));
				lst.add(vo);
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return lst;
	}
}