package webchurch.push.test;

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

import webchurch.push.dao.PushDAO;
import webchurch.push.dao.PushDAOImpl;
import webchurch.push.model.PushDTO;
import webchurch.push.util.Connector;

public class Test {
	public static void main(String[] args) {
		String sql = "select * from newchurch_info where communityid = ?";
		Connection conn = Connector.getConnection();
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, "20020419040001");
			ResultSet rs = pstmt.executeQuery();
			System.out.println("communityId");
			while(rs.next()){
				System.out.println(rs.getString(1));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		PushDAOImpl pdi = new PushDAOImpl();
		List<String> list = pdi.getAllApiKey();
		System.out.println("list's Size : " + list.size());
		for(String str : list){
			System.out.println(str);
		}
	}
}