ajaxdao.java

来自「AJAX源码,适合初学者上手,一共有3个源码,循序渐进的学习AJAX,这是3」· Java 代码 · 共 72 行

package dao;

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

import dto.AjaxDTO;

public class AjaxDAO {

	private final static String SQL_FINDALLCOUNTRY = "select * from country";

	private final static String SQL_FINDBYCOUNTRYID = "select * from city where country_city_id=?";

	private Connection conn;

	public void setConn(Connection conn) {
		this.conn = conn;
	}

	public List FindAllCountry() {

		List list = new ArrayList();
		try {
			conn = DataSourceFactory.getDataSource().getConnection();
			PreparedStatement ps = conn.prepareStatement(SQL_FINDALLCOUNTRY);
			ResultSet rs = ps.executeQuery();

			while (rs.next()) {
				AjaxDTO dto = new AjaxDTO();
				dto.setCountry_id(rs.getInt(1));
				dto.setCountry(rs.getString(2));
				list.add(dto);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
	}

	
	
	public List FindByCountryId(int id) {

		List list = new ArrayList();
		try {
			conn = DataSourceFactory.getDataSource().getConnection();
			PreparedStatement ps = conn.prepareStatement(SQL_FINDBYCOUNTRYID);
			ps.setInt(1, id);
			ResultSet rs = ps.executeQuery();

			while (rs.next()) {
				AjaxDTO dto = new AjaxDTO();
				dto.setCity_id(rs.getInt(1));
				dto.setCity(rs.getString(2));
				list.add(dto);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
	}
}