package popten.web;

import popten.db.DBConnect;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;

public class ICata{

private String cata0_name,cata1_name,cata2_name;

public String getcata0_name() { return cata0_name;}
public String getcata1_name() { return cata1_name;}
public String getcata2_name() { return cata2_name;}

public void setcata0_name(String cata0_name) { this.cata0_name = cata0_name; }
public void setcata1_name(String cata1_name) { this.cata1_name = cata1_name; }
public void setcata2_name(String cata2_name) { this.cata2_name = cata2_name; }

public ICata(){}
		/************************
		*	讀出目錄名	*
		************************/
		public ICata loadCataName(String cata0_id,String cata1_id,String cata2_id){
			DBConnect dbc = null;
			ResultSet rs;
			ICata icata = new ICata();
			try{
				dbc  = new DBConnect();
				dbc.prepareStatement("select cata0_name from cata0 where cata0_id=?");
				dbc.setInt(1,Integer.parseInt(cata0_id));
				rs = dbc.executeQuery();
				if(rs.next()){
					icata.setcata0_name(rs.getString("cata0_name"));
				}
				dbc.prepareStatement("select cata1_name from cata1 where cata1_id=?");
				dbc.setInt(1,Integer.parseInt(cata1_id));
				rs = dbc.executeQuery();
				if(rs.next()){
					icata.setcata1_name(rs.getString("cata1_name"));
				}
				dbc.prepareStatement("select cata2_name from cata2 where cata2_id=?");
				dbc.setInt(1,Integer.parseInt(cata2_id));
				rs = dbc.executeQuery();
				if(rs.next()){
					icata.setcata2_name(rs.getString("cata2_name"));
				}
			  }
			catch(Exception e){
				System.err.println(e);
			  }
			finally{
				try{
					dbc.close();
				}
				catch(Exception e){
					e.printStackTrace();
				}
			  }
			return icata;
			}
		}