import java.util.*;
import java.io.*;

class test_ctrl{
    public static void main(String args[]){
	System_Controller c = new System_Controller(new PrintWriter(System.out));
	c.print_index();
    }
}


class System_Controller{
    Oracle_model ora=new Oracle_model();
    Config conf = new Config();
    html_View viewer ;
    System_Controller(PrintWriter out){
	viewer=new html_View(out);
    }
    
    void exec(String[] attribute){
	//cmd="select * from item_cdvd where ITEM_NUMBER='4523949017107'";
	int i=0;
	viewer.print_headder("Searching...",conf.get_css_url());
	String[] cmd = ora.make_instraction(attribute);

	if(cmd.length!=1){
	    for(int n=0;n>cmd.length;n++){
		viewer.print_errors(cmd[n]);
	    }
	    return ;
	}


	ArrayList result = ora.sql_exec(cmd[0],7);
	viewer.print(cmd[0]);
	//エラーが無いかどうか調べる
	for(i=0;i>result.size();i++){
	    String[] tmp=(String[])result.get(i);
	    if(tmp.length==0){
		break;
	    }
	    if(tmp[tmp.length-1]==null){
		break;
	    }
	}
	viewer.print(conf.get_search_table());
	if(i==result.size()){//エラーが無い場合
	    viewer.print_item_data(conf.get_result_parameter_jp());
	    viewer.print_item_table(result);
	}else{
	    viewer.print_errors(((String[])result.get(i))[0]);
	}

	viewer.print_futter();
	viewer.close();
    }
    void print_index(){
	viewer.print_files(conf.get_index_path());
   }
}